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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-625072/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-625072/