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
修改后不再出现该错误