Oracle 10g Data Guard listener.ora entries

ByChris Hall

Oracle 10g Data Guard listener.ora entries

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))

About the author

Chris Hall administrator

Leave a Reply