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

Symptom:

After Switchover/failover using DGMGRL Error ORA-12514 appear. Though the switchover itself was successful but the new primary failed to startup and showing error ORA-12514.

 

Cause:

DGMGRL is unable to connect to the database because of missing entry in listener.ora file.

 

Solution:

Add GLOBAL_DBNAME in listener file in primary and standby database that is using by DGMGRL. The GLOBAL_DBNAME value should be a combination of the db_name and the domain name: e. g. db_unique_name_DGMGRL.db_domain. Service must be register.

 

SID_LIST_LISTENER =

( SID_LIST =

( SID_DESC =

( GLOBAL_DBNAME = <db_unique_name>_DGMGRL.<db_domain> )

( SID_NAME = <ORACLE_SID> )

( ORACLE_HOME = <ORACLE_HOME> )

( SERVICE_NAME = <db_unique_name>.<db_domain> )

 )

)

 

Example:

SID_LIST_LISTENER =

( SID_LIST =

( SID_DESC =

( GLOBAL_DBNAME = DB1_DGMGRL.world)

( SID_NAME = DB1)

( ORACLE_HOME = opt/oracle/product/11.2.0.3)

( SERVICE_NAME = DB1.world)

 )

)

 

Note: "StaticConnectIdentifier” introduced in 11gR2. DGMGRL client use the value set in "StaticConnectIdentifier” when starting database. In this case the above entry in listener.ora is not needed anymore but obviously the specific connection identifier should still be a Static Listener entry.

Oracle Support Doc ID 308943.1

Comments