Database Blog

12c introduces the Parallel Upgrade Utility

Posted by : Unknown   Introduction  This post demonstrates the parallel upgrade utility in 12c . Note : Oracle Database 12c introduces the Parallel Upgrade Utility (catctl.pl), which enables components…

Read More

How to determine if an index needs to be rebuilt.

Posted by : Unknown   This Post demonstrates to determine if an index needs to be rebuilt. We can get an idea of the current state of the index by…

Read More

RMAN-06613: Connect identifier for DB_UNIQUE_NAME DBNAME_DGS not configured

Posted by : Sundaravel Ramasubbu   RMAN-06613: Connect identifier for DB_UNIQUE_NAME DBNAME_DGS not configured   This Post demonstrates the Rman backup is failed with the error RMAN-06613: Connect identifier for…

Read More

OPATCH FAILED WITH ERROR CODE 73

Posted by : Gangainathan   This Post demonstrates about the Opatch failure SQL> select name,open_mode from v$database; NAME      OPEN_MODE ——— ——————– DOYEYDB  READ WRITE SQL> shut immediate; Database closed. Database…

Read More

ORA-17502: ksfdcre:4 Failed to create file “FILE NAME” / ORA-15173: entry ‘string’ does not exist in directory ‘string’

Posted by : Mahe    ORA-17502: ksfdcre:4 Failed to create file “FILE NAME” / ORA-15173: entry ‘string’ does not exist in directory ‘string’ RMAN> restore spfile from ‘+FRA/SRPRIMT/AUTOBACKUP/2016_07_10/s_788290484.315.788290487’; Starting restore at 10-JUL-16 using…

Read More

The Data Guard status of xxxx is Error ORA-03135: connection lost contact from Primary database

Posted by : Karthick   This Post demonstrates the Dataguard status connection lost contact from Primary database The Data Guard status of xxxx is Error ORA-03135: connection lost contact from Primary…

Read More

Backup Fails Because of Control File Enqueue : ORA-00230

Posted by : Mahe   This post will demonstrate the Backup Failure because of Control File Enqueue Error : RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002:…

Read More

Enable Trace and take Tkprof

Posted by  : Unknown   This Post will demonstrate to enabling the trace and take tkprof   Step 1 : Check Request ID from Find Concurrent request screen (In my case…

Read More

Steps to Modify Scan listener port number

Posted by : Selvakumar Raja   This Post will demonstrate the Steps to Modify Scan listener port . Due to security reasons some of environment require using a different port…

Read More

Oracle – Data Guard Broker Setup

Posted by Sundaravel Ramasubbu Introduction : In this session we will see How to set up Data Guard Broker. NOTE: Environment in my case Prerequisite Check DG_BROKER_START parameter on Primary and…

Read More