才安裝好的一個(gè)ORACLE 11G 11.2.0.4的一套R(shí)AC，通過DG同步的數(shù)據(jù)，激活用于測(cè)試，在本地通過SCANIP鏈接，沒有問題，
conn sz/sz2486@192.168.133.2:1521/orcl
Connected.
但從其他機(jī)器鏈接，就會(huì)報(bào)錯(cuò)：
SQL> conn sz/sz2486@192.168.133.2:1521/orcl
ERROR:
ORA-12545: Connect failed because target host or object does not exist
這里的原因是節(jié)點(diǎn)的LOCAL_LISTENER參數(shù)設(shè)置為了空.在RAC中,每個(gè)節(jié)點(diǎn)的LOCAL_LISTENER參數(shù)必須指定本節(jié)點(diǎn)的vip,remote_listener必須指向scanIP.


檢查一下服務(wù)器端的設(shè)置：
SQL> show parameter list
NAME TYPE VALUE

------------------------------------ -----------?------------------------------
listener_networks string
local_listener string
remote_listener string db-scan:1521
馬上設(shè)置LOCAL_LISTENER
SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.133.9)(PORT=1521))' sid='orcl1';
SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.133.10)(PORT=1521))' sid='orcl2';
再去測(cè)試，問題解決
conn sz/sz2486@192.168.133.2:1521/orcl
Connected.
附ORACLE MOS上文檔：ORA-12545 or ORA-12537 While Connecting to RAC Through SCAN name (Doc ID 970619.1)