ORA-12545: Connect failed because target host or object does not exist

環境：red hat 4.7 +oracle 10g
1.在節點1的tnsname.ora增加
local_listener_rac=
(ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.201)(PORT = 1521))
)

其中host=192.168.1.201 為vip地址

2.在節點2的tnsname.ora增加
local_listener_rac=
(ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.202)(PORT = 1521))
)

3.在任意節點修改local_listener引數
SQL> alter system set local_listener='local_listener_rac' scope=spfile;

System altered.
4.重啟各節點上的例項

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26937943/viewspace-1809396/，如需轉載，請註明出處，否則將追究法律責任。