配置TAF，连接数据库产生ora-12545

显示全部楼层 · 2014-2-19 11:55:14

我的数据库从8.1.7.4升级到9.2.0.6 RAC结构后，两个节点分别是P570_1、2，配置TAF后，在client端用sqlplus连接数据库居然产生ora-12545，具体配置信息如下：
P570_1 listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.215.41)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /oracle/app/oracle/product/9.2.0)
(SID_NAME = shyz1)
)
)
P570_2 listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.215.42)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /oracle/app/oracle/product/9.2.0)
(SID_NAME = shyz2)
)
)
client tnsnames.ora
SHYZOPS12 =
(DESCRIPTION =
(FAILOVER = ON)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.215.41)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.215.42)(PORT = 1521))
)
(CONNECT_DATA =
(service_name= shyz)
(failover_mode =
(type = session)
#(method = preconnect)
(backup = shyz2)
)
)
)

千问 · 2014-2-19 11:55:14

参考:
http://blog.itpub.net/post/11/4060