java应用程序连接Oracle rac的URL写法

1.应用程序连接Oracle rac的URL写法：

#Oracle(AMS)
jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.199)(PORT = 1521))
                                                             (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.198)(PORT = 1521))
                                     (LOAD_BALANCE = yes)
                                    (FAILOVER = yes)
                                     (CONNECT_DATA =(SERVER = DEDICATED)
                                     (SERVICE_NAME = kobra)
                                     (FAILOVER_MODE=
                                           (TYPE = SELECT)(METHOD = BASIC)(RETIRES = 180)(DELAY = 15)
                                      )
                                   )
                                   )
jdbc.username=kms
jdbc.password=kms

 备注：如果使用scap ip，可以将以下代码直接替换成scan ip，形式为：jdbc:oracle:thin:@scap ip：1521：kobra

 
2.客户端tnsnames.ora文件写法如下：

 ractest =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.199)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.176.198)(PORT = 1521))
    (LOAD_BALANCE= yes)
    (FAILOVER= yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = kobra)
    )
  )
  
  备注：同样，可以将以下ip地址用sacn ip或域名替来替换
  
  ractest =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = scan-ip.localdomain)(PORT = 1521))
    (LOAD_BALANCE= yes)
    (FAILOVER= yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = kobra)
    )
  )

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

转载于:http://blog.itpub.net/29289867/viewspace-1978436/