Oracle 11gR2 RAC SCAN ORA-12543: TNS:destination host unreachable
環境: Oracle 11gR2 RAC, CentOS 5.6
透過SCAN訪問RAC database, 不時出現ORA-12543: TNS:destination host unreachable,經查只有一個scan listener可以訪問。
[oracle@rac7 ~]$ srvctl config scan
SCAN name: rac-scan, Network: 1/192.168.56.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /192.168.56.10/192.168.56.10
然而
[root@rac7 ~]# vi /var/named/localdomain.zone
$TTL 86400
@ IN SOA localhost root.localhost (
42 ; serial (d. adams)
3H ; refresh
15M ; retry
1W ; expiry
1D ) ; minimum
IN NS localhost
localhost IN A 127.0.0.1
rac5 IN A 192.168.56.248
rac7 IN A 192.168.56.247
rac5-priv IN A 192.168.56.5
rac7-priv IN A 192.168.56.7
rac5-vip IN A 192.168.56.105
rac7-vip IN A 192.168.56.107
rac-scan IN A 192.168.56.10
rac-scan IN A 192.168.56.11
rac-scan IN A 192.168.56.12
有三個scan ip地址
更改操作如下:
srvctl stop scan_listener
srvctl stop scan
切換到root使用者
/u01/app/grid/bin/srvctl modify scan -n rac-scan
/u01/app/grid/bin/srvctl config scan
/u01/app/grid/bin/srvctl modify scan_listener -u
/u01/app/grid/bin/srvctl config scan_listener
/u01/app/grid/bin/srvctl srvctl start scan_listener
再切換到oracle使用者
srvctl status scan
srvctl status scan_listener
測試 sqlplus system/oracle@RAC-SCAN:1521/racdb.localdomain
然後多次檢視select instance_name from v$instance;
可知instance_name會變化。
透過SCAN訪問RAC database, 不時出現ORA-12543: TNS:destination host unreachable,經查只有一個scan listener可以訪問。
[oracle@rac7 ~]$ srvctl config scan
SCAN name: rac-scan, Network: 1/192.168.56.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /192.168.56.10/192.168.56.10
然而
[root@rac7 ~]# vi /var/named/localdomain.zone
$TTL 86400
@ IN SOA localhost root.localhost (
42 ; serial (d. adams)
3H ; refresh
15M ; retry
1W ; expiry
1D ) ; minimum
IN NS localhost
localhost IN A 127.0.0.1
rac5 IN A 192.168.56.248
rac7 IN A 192.168.56.247
rac5-priv IN A 192.168.56.5
rac7-priv IN A 192.168.56.7
rac5-vip IN A 192.168.56.105
rac7-vip IN A 192.168.56.107
rac-scan IN A 192.168.56.10
rac-scan IN A 192.168.56.11
rac-scan IN A 192.168.56.12
有三個scan ip地址
更改操作如下:
srvctl stop scan_listener
srvctl stop scan
切換到root使用者
/u01/app/grid/bin/srvctl modify scan -n rac-scan
/u01/app/grid/bin/srvctl config scan
/u01/app/grid/bin/srvctl modify scan_listener -u
/u01/app/grid/bin/srvctl config scan_listener
/u01/app/grid/bin/srvctl srvctl start scan_listener
再切換到oracle使用者
srvctl status scan
srvctl status scan_listener
測試 sqlplus system/oracle@RAC-SCAN:1521/racdb.localdomain
然後多次檢視select instance_name from v$instance;
可知instance_name會變化。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16582684/viewspace-740035/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 問題解決:TNS-12543: TNS:destination host unreachable
- Oracle 11gR2 RAC修改SCAN IPOracle
- Oracle 11gR2 RAC修改SCAN IP地址Oracle
- Unable to execute SonarScanner analysis: Fail to get bootstrap index from server: Host is unreachable(Host unreachable)AIbootIndexServer
- oracle 11gr2 SCAN LISTENER配置Oracle
- 能ping通虛擬機器,但snmp報文 Destination unreachable(Host administratively prohibited虛擬機
- oracle 11gR2 scan ip (DNS模式)OracleDNS模式
- oracle 11gR2 修改 DNS 方式 SCAN IPOracleDNS
- Oracle RAC修改public, VIP, SCAN IPOracle
- RAC_TNS故障轉移負載均衡、SCAN IP、VIP、PUBLIC IP負載
- oracle 11gR2 scan PRVF-4664 問題Oracle
- oracle rac scan監聽更改埠號Oracle
- Oracle 11g修改RAC SCAN IPOracle
- Oracle RAC修改public,private,vip scan IPOracle
- Oracle RAC修改Scan IP,Public IP的方法Oracle
- oracle-rac--srvctl add scan_listenerOracle
- oracle 11gr2 rac 安裝Oracle
- 11gR2 RAC使用SCAN故障切換問題的解決方案
- oracle 11gR2 如何修改scan vip 地址 /etc/hosts方式Oracle
- RAC重建SCAN IP
- RAC 增加SCAN IP
- oracle10g RAC Default gateway is not defined (host=rac2) (vm)OracleGateway
- rac scan listener log 清理監聽日誌 oracleOracle
- Oracle 11gr2修改RAC叢集的scan ip,並處理ORA-12514問題Oracle
- 【RAC安裝】 AIX下安裝Oracle 11gR2 RACAIOracle
- oracle rac的scan監聽狀態Not All Endpoints RegisteredOracle
- Oracle RAC中的Public IP, VIP和Internal IP,SCANOracle
- Oracle 11g RAC SCAN ip的原理及配置Oracle
- Oracle RAC 11gR2開啟歸檔Oracle
- Oracle 11gR2 RAC ORA-00845Oracle
- Oracle 11gR2 RAC 常用維護操作Oracle
- 11gr2 rac改IP系列之三:修改SCAN IP為同網段其它IP
- Oracle 11g RAC 叢集 SCAN IP Listener說明Oracle
- Oracle 11gR2 RAC的JDBC連線串OracleJDBC
- oracle 11gR2 RAC crsctl 命令的增強Oracle
- ORA-12545 TNS: Host or Object Does not ExistObject
- RAC改VIP和SCAN IP
- oracle 客戶端如何連線到oracle 11gR2資料庫(DNS SCAN IP)Oracle客戶端資料庫DNS