连接scan ip出现ORA-12545错误(二)

2014-11-24 18:14:23 · 作者: · 浏览: 1
TION=(ADDRESS_LIST=(AD


DRESS=(PROTOCOL=TCP)(HOST=taia


n-pt-d2-vip)(PORT=1521))))


remote_listener string pdpt-cluster-scan:1521





经Metalink上查找,发现这是11.2.0.1的小bug:“ORA-12545 or ORA-12537 while connecting to RAC through SCAN name[ID 970619.1]”,11.2.0.2及之后的版本就修复好了


Client is able to resolve all Fully Qualified Domain Name (FQDN) SCAN and VIP name but not short ones(without domain name) as its in different domain; even though FQDN names were specified during Grid Infrastructure setup, due to bug 9150053 by default DBCA set database parameter local_listener to short node VIP name while database is created.


因此只要把数据库实例参数local_listener内的host改为vip的IP地址即可。


NODE1:


SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=210.10.4.9)(PORT=1521))))' scope=both sid='PDPT1';


System altered.


SQL> alter system register;


System altered.


NODE2:


SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=210.10.4.10)(PORT=1521))))' scope=both sid='PDPT2';


System altered.


SQL> alter system register;


System altered.




参考:How to Troubleshoot Connectivity Issue with 11gR2 SCAN Name [ID 975457.1]


ORA-12545 or ORA-12537 while connecting to RAC through SCAN name[ID 970619.1]


11.2 Scan and Node TNS Listener Setup Examples [ID 1070607.1]