Tuesday 1 February 2022

What is ORA-39095 ?

 What is ORA-39095 ?


. . exported "XXX"."YYYY"    80.85 KB  12 rows

ORA-39095: Dump file space has been exhausted: Unable to allocate 4096/8192 bytes

Job "XXX"."SYS_EXPORT_SCHEMA_02" stopped due to fatal error at Wed Feb 2 01:08:16 2021 elapsed 0 04:56:30

Answer: 

There are two solutions.

1- Increasing the Filesize parameter

2- Changing the dumpfile parameter as %U.dmp in order to create multiple dump files while exporting.

Example: expdp xx/yyyy directory=fx_dir dumpfile=example_%U.dmp logfile=example.log full=y filesize=10G

Notes: Check the schema size before transferring.
Because If a total of 99 dmp files are created and export is not finished, the ORA-39095 error will still be received.

Happy day everyone..

Monday 9 February 2015

java.lang.RuntimeException: com.intellij.ide.plugins.PluginManager$StartupAbortedException: Fatal error initializing 'com.intellij.openapi.util.registry.RegistryState' --> Macbook not runnig Android Studio(SOLVED)

I already have Android Studio on my Mac (Yosemite 10.10.1). Also I wanted to install Android Studio without any problem. But  Android Studio couldn't start and I got following error message:


java.lang.RuntimeException: com.intellij.ide.plugins.PluginManager$StartupAbortedException: Fatal error initializing 'com.intellij.openapi.util.registry.RegistryState'
 at com.intellij.idea.IdeaApplication.run(IdeaApplication.java:166)
 at com.intellij.idea.MainImpl$1$1$1.run(MainImpl.java:46)
 at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
 at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:744)
 at java.awt.EventQueue.access$400(EventQueue.java:97)
 at java.awt.EventQueue$3.run(EventQueue.java:697)
 at java.awt.EventQueue$3.run(EventQueue.java:691)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:714)
 at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:364)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
 at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
 at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: com.intellij.ide.plugins.PluginManager$StartupAbortedException: Fatal error initializing 'com.intellij.openapi.util.registry.RegistryState'
 at com.intellij.ide.plugins.PluginManager.handleComponentError(PluginManager.java:248)
 at com.intellij.openapi.components.impl.PlatformComponentManagerImpl.handleInitComponentError(PlatformComponentManagerImpl.java:39)
 at com.intellij.openapi.components.impl.ComponentManagerImpl$ComponentConfigComponentAdapter$1.getComponentInstance(ComponentManagerImpl.java:585)
 at com.intellij.openapi.components.impl.ComponentManagerImpl$ComponentConfigComponentAdapter.getComponentInstance(ComponentManagerImpl.java:605)
 at com.intellij.util.pico.DefaultPicoContainer.getLocalInstance(DefaultPicoContainer.java:236)
 at com.intellij.util.pico.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:223)
 at com.intellij.util.pico.DefaultPicoContainer.getComponentInstance(DefaultPicoContainer.java:210)
 at org.picocontainer.alternatives.AbstractDelegatingMutablePicoContainer.getComponentInstance(AbstractDelegatingMutablePicoContainer.java:75)
 at com.intellij.openapi.components.impl.ComponentManagerImpl.createComponent(ComponentManagerImpl.java:124)
 at com.intellij.openapi.application.impl.ApplicationImpl.createComponent(ApplicationImpl.java:357)
 at com.intellij.openapi.components.impl.ComponentManagerImpl.createComponents(ComponentManagerImpl.java:115)
 at com.intellij.openapi.components.impl.ComponentManagerImpl.init(ComponentManagerImpl.java:86)
 at com.intellij.openapi.components.impl.stores.ApplicationStoreImpl.load(ApplicationStoreImpl.java:110)
 at com.intellij.openapi.application.impl.ApplicationImpl.load(ApplicationImpl.java:510)
 at com.intellij.openapi.application.impl.ApplicationImpl.load(ApplicationImpl.java:492)
 at com.intellij.idea.IdeaApplication.run(IdeaApplication.java:158)
Solve:
My computer's language was Turkish. After I changed it from regional settings as 
English, the problem solved. 

Monday 29 December 2014

Oracle Rman İle Backup Alma

Merhaba,

Bu yazıda Rman ile nasıl backup alabileceğinize değineceğim. Alttaki adımları izleyerek rman ile backup alabilirsiniz.

dummys oracle@tst2:/home/oracle>rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Dec 29 15:43:01 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DUMMY (DBID=1621295373, not open)

RMAN> backup database;  Bu komut ile alabilirsiniz.

Starting backup at 29/12/2014 15:43:11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATADG/dummys/datafile/system.257.45325324
input datafile file number=00002 name=+DATADG/dummys/datafile/sysaux.258..45325324
input datafile file number=00003 name=+DATADG/dummys/datafile/undotbs1.259..45325324
input datafile file number=00004 name=+DATADG/dummys/datafile/users.261..45325324
input datafile file number=00005 name=+DATADG/dummys/datafile/example.260..45325324
channel ORA_DISK_1: starting piece 1 at 29/12/2014 15:43:12
channel ORA_DISK_1: finished piece 1 at 29/12/2014 15:43:27
piece handle=+DATADG/dummys/backupset/2014_12_29/nnndf0_tag20141229t154312_0.304.867598993 tag=TAG20141229T154312 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 29/12/2014 15:43:29
channel ORA_DISK_1: finished piece 1 at 29/12/2014 15:43:30
piece handle=+DATADG/dummys/backupset/2014_12_29/ncsnf0_tag20141229t154312_0.303.867599009 tag=TAG20141229T154312 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 29/12/2014 15:43:30

Aldığınıx backupı görmek isterseniz'de alttaki komut işinize yarayacaktır.

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time  
------- ---- -- ---------- ----------- ------------ -------------------
1       Full    1.62G      DISK        00:00:11     29/12/2014 15:43:23
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20141229T154312
        Piece Name: +DATADG/dummys/backupset/2014_12_29/nnndf0_tag20141229t154312_0.304.867598993
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 16192445   29/12/2014 10:00:03 +DATADG/dummys/datafile/system.257.45325324
  2       Full 16192445   29/12/2014 10:00:03 +DATADG/dummys/datafile/sysaux.258.45325324
  3       Full 16192445   29/12/2014 10:00:03 +DATADG/dummys/datafile/undotbs1.259.45325324
  4       Full 16192445   29/12/2014 10:00:03 +DATADG/dummys/datafile/users.261.45325324
  5       Full 16192445   29/12/2014 10:00:03 +DATADG/dummys/datafile/example.260.45325324

BS Key  Type LV Size       Device Type Elapsed Time Completion Time  
------- ---- -- ---------- ----------- ------------ -------------------
2       Full    8.14M      DISK        00:00:02     29/12/2014 15:43:29
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20141229T154312
        Piece Name: +DATADG/dummys/backupset/2014_12_29/ncsnf0_tag20141229t154312_0.303.867599009
  SPFILE Included: Modification time: 26/07/2014 20:27:11
  SPFILE db_unique_name: DUMMYS
  Standby Control File Included: Ckp SCN: 16192445     Ckp time: 29/12/2014 10:00:03

Hepsi bu kadar.

Sevgiyle kalın...