TNS for Primary and Standby:: (failover)
PRDmydb =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER=ON)(LOAD_BALANCE=ON)(CONNECT_TIMEOUT=10)(RETRY_COUNT=3)
(ADDRESS=(PROTOCOL=TCP)(HOST=mydbwldbprd001.int.bellmts.ca)(PORT=6123))
(ADDRESS=(PROTOCOL=TCP)(HOST=mydbwldbprd002.int.bellmts.ca)(PORT=6123))
)
(CONNECT_DATA =(SERVICE_NAME = prdmydb)(FAILOVER_MODE = (TYPE=SELECT)(METHOD=BASIC))
)
)
Basic TNS:
dbalias=
(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = uimwldbprd001.int.bellmts.ca)(PORT = 1521))
(LOAD_BALANCE = on)(CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = dbservice)))
PRDmydb =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER=ON)(LOAD_BALANCE=ON)(CONNECT_TIMEOUT=10)(RETRY_COUNT=3)
(ADDRESS=(PROTOCOL=TCP)(HOST=mydbwldbprd001.int.bellmts.ca)(PORT=6123))
(ADDRESS=(PROTOCOL=TCP)(HOST=mydbwldbprd002.int.bellmts.ca)(PORT=6123))
)
(CONNECT_DATA =(SERVICE_NAME = prdmydb)(FAILOVER_MODE = (TYPE=SELECT)(METHOD=BASIC))
)
)
Basic TNS:
dbalias=
(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = uimwldbprd001.int.bellmts.ca)(PORT = 1521))
(LOAD_BALANCE = on)(CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = dbservice)))
No comments:
Post a Comment