Administration

Startup RAC database using SRVCTL fails with : ORA-12547: TNS:lost contact & CRS-2632

Two days before while starting our UAT database using SRVCTL, I received following error: [oracle@srv-uat-db-gen1 ~] Ora:BIIBDPRD $ srvctl start database -d BIIBDPRD PRCR-1079 : Failed to start resource ora.biibdprd.db ORA-12547: TNS:lost contact CRS-5017: The resource action “ora.biibdprd.db start” encountered the following error: ORA-12547: TNS:lost contact . For details refer […]

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: […]

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: […]