1. 首页
  2. IT资讯

ORA-12545 问题

今天遇到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/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:深沉的少年,转转请注明出处:http://www.cxybcw.com/183316.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code