Monthly Archives: July 2012

expdp Segmentation Fault (Core Dumped)

One I had to export specific set of rows from bunch of tables. When I executed, the expdp with CLI, it error out with Segmentation Fault (Core Dumped) . Later I found of that it’s the CLI limitation i.e. we can’t … Continue reading

Posted in Oracle Data Pump | Tagged | Leave a comment

Expdp fails with ORA-31693, ORA-01555

Sometimes, expdp export will fail with following error stack. SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT ORA-31693: Table data object “SCOTT”.”TAB5″ failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-01555: snapshot too old: rollback segment number 7 with name … Continue reading

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

Oracle GPnP (Grid Plug n Play) Profile

What information is stored in GPnP profile GPnP along with OLR have enough information, which is sufficient enough to form a cluster. So dependency on OCR is greatly reduced (not eliminated). GPnP is managed by GPnPD (Grid plug and play … Continue reading

Posted in Oracle 11.2.0.x, Oracle Cluster Ready Services, Oracle Grid, Oracle Real Application Cluster | Tagged | 2 Comments

Voting disk changes in Oracle 11gR2

There are few noticeable changes made in 11gR2 specific to voting disks. As we are aware that Voting disk and OCR can now be stored in ASM. But we also know in previous versions, CSS need voting disk to start. … Continue reading

Posted in Oracle 11.2.0.x, Oracle 11g Enhancements, Oracle Cluster Ready Services, Oracle Grid, Oracle Real Application Cluster | Tagged | 1 Comment

Oracle 11.2 Datapump ORA-31617, ORA-19505, ORA-27037

On a RAC setup, when I was performing an expdp export, it error out with following stack expdp dumpfile=test_%u.dmp logfile=test.log directory=temp_expdp schemas=test parallel=4 Multiple errors similar to following ORA-31693: Table data object “TEST”.”TEST_15″ failed to load/unload and is being skipped … Continue reading

Posted in Oracle Data Pump | Tagged , , | 1 Comment