ORACLE RAC中連接ScanIP報錯ORA

才安裝好的一個ORACLE 11G 11.2.0.4的一套RAC，通過DG同步的數(shù)據(jù)，激活用于測試，在本地通過SCANIP鏈接，沒有問題，conn sz/sz2486@192.168.133.2:1521/orcl

Connected.

但從其他機器鏈接，就會報錯：

SQL> conn sz/sz2486@192.168.133.2:1521/orclERROR:ORA-12545: Connect failed because target host or object does not exist

這里的原因是節(jié)點的LOCAL_LISTENER參數(shù)設置為了空.在RAC中,每個節(jié)點的LOCAL_LISTENER參數(shù)必須指定本節(jié)點的vip,remote_listener必須指向scanIP.

檢查一下服務器端的設置：

SQL> show parameter list

NAME TYPE VALUE

------------------------------------ -----------

------------------------------

listener_networks string

local_listener string

remote_listener string db-scan:1521

馬上設置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';

再去測試，問題解決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)