ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RAC数据库连接错误

RAC数据库连接错误

原创 Linux操作系统 作者:lhl1212 时间:2009-09-15 17:11:43 0 删除 编辑

客户端连接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博客 ” ,链接:http://blog.itpub.net/611609/viewspace-614707/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-12-08

  • 博文量
    252
  • 访问量
    489166