RAC客戶端訪問DB只能用VIP不能用VIP對應的hostname
Oracle 10.2.0.4 RAC 3節點
Red Hat Linux AS 5.3
客戶端設定VIP的IP地址可以正常訪問 。
TEST_RAC =
(DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.8.101)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.8.102)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.8.103)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = TEST)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))
)
)
但是客戶端設定VIP對應的hostname 就不能正常訪問,不過在db server本機上tnsnames.ora中這樣設定可以訪問 。
TEST_RAC =
(DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = vip01)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip02)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip03)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = TEST)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))
)
)
/etc/hosts 設定也沒有問題。
[root@rac01 ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
10.10.8.91 rac01
192.168.1.11 pri01
10.10.8.101 vip01
10.10.8.92 rac02
192.168.1.13 pri02
10.10.8.102 vip02
10.10.8.93 rac03
192.168.1.13 pri03
10.10.8.103 vip03
Red Hat Linux AS 5.3
客戶端設定VIP的IP地址可以正常訪問 。
TEST_RAC =
(DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.8.101)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.8.102)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.8.103)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = TEST)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))
)
)
但是客戶端設定VIP對應的hostname 就不能正常訪問,不過在db server本機上tnsnames.ora中這樣設定可以訪問 。
TEST_RAC =
(DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = vip01)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip02)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip03)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = TEST)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))
)
)
/etc/hosts 設定也沒有問題。
[root@rac01 ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
10.10.8.91 rac01
192.168.1.11 pri01
10.10.8.101 vip01
10.10.8.92 rac02
192.168.1.13 pri02
10.10.8.102 vip02
10.10.8.93 rac03
192.168.1.13 pri03
10.10.8.103 vip03
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-625072/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- rac vip failback issueAI
- RAC的VIP切換測試
- VOC(客戶之聲)讓每個客戶都成為VIP
- 【RAC】Oracle rac 如何修改公網及vipOracle
- Oracle RAC修改public, VIP, SCAN IPOracle
- rac 新增第二public ip 和 vip
- Oracle RAC ASM磁碟組擴容時遇到的VIP漂移OracleASM
- 客戶端 post ,get 訪問伺服器客戶端伺服器
- Docker部署mysql並提供客戶端訪問DockerMySql客戶端
- db2 客戶端安裝DB2客戶端
- 為什麼 go 中字串不能用下標訪問Go字串
- Oracle 12. 2 RAC public IP與vip 互換方法Oracle
- VIP影片解析
- parameter hj8828vip installed Oracle h518vip onOracleH5
- 【rac故障】root.sh報錯Unable to get VIP info for new node
- 瀏覽器訪問本地資源 - 只能用於測試(把file:///對映為http://)瀏覽器HTTP
- 客戶端(windows)訪問FTP伺服器遇到的問題(總結)客戶端WindowsFTP伺服器
- 二分只能用來查詢元素嗎?
- keepalived(二)vip漂移
- EVE-NG初次啟動及WEB客戶端訪問Web客戶端
- FastDFS-nginx外掛作為FastDFS客戶端訪問ASTNginx客戶端
- Cisco Secure Client 5.1.6.103 (macOS, Linux, Windows & iOS, Andrord) - 遠端訪問客戶端clientMacLinuxWindowsiOS客戶端
- 11g RAC 修改PUBLIC-IP、VIP、PRIV-IP、SCAN-IP
- frp內網穿透,客戶端能訪問,服務端訪問報錯404,有兄弟遇到過嗎FRP內網穿透客戶端服務端
- Python抓取VIP電影Python
- MHA高可用+VIP漂移
- 雲端儲存的一些功能用法
- www.hj518.vip@17008768000@www.hj518.vip@我要發大財
- 客戶服務管理:CRM實現緊急應對客戶常見問題
- Swoole 協程 MySQL 客戶端與非同步回撥 MySQL 客戶端的對比MySql客戶端非同步
- mysql賬戶新增遠端訪問MySql
- 騰訊,真對不起了!這下好了支援安卓,蘋果,盒子的藍光VIP免費安卓蘋果
- scss不能用除法?CSS
- 生不逢時的openZFS能用在資料庫上嗎資料庫
- SnailSVN 專業版:與訪達整合的 SVN 客戶端AI客戶端
- 免費的代理IP能用嗎?
- Java能用來做什麼的?Java
- 問題 1462: [藍橋杯][基礎練習VIP]Huffuman樹
- 前端如何保持與伺服器時間同步(如何解決客戶端與服務端時間不對稱的問題)?前端伺服器客戶端服務端