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 或者vip 對應的hostname
- How to change VIP and VIP/Hostname in 10g
- Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware NodeOracle
- 配置RAC中的VIP
- 關於10g RAC監聽設定,tnsnames.ora設定,VIP及客戶端配置問題。客戶端
- rac vip failback issueAI
- RAC如何修改VIP
- 字串資料不能用DW,只能用DB字串
- VOC(客戶之聲)讓每個客戶都成為VIP
- RAC之srvctl 命令不能用的問題
- RAC更改叢集VIP
- RAC中修改IP, VIP
- Oracle 10g RAC vip 漂移問題Oracle 10g
- RAC的VIP切換測試
- Oracle RAC能用ocfs嗎 ?Oracle
- RAC改VIP和SCAN IP
- 關於 rac vip fail backAI
- RAC 11.2.0.3 修改VIP地址
- oracle rac vip 漂移過程Oracle
- 遠端客戶端 訪問 ASM 例項客戶端ASM
- 資料庫VIP地址無法訪問(二)資料庫
- 資料庫VIP地址無法訪問(一)資料庫
- rac的vip和監聽莫名故障
- oracle 11g rac 修改VIP、scan VIP、priv IP操作文件Oracle
- 【RAC】Oracle rac 如何修改公網及vipOracle
- Oracle RAC修改public, VIP, SCAN IPOracle
- rac 手動漂移scan ip vip
- ORACLE10g修改RAC VIPOracle
- Oracle RAC修改IP和VIP地址Oracle
- 客戶端訪問POP3--SMTP客戶端
- 【VIP】調整RAC虛擬IP地址(VIP)及虛擬主機名
- (轉)【VIP】調整RAC虛擬IP地址(VIP)及虛擬主機名
- Docker部署mysql並提供客戶端訪問DockerMySql客戶端
- 客戶端 post ,get 訪問伺服器客戶端伺服器
- rac 新增第二public ip 和 vip
- RAC_網路_VIP漂移_SCAN IP
- Oracle RAC修改public,private,vip scan IPOracle
- 10g RAC中修改VIP地址