客户环境：Linux+ oracle 10.2.0.2+RAC
现象：客户端用sqlplus连接统一服务名时报ORA-12545错误。
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
我们先看ORA-12545错误是什么：
[ oracle @orac1 udump]$ oerr ora 12545
12545, 00000, “Connect failed because target host or object does not exist”
// *Cause: The address specified is not valid, or the program being
// connected to does not exist.
// *Action: Ensure the ADDRESS parameters have been entered correctly; the
// most likely incorrect parameter is the node name. Ensure that the
// executable for the server exists (perhaps “ oracle ” is missing.)
// If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
// host name to a numeric IP address and try again.
因为是有时连接成功，有时失败，因此不应该是tnsnames配置问题，于是查了一下metalink，发现是 oracle 的一个小bug:
Note:364855.1：RAC Connection Redirected To Wrong Host/IP ORA-12545
解决方法：
修改初始化参数LOCAL_LISTENER
Node1：
- SQL>ALTER SYSTEM SET LOCAL_LISTENER = '(ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.198.224)(PORT = 1521))' SID = 'SID1';
Node2：
- SQL>ALTER SYSTEM SET LOCAL_LISTENER = '(ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.198.225)(PORT = 1521))' SID = 'SID2';
或者在SERVER上的tnsname.ora文件中添加local listener信息，然后修改初始化参数LOCAL_LISTENER=
No Comments
Be the first to comment on this entry.
Leave a comment
Fields in bold are required. Email addresses are never published or distributed.
Some HTML code is allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>URLs must be fully qualified (eg: http://www.dbifan.com),and all tags must be properly closed.
Line breaks and paragraphs are automatically converted.
Please keep comments relevant. Off-topic, offensive or inappropriate comments may be edited or removed.