hi,
i am trying to setup a data guard broker (eventually i also want to setup TAF from the client side) and i have following in my listener.ora file
--listener entries on db server1
listener=
(description=
(address=(protocol=TCP)(host=<actual ip>)(port=1521))
)
SID_LIST_LISTENER =
(SID_LIST =
( SID_DESC =
(SID_NAME = GDEVDG1)
(GLOBAL_DBNAME=GDEVDG1_DGMGRL.world)
(ORACLE_HOME = /u00/app/oracle/product/10G/RDBMS)
)
)
--listener entries on db server2
listener=
(description=
(address=(protocol=TCP)(host=<actual ip>)(port=1521))
)
SID_LIST_LISTENER =
(SID_LIST =
( SID_DESC =
(SID_NAME = GDEVDG2)
(GLOBAL_DBNAME=GDEVDG2_DGMGRL.world)
(ORACLE_HOME = /u00/app/oracle/product/10G/RDBMS)
)
)
when i enable the configuration this is what broker does
ALTER SYSTEM SET log_archive_dest_2='service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=<actual host name>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=GDEVDG2_XPT)(INSTANCE_NAME=GDEVDG2)(SERVER=dedicated)))"',' LGWR SYNC AFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="GDEVDG2" register net_timeout=180 valid_for=online_logfile,primary_role)' SCOPE=BOTH;
i am wondering why it is using GDEVDG2_XPT as a service name
to begin with i set it to
log_archive_dest_2='SERVICE=GDEVDG2.world LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=GDEVDG2'
because it cannot connect to GDEVDG2_XPT service name it is giving me error
PING[ARC1]: Heartbeat failed to connect to standby '(DESCRIPTION=(ADDRESS_LIST=(
ADDRESS=(PROTOCOL=tcp)(HOST=gls2dvdb02)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=
GDEVDG2_XPT)(INSTANCE_NAME=GDEVDG2)(SERVER=dedicated)))'. Error is 12514.
lsnrctl services is showing following services on standby node
Service "GDEVDG2_DGMGRL.world" has 1 instance(s).
Instance "GDEVDG2", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:4 refused:0
LOCAL SERVER
The command completed successfully
and lsnrctl status is showing
Service "GDEVDG2_DGMGRL.world" has 1 instance(s).
Instance "GDEVDG2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
anyone had same/similar issue?
i really appreciate your help
thank you,
Pakya