Automatic Restart of Databases during Switchover fail with ORA-12514 in DGMGRL (Doc ID 308943.1)

Last updated on OCTOBER 26, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Performing a switchover operation in a DataGuard environment requires a shutdown of both the (former) primary database and the (former) standby database. 

During Switchover using DGMGRL the Databases need to be restarted (these symptoms could happen with any operation in DGMGRL that requires an automatic database restart).

The automatic restart of the databases fails with

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

The error in DGMGRL may look like this:

Operation requires startup of instance "DG1" on database "Primary".
Starting instance "DG1"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Failed.
You are no longer connected to ORACLE
Please connect again.
Unable to start instance "DG1".
You must start instance "DG1" manually.

Changes

One of the documented prerequisites for first use from the DataGuard Broker manual requires that a special entry be set up in each relevant listener.ora file to enable DGMGRL to automatically startup databases included in this configuration.  Failure to execute this prerequisite will result in the above mentioned symptoms upon switchover. 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms