返回首頁
當前位置: 主頁 > 網絡編程 > Jsp實例教程 >

RAC模式下客戶端連接的問題ORA-12545

時間:2012-06-04 11:23來源:知行網www.f1globe.com 編輯:麥田守望者

處理過程簡述:

ERROR:
ORA-12545: 因目標主機或對象不存在, 連接失敗

查看lsnrctl監聽的服務是否正常,下面的輸出表示監聽仍然是主機名稱,而不是IP地址
 

 

 

$ lsnrctl service LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 06-FEB-2009 10:08:33 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))Services Summary...Service "PLSExtProc" has 1 instance(s).Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0LOCAL SERVERService "jxsi" has 2 instance(s).Instance "jxsi1", status READY, has 2 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=jxdb1-vip)(PORT=1521))"DEDICATED" established:278549 refused:0 state:readyLOCAL SERVERInstance "jxsi2", status READY, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:72 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=jxdb2-vip)(PORT=1521))Service "jxsi_XPT" has 2 instance(s).Instance "jxsi1", status READY, has 2 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=jxdb1-vip)(PORT=1521))"DEDICATED" established:278549 refused:0 state:readyLOCAL SERVERInstance "jxsi2", status READY, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:72 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=jxdb2-vip)(PORT=1521))The command completed successfully

更換之前確認一下主機名和實例名
 

 

 

SQL> host hostnamejxdb1 SQL> select instance_name from v$instance;jxsi1

更改本地監聽為IP地址
 

 

 

SQL> alter system2 set LOCAL_LISTENER = '(ADDRESS = (PROTOCOL = TCP)(HOST = 10.104.0.11)(PORT = 1521))'3 SID = 'jxsi1';

確認是否已經更改成功
 

 

 

SQL> show parameter lis NAME TYPE VALUE------------------------------------ ----------- ------------------------------local_listener string (ADDRESS = (PROTOCOL = TCP)(HOST = 10.104.0.11)(PORT = 1521))recovery_parallelism integer 0remote_listener string LISTENERS_JXSI

在另外一個節點上做同樣的操作,完成后查看監聽是否更換為IP地址
 

 

 

$ lsnrctl service LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 06-FEB-2009 10:25:09 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))Services Summary...Service "PLSExtProc" has 1 instance(s).Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0LOCAL SERVERService "jxsi" has 2 instance(s).Instance "jxsi1", status READY, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=10.104.0.11)(PORT=1521))Instance "jxsi2", status READY, has 2 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=10.104.0.21)(PORT=1521))"DEDICATED" established:0 refused:0 state:readyLOCAL SERVERService "jxsi_XPT" has 2 instance(s).Instance "jxsi1", status READY, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=10.104.0.11)(PORT=1521))Instance "jxsi2", status READY, has 2 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=10.104.0.21)(PORT=1521))"DEDICATED" established:0 refused:0 state:readyLOCAL SERVERThe command completed successfully
 

------分隔線----------------------------
標簽(Tag):數據庫 Oracle Oracle數據庫
------分隔線----------------------------
推薦內容
猜你感興趣
99久久免费高清热精品