备注： 监听文件一般格式如下，一旦激活standby后，如果SID与primary 库不一致，可能
导致需要更改大量客户端tnsnames.ora文件，我们可以设置激活后的standby 中的global_dbname,
使之与primary DB的SID(也就是客户端设置的SERVICE_NAME)一致 。
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/product/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = teststby)
(ORACLE_HOME = /u01/product/oracle)
(GLOBAL_DBNAME = test11g) ------ 修改这里的teststby为test11g即可。
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.24.133)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
客户端连接仍然保持如下可以连接SID=teststby的激活后的DB ：
ORA11G_TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.24.133)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test11g)
)
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/35489/viewspace-672476/ ，如需转载，请注明出处，否则将追究法律责任。
