ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-12545 问题

ORA-12545 问题

原创 Linux操作系统 作者:gaopengtttt 时间:2013-10-15 15:39:26 0 删除 编辑
今天遇到ORA-12545问题一直以为设置了LOCAL_LISTENER参数就没有问题,但是今天能遇的问题是设置了LOCAL_LISTENER没有问题,但是还是报错,这种情况下在客户端HOSTS中把RAC的HOSTS下面的内容复制上去,让他能够解析
ORACLE 官方:


Client Connection to RAC Intermittently Fails-ORA-12545 TNS: Host or Object Does not Exist (Doc ID 364855.1)

Log in with privileges to the instance and issue the following commands so that LOCAL_LISTENER is set correctly:

 

alter system set LOCAL_LISTENER="(address=(protocol=tcp)(port=1521)(host=)) scope=both sid='INSTANCE_NAME1';

Do the same for the 2nd instance where host is set to the and the sid is set to the 2nd instance name.

alter system set LOCAL_LISTENER="(address=(protocol=tcp)(port=1521)(host=)) scope=both sid='INSTANCE_NAME2'; 


Now the correct address using the VIP hostname will be registered against the listeners in the cluster.

The client should be able to resolve all forms of the VIP host via their /etc/hosts file.  i.e. short name and fully qualified.


Clients Failing to Connect Due to Intermittent ORA-12545 in RAC Environment (Doc ID 291175.1)

Edit the /etc/hosts file or winnt/system32/drivers/etc/hosts file.  Add a mapping for whatever hostname is not being resolved.  For example:


1.1.1.103    myhost.oracle.com   myhost

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7728585/viewspace-774415/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 外键加索引问题
请登录后发表评论 登录
全部评论
wxh gp_22389860 <<深入理解MySQL主从原理专栏>> 发布 可加WX了解

注册时间:2008-10-13

  • 博文量
    718
  • 访问量
    3035565