TNS-04612 error

10.2.0.5 on oracle linux 5.8

使用dbca,在RAC添加第三个节点时报错 TNS-04612: Null RHS for "an tnsnames entry"。网上查到应该是tnsnames.ora里面

对应的entry格式有问题造成的。

之前该entry的格式如下：

RACDB_LISTENER =
 (DESCRIPTION=
    (ADDRESS =(PROTOCOL= TCP)(HOST = sdb2-vip)(PORT = 1521))
    (ADDRESS =(PROTOCOL= TCP)(HOST = sdb1-vip)(PORT = 1521))
)

后来修改格式为

RACDB_LISTENER =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sdb2-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = sdb1-vip)(PORT = 1521))
  )

在等号前后都要有空格，另外加上了address_list

修改后不再出现该错误