10.2.0.1 RAC监听问题

安装完10.2.0.1的RAC后,客户连接到服务器经常报连接失败的错误:



这个是10.2.0.1的一个bug,该问题,可以通过如下方式解决:

rac1
ALTER SYSTEM SET LOCAL_LISTENER = '(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.201)(PORT = 1521))'  scope=both SID = 'racdb1';

rac2
ALTER SYSTEM SET LOCAL_LISTENER = '(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.202)(PORT = 1521))'  scope=both SID = 'racdb2';

重启数据库后,问题不再出现.
注意这里的ip均为节点对应的vip.

-- The End --