How to Migrate characterset of 12c database using Database Migration Assistant for Unicode (DMU) Tool

This post will help you to convert characterset of database from WE8ISO8859P15 to AL32UTF8 in 12C. From 12c you will need to use DMU tool for characterset conversion instead of traditional method of CSSCAN & CSALTER. DMU is the Database Migration Assistant for Unicode . It converts the NLS_CHARACTERSET of an existing […]

2015 in review

The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog. Here’s an excerpt: The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 22,000 times in 2015. If it were a concert at Sydney Opera House, it would take about 8 […]

RMAN restore database fails with ORA-19693: backup piece XXX already included.

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

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