今天裝好aix rac for 11gR2,用客戶端連線配置好的scan 名,利用tnsping 服務名時能正常連線

然後sqlplus 時報ORA-12545 目標主機不存在的錯誤

11gR2 版本預設會把local_listener引數配置上去,如以下格式

show parameter local_listener

local_listener

'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=p550-vip)(PORT=1521))))'

host對應的是vip name,而不是vip 地址,這是因為在11gR2 dbca 建立資料庫時自動新增上去的

而vip name在對應客戶端無法解析這個主機名,才出現ORA-12545錯誤

兩種解決方法:

1database級別

把local_listenener引數改成vip地址即可

語法如下:

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=eyrac1fv.us.oracle.com)(PORT=1521))))' sid='b2no1';

Or

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=120.0.0.211)(PORT=1521))))' sid='b2no1';

And register with listener:

SQL> alter system register;

然後客戶端連線正常

2.client級別

Per client setting:

Specify FQDN SCAN name in client tnsnames.ora and add all node VIP name/IP pairs to hosts file:

grep eyrac1fv /etc/hosts
120.0.0.211 eyrac1fv.us.oracle.com eyrac1fv

Or set search domain: in /etc/resolv.conf on Linux/Unix or "Append DNS suffixes" on Windows

Linux/Unix:

grep search /etc/resolv.conf
search us.oracle.com

Windows:

Network Connection => Property for Public Network => Internet Protocol (TCP/IP) => Advanced => DNS => Append these DNS suffices (in order)

可以參考metalink ID 970619.1 ,這個問題在11.2.0.2版本中修復。

oracle 客戶端連線11gR2 SCAN 報ORA-12545錯誤

相關文章