Category Archives: Oracle

How to Reconfigure Oracle Restart | ASM startup fail with ORA-29701.

How to Reconfigure Oracle Restart : Cause: Today I faced one issue while cloning my VM for making a dataguard server, I done the server name change while crs was up and running and end up in ASM startup failure. … Continue reading

Posted in Oracle, Oracle RAC | Tagged , | Leave a comment

Enterprise Manager Cloud Control 13C Installation (Step by Step with all screen Shoots)

13c_re_work

Posted in Oracle, Oracle RAC | Tagged , | Leave a comment

Steps for RMAN Restore backup of lower version database to a higher version

Source DB Name       :   TESTDB Source DB Version     :   11.2.0.1.0 Source DB Host Name   :   HOSTNAME_1 Target DB Name       :   TESTDB Target DB Version     :   11.2.0.4 Target DB Host Name   :   HOSTNAME_2   Step-1 ===== Installing the Oracle binary version … Continue reading

Posted in Oracle | Leave a comment

ORA-12801,ORA-12853,ORA-04031

Error details: ————- ORA-12801: error signaled in parallel query server P026, instance my_server:mydb (2) ORA-12853: insufficient memory for PX buffers: current 323904K, max needed 2673360K ORA-04031: unable to allocate 65560 bytes of shared memory (“large pool”,”unknown object”,”large pool”,”PX msg pool”) … Continue reading

Posted in Oracle | Tagged , , , | Leave a comment

Oracle datapump Import (IMPDP) fails due to Error ORA-31693,ORA-31640,ORA-19505,ORA-27037 Oracle 11gR2

Error Details: ============== ORA-31693: Table data object “COMMON”.”LOC_ITEM_DSPTCH_SPEC” failed to load/unload and is being skipped due to error: ORA-31640: unable to open dump file “/dev/shm/Q1051842/OMS_O_CUST_COMMON.dmp” for read ORA-19505: failed to identify file “/dev/shm/Q1051842/OMS_O_CUST_COMMON.dmp” ORA-27037: unable to obtain file status Linux-x86_64 … Continue reading

Posted in Oracle, Oracle RAC | Tagged , , , , | Leave a comment

Oracle datapump Import fails due to Error ORA-04030 Oracle 11gR2

=========================================================== ORA-39014,ORA-39029,ORA-31671,ORA-04030,ORA-06512,ORA-06512 =========================================================== Error: —– Starting “SYS”.”IMP_SCHEMA4″: /******** AS SYSDBA parfile=test.par Processing object type SCHEMA_EXPORT/USER ORA-31684: Object type USER:”XYZ” already exists Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type … Continue reading

Posted in Oracle | Tagged , , , , , | Leave a comment

Recovery of a Missing Datafile that has no backups (database is open).

Datafile Lost due to OS level delete: ===================================== Recovery of a Missing Datafile that has no backups (database is open). If a non system datafile that was not backed up since the last backup is missing, recovery can be performed … Continue reading

Posted in Oracle | Tagged , , , | 3 Comments