ORA-12545 / TNS-12545

ORA-12545 / TNS-12545:

rac配置了 local_listener也会有ora-12545 --处理方法

2009-12-17 21:38

甚至有时会出现一种情况：

有时能用有时会报ora-12545

日前在itpub上也刚刚帮人处理了个这样的问题：

问题：

rac 环境 ora-12545 错误 local_listener已经配了

local_listener 两个节点都配了
还是ora-12545麻烦各位看看什么问题

hosts
#private network-eth1
10.0.0.19 moon-priv
10.0.0.21 sun-priv

#public network-eth0
192.168.1.19 moon
192.168.1.21 sun

#public virtul ip -eth0
192.168.1.20 moon-vip
192.168.1.22 sun-vip

SQL> show parameter local

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL = TCP)(HO
ST = sun-vip)(PORT = 1521))
log_archive_local_first boolean TRUE
SQL> show parameter remote

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_archive_enable string true
remote_dependencies_mode string TIMESTAMP
remote_listener string leetaf
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE

lsnrctl service
...
...
...
Service "leetaf" has 2 instance(s).
Instance "leerac1", status READY, has 2 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=moon-vip)(PORT=1521))
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Instance "leerac2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=sun-vip)(PORT=1521))
The command completed successfully

客户端
tnsnames.ora
。。。
。。。
leerac1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = leetaf)
(INSTANCE_NAME = leerac1)
)
)

leerac2=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.22)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = leetaf)
(INSTANCE_NAME = leerac2)
)
)

leetaf2 =
(DESCRIPTION =
(LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.22)(PORT = 1521))
(connect_data=(SERVICE_NAME = leetaf))
)

连接时候总报错
ora-12545 因目标主机或对象不存在，连接失败

答案：

客户端
tnsnames.ora
。。。
。。。
leerac1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = leetaf)
(INSTANCE_NAME = leerac1)
)
)

leerac2=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.22)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = leetaf)
(INSTANCE_NAME = leerac2)
)
)



leetaf2 =
(DESCRIPTION =
(LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.22)(PORT = 1521))
(connect_data=(SERVICE_NAME = leetaf))
)


试试上面不要这样写，而采用下面的方式：
修改/etc/hosts加上
192.168.1.20 moon-vip
192.168.1.22 sun-vip

然后tnsnames.ora里面不要直接用ip,而是用moon-vip和sun-vip
再不行把
#public network-eth0
192.168.1.19 moon
192.168.1.21 sun
也加到hosts文件里

如果windows就改 system32/drivers/etc/hosts

结果：

回复 #10 wa0362 的帖子

加了在客户端配了 hosts 好了

帖子连接：http://www.itpub.net/viewthread.php?tid=1247264&extra=&page=1

猜测两种可能的原因：以下内容纯属猜测，没找到官方文档证明

当有监听器的LOAD_BALANCE时 ,每当client建立一个链接的时候listener是需要给client一个地址去连接的，但是它给的并不是ip，而是给的hostname,所以客户端再用这个hostname去链接的时候自然就要报"ora-12545 因目标主机或对象不存在，连接失败"

或者是假如要被重定向到remote listener是会用hostname去连接，而如果是local listener则因为已经建立连接就会能成功

nnd,白猜了，metalink找到官方证据了：[ID 553328.1]

Problem : Client connections to RAC database servers fail with ORA-12545 / TNS-12545

Cause: One of the hostname (which corresponds to public IP or VIP) is not reachable from this client machine.
When the server side load balancing is enabled in the RAC setup, the listener will redirect the connection to the least loaded node.While doing so, the server sends the packet NSPTRD containing the hostname of the corresponding machine.

from:

http://hi.baidu.com/wa0362/blog/item/93e400eff3a0abe4cf1b3e03.html/cmtid/7eb3621f21c3c76ff724e4a9