DataGaurd ever so close to working
edited Feb 22, 2010 5:46AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 6 commentsAnswered
I have 2 servers that are in physical DG setup. I have them where I can issue the switchover command vis DGMGRL. The servers switch roles but then I have to manually start them up.
Here is my listener.ora:
SID_LIST_LISTENER =
(SID_LIST = (SID_DESC =
(GLOBAL_DBNAME = SND_P_DGMGRL.WORLD)
(SDU = 32768)
(SID_NAME = SND)
(ORACLE_HOME = /oracle/SND/102_64)
))
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sap###.#####.com)(PORT = 1527))
))
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER = OFF
TRACE_LEVEL_LISTENER = OFF
CONNECT_TIMEOUT_LISTENER = 10
STARTUP_WAIT_TIME_LISTENER = 0
my sqlnet.ora:
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = WORLD
0