使用dbca添加new instance时报

10.2.0.5 on oracle linux 5.8

已经有两个节点SDB1,SDB2 ，现在要使用DBCA添加第三个节点，在进行到以下步骤时出现错误。

SID given in the connect descriptor could not be resolved.

Connection to the database cannot be established because the listener could be down. Please make sure that the service is registered with a listener and the listener is up.

在这个地方，DBCA会使用SID去连接本地的instance。所以这个地方必须确认：

1 password file是可以正常使用的。

 使用以下语句能正常连接数据库

 conn   sys@test as sysdba

2 由于dbca是使用network description 里的(SID=XXXX)去连接数据库，所以这个地方要查一下listener是否在这个sdb1:1521:RACTEST1上监听

从以下输出可以看出来是instance_name错了，这个地方必须SID和instance_name一样。

修改SID及instance_name，就不会再出现此错误

lsnrctl service

Service "test_rac" has 2 instance(s).
  Instance "RACTEST2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:1 refused:0 state:ready
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=sdb2.liteon.com)(PORT=1521))
  Instance "RACTET1", status READY, has 2 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=sdb1.liteon.com)(PORT=1521))
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
The command completed successfully