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