TNS-01184: Listener rejected registration or update of service handler &quot

evdblue

环境：RHEL5 64bit+ORACLE10.2.0.4 RAC，进行数据迁移，迁移成功后进行连接测试，报告：TNS-01184: Listener rejected registration or update of service handler "DEDICATED" 错误；进行排查，tnsping各个节点实例及服务名均没有问题，怀疑是否防火墙没有打开5000之上的端口，造成连接请求时，服务器无法返回连接端口，通过测试并询问网络工程师，证明端口都正常开启，非常奇怪，后查看监听配置信息发现，监听配置重叠，造成远端监听无法解析，修改后测试一切正常，修改后监听信息：

节点１：

节点２：

由于是数据迁移，在迁移之前，添加时在一个节点上运行的脚本，并没有确定实例名，而用SCOPE=BOTH，所以造成重叠，查看日志如下：

节点1:
ALTER SYSTEM SET local_listener='(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bj-mini-xhm-3f2-dl580-db1-vip)(PORT=152
2))(ADDRESS=(PROTOCOL=TCP)(HOST=10.142.145.7)(PORT=1522))))' SCOPE=BOTH;
Tue Jul 26 15:16:25 2011
ALTER SYSTEM SET remote_listener='(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bj-mini-xhm-3f2-dl580-db2-vip)(PORT=15
22))(ADDRESS=(PROTOCOL=TCP)(HOST=10.142.145.8)(PORT=1522))))' SCOPE=BOTH;

节点2：
ALTER SYSTEM SET local_listener='(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bj-mini-xhm-3f2-dl580-db2-vip)(PORT=152
2))(ADDRESS=(PROTOCOL=TCP)(HOST=10.142.145.8)(PORT=1522))))' SCOPE=BOTH;
Tue Jul 26 15:27:35 2011
ALTER SYSTEM SET remote_listener='(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bj-mini-xhm-3f2-dl580-db1-vip)(PORT=15
22))(ADDRESS=(PROTOCOL=TCP)(HOST=10.142.145.7)(PORT=1522))))' SCOPE=BOTH;

分别在各自的节点运行，之后正常：
在节点１运行如下：

ALTER SYSTEM SET local_listener='(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bj-mini-xhm-3f2-dl580-db1-vip)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=10.142.145.7)(PORT=1522))))' SCOPE=BOTH SID=cdb1;
ALTER SYSTEM SET remote_listener='(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bj-mini-xhm-3f2-dl580-db2-vip)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=10.142.145.8)(PORT=1522))))' SCOPE=BOTH SID=cdb1;

在节点２运行如下：

ALTER SYSTEM SET local_listener='(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bj-mini-xhm-3f2-dl580-db2-vip)(PORT=152
2))(ADDRESS=(PROTOCOL=TCP)(HOST=10.142.145.8)(PORT=1522))))' SCOPE=BOTH SID='cdb2';
Fri Aug 12 00:48:26 2011
ALTER SYSTEM SET remote_listener='(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bj-mini-xhm-3f2-dl580-db1-vip)(PORT=15
22))(ADDRESS=(PROTOCOL=TCP)(HOST=10.142.145.7)(PORT=1522))))' SCOPE=BOTH SID='cdb2';

 

计划9:30搞定的东东，居然弄到凌晨2点，不得不说，一切皆有可能呀。