客户端连接RAC数据库报错
linux AS4U7 10204 RAC 客户端windowds 10201
网路服务名：
test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = newsdb1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = newsdb2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dyora)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
客户端连接使用test网络服务名连接数据库报错！一次连接成功后，下次连接失败！
Oracle在文档Note:364855.1：RAC Connection Redirected To Wrong Host/IP ORA-12545中进行了相信的描述。
并给出了解决方法：修改数据库中的初始化参数LOCAL_LISTENER：
ALTER SYSTEM SET LOCAL_LISTENER = ‘(ADDRESS = (PROTOCOL = TCP)(HOST = newsdb1-vip)(PORT = 1521))’ scope=both sid=’newsdb1′;
ALTER SYSTEM SET LOCAL_LISTENER = ‘(ADDRESS = (PROTOCOL = TCP)(HOST = newsdb2-vip)(PORT = 1521))’ scope=both sid=’newsdb2′;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/611609/viewspace-614707/ ，如需转载，请注明出处，否则将追究法律责任。
