Oracle 10g Data Guard listener.ora entries

by Chris Hall/December 1, 2016

The following entries must be in the listener.ora file for Data Guard to work successfully, this is needed if DYNAMIC_REGISTRATION_LISTENER is set to OFF and you have manually configured Data Guard via the command line. Oracle 10.2.0.5.6 on Solaris.

(SID_DESC=

(GLOBAL_DBNAME=[sid].world)

(SID_NAME=[sid])

(ORACLE_HOME=/opt/oracle/product/10.2.0))

 

(SID_DESC=

(GLOBAL_DBNAME=[sid]_xpt.world)

(SID_NAME=[sid])

(ORACLE_HOME=/opt/oracle/product/10.2.0))

 

(SID_DESC=

(GLOBAL_DBNAME=[sid]_DGMGRL.world)

(SID_NAME=[sid])

(ORACLE_HOME=/opt/oracle/product/10.2.0))

 

(SID_DESC=

(GLOBAL_DBNAME=[sid]_dgb.world)

(SID_NAME=[sid])

(ORACLE_HOME=/opt/oracle/product/10.2.0))