Few days back, I was working on one of the UAT environments so as to drop columns from 2 tables which were already set to unused as per request from one of my application team. Note: For identifying unused columns for any table, you need to query dba_tab_cols view as […]
One of the biggest challenges for DBAs is the lack of disk space especially for the backups. Two days before, I came across the situation where I was need to do export/import schema from UAT to DEV, but none of the mount points on filesystem were having sufficient space available […]
Yesterday I was recreating DR database with production database backup, when restore database command failed with error: ORA-19693 RMAN> restore database; Starting restore at 05-AUG-15 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to G:\OPDB\REPOSITORY\DATABASE112_SE_X64\ORADATA\OPDB\SYSTEM01.DBF […]
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 […]
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 […]
Some days before I came across very weird issue with SQL Developer. One of the developer in my company was complaining that, she is getting “no rows selected” after executing some select query. According to her it was an unexpected behaviour & expecting some rows from that query. After having […]
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: […]
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 […]
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 […]
We got issue in one of the production environment, RMAN archivelog backup was failing with following errors: kgefec: fatal error 0 kgepop: no error frame to pop to for error 603 We were using following command in rcv file to backup archivelogs: BACKUP archivelog all delete input; After searching on […]
Adityanath's Oracle Blog 