Monthly Archives: February 2015

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