Oracle software installation fails with ClusterwarePRCT-1011: Failed to run “oifcfg” Detailed error:. Null

A few days back, while installing Oracle database software on one of out UAT server I faced this issue. While verifying target environment for minimum requirements, runIstaller failed with error given in screenshot below: After searching on metalink, I found : Failed to initialize GPnP Reported While Executing oifcfg (Doc ID […]

expdp backup on NFS mount point hangs due to Direct NFS: please check that oradism is setuid

Some days before we were trying to schedule expdp schema backup on one of the UAT environments. Expdp command was very simple & as follows: expdp system/manager directory=data_pump_dir dumpfile=uatdb_test1.dmp logfile=uatdb_test1.log schemas=test1 Though schema size was hardly 300 MB, backup was taking ages just to start. Finally I canceled EXPDP session: […]

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. Here’s an excerpt: A New York City subway train holds 1,200 people. This blog was viewed about 4,400 times in 2014. If it were a NYC subway train, it would take about 4 trips to carry that […]

IMPDP with network_link option fails with ORA-39126, ORA-06502, ORA-39127, ORA-44002

Some day before while performing import operation using IMPDP using network_link parameter, I came across this issue. My IMPDP command was as given below: impdp directory=UAT_DIR network_link=MIGRATION_DB_LINK parallel=8 full=y logfile=migration_UATDB_27nov.log exclude=SCHEMA:”in (‘SCOTT’,’ORACLE_OCM’,’XS$NULL’,’MDDATA’,’DIP’,’APEX_PUBLIC_USER’,’SPATIAL_CSW_ADMIN_USR’,’SPATIAL_WFS_ADMIN_USR’,’DMSYS’,’DBSNMP’,’FLOWS_FILES’,’MDSYS’,’ORDSYS’,’EXFSYS’,’WMSYS’,’APPQOSSYS’,’APEX_030200′,’OWBSYS_AUDIT’,’ORDDATA’,’CTXSYS’,’ANONYMOUS’,’XDB’,’ORDPLUGINS’,’OWBSYS’,’SI_INFORMTN_SCHEMA’,’OLAPSYS’,’SYS’,’SYSTEM’,’OUTLN’)” I got following error, before it got terminated due to fatal error: Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA ORA-39127: unexpected error […]

ORA-12801: error signaled in parallel query + ORA-04031: unable to allocate 65560 bytes of shared memory (“large pool”)

Yesterday I got request from one of the user saying his job failed giving following error: Severity Timestamp Node Thread Message Code Message ERROR 2014/10/24 02:59:32 PM node-uat-informatika READER_1_1_1 RR_4035 SQL Error [ ORA-12801: error signaled in parallel query server P178, instance rmb-uat-db-gik1:DBGIK1 (1) ORA-12853: insufficient memory for PX buffers: […]