oracle11g RAC scan ip連線時出現ORA-12545: 因目標主機或物件不存在
今天測試oracle11g 使用scan ip連線資料庫時出現,如下錯誤:[@more@]
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 9 14:22:36 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12545: 因目標主機或物件不存在, 連線失敗
C:UsersFounder>sqlplus sys/oracle@racdb_scan as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 9 14:22:36 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12545: 因目標主機或物件不存在, 連線失敗
tnsnames.ora:
racdb_scan =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.155)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.155)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
)
)
解決辦法:
C:UsersFounder>sqlplus sys/oracle@racdb1 as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 9 14:27:03 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 9 14:27:03 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.153)(PORT = 1521))' sid='racdb1';
System altered.
System altered.
C:UsersFounder>sqlplus sys/oracle@racdb2 as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 9 14:28:02 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.154)(PORT = 1521))' sid='racdb2';
System altered.
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 9 14:28:02 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.154)(PORT = 1521))' sid='racdb2';
System altered.
之後便可以連線了
C:UsersFounder>sqlplus sys/oracle@racdb_scan as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 9 14:28:35 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select sysdate from dual;
SYSDATE
--------------
09-4月 -13
SQL> set linesize 160
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
instance_name string racdb2
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 9 14:28:35 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select sysdate from dual;
SYSDATE
--------------
09-4月 -13
SQL> set linesize 160
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
instance_name string racdb2
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-1060379/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-12545: 因目標主機或物件不存在, 連線失敗物件
- oracle 10G rac ORA-12545:因目標主機或物件不存在,連線失敗問題總結Oracle 10g物件
- scan-ip連線出現“ORA-12545”
- 連線scan ip出現ORA-12545錯誤
- 解決:ORA:目標主機或者物件不存在物件
- ORACLE DG為RAC時使用scan-ip連線資料庫會報 ORA-12545錯誤Oracle資料庫
- 9i rac 連線時提示ORA-12545!
- Oracle11gR2 RAC 使用scan IP無法連線資料庫(ORA-12545)問題解決Oracle資料庫
- RAC重建SCAN IP
- RAC 增加SCAN IP
- Oracle 11g RAC通過SCAN IP連線資料庫 - JDBC連線串問題Oracle資料庫JDBC
- RAC連線的問題ORA-12545
- [Oracle] oracle11g scan ip relocateOracle
- SSH 透過跳板機連線目標機
- 連線rac資料庫報ORA-12545資料庫
- 客戶端連線RAC報ora-12545客戶端
- RAC連線的問題ORA-12545(二)
- 11g RAC ORA-12545 解決方案 +11g scan IP新特性
- RAC改VIP和SCAN IP
- 客戶端通過SCAN TNS無法連線ORA-12545客戶端
- Oracle RAC修改Scan IP,Public IP的方法Oracle
- Oracle RAC修改public, VIP, SCAN IPOracle
- rac 手動漂移scan ip vip
- RAC_網路_VIP漂移_SCAN IP
- Oracle 11g修改RAC SCAN IPOracle
- Oracle RAC修改public,private,vip scan IPOracle
- Oracle RAC中的Public IP, VIP和Internal IP,SCANOracle
- oracle 客戶端連線11gR2 SCAN 報ORA-12545錯誤Oracle客戶端
- 宿主機/客戶端無法連線虛擬機器/主機Oracle11g客戶端虛擬機Oracle
- 記一次資料庫遷移到rac11204資料庫連線scan找不到主機資料庫
- 為什麼有些客戶沒有用11gR2 RAC中scan ip連線資料庫資料庫
- Oracle 11gR2 RAC修改SCAN IPOracle
- RAC中的各種IP-PUBLIC-VIP-Private-SCAN IP
- img標籤src屬性不存在或值為空時頁面出現邊框解決方法
- RAC Connection Redirected To Wrong Host/IP ORA-12545
- 去掉超連結或按鈕點選時出現的虛線邊框
- vnc連線雲主機,如何在Windows中用vnc連線雲主機VNCWindows
- 【RAC】如何修改SCAN IP的IP地址、名稱、埠等資訊