1. cat $ORACLE_HOME/network/admin/tnsnames.ora on ora-fsfo-app01
bank01=(DESCRIPTION =(ADDRESS =(PROTOCOL = TCP)(Host = ora-fsfo-db01)(Port = 1521))(CONNECT_DATA = (SERVICE_NAME=bank01)))
bank02=(DESCRIPTION =(ADDRESS =(PROTOCOL = TCP)(Host = ora-fsfo-db02)(Port = 1521))(CONNECT_DATA = (SERVICE_NAME=bank02)))
bank_srv=(DESCRIPTION=(FAILOVER=on)(LOAD_BALANCE=off)(CONNECT_TIMEOUT=1)
(TRANSPORT_CONNECT_TIMEOUT=1)(RETRY_COUNT=1)
(ADDRESS=(PROTOCOL=tcp)(HOST=ora-fsfo-db01)(PORT=1521))
bank01=(DESCRIPTION =(ADDRESS =(PROTOCOL = TCP)(Host = ora-fsfo-db01)(Port = 1521))(CONNECT_DATA = (SERVICE_NAME=bank01)))
bank02=(DESCRIPTION =(ADDRESS =(PROTOCOL = TCP)(Host = ora-fsfo-db02)(Port = 1521))(CONNECT_DATA = (SERVICE_NAME=bank02)))
bank_srv=(DESCRIPTION=(FAILOVER=on)(LOAD_BALANCE=off)(CONNECT_TIMEOUT=1)
(TRANSPORT_CONNECT_TIMEOUT=1)(RETRY_COUNT=1)
(ADDRESS=(PROTOCOL=tcp)(HOST=ora-fsfo-db01)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=ora-fsfo-db02)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=bank_srv)
(FAILOVER_MODE=(TYPE=select)(METHOD=basic)(retries=3)(delay=3))))
2. Starting OBSERVER on ora-fsfo-app01
[ora-fsfo-app01]$ dgmgrl sys/***@bank_srv
(CONNECT_DATA=(SERVICE_NAME=bank_srv)
(FAILOVER_MODE=(TYPE=select)(METHOD=basic)(retries=3)(delay=3))))
2. Starting OBSERVER on ora-fsfo-app01
[ora-fsfo-app01]$ dgmgrl sys/***@bank_srv
stop observer all;
start observer;
-- note
start observer;
-- note
nohup dgmgrl -silent sys/***@bank_srv "start observer prima_observer" &
3. Checking configuration status OBSERVER
DGMGRL> show observer;
4. Checking configuration status ADG
5. Checking $ORA_DIAG/drcbank.log ora-fsfo-db02
# Disabling all observers
DGMGRL> STOP OBSERVER ALL;
Observer stopped.
DGMGRL> STOP OBSERVER ALL;
Observer stopped.
No comments:
Post a Comment