與Oracle RAC相關的連接配置寫法實例

1. 應用程序連接Oracle rac的URL寫法
jdbc:Oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.52)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.51)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = kms)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RETIRES = 180)(DELAY = 15))))
-
 

2. 客戶端連接Oracle rac時的tnsnames.ora寫法
ZJGLDB2 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.52)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = kms)

      (INSTANCE_NAME = kms2)

    )

  )

ZJGLDB1 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.51)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = kms)

      (INSTANCE_NAME = kms1)

    )

  )

LISTENERS_KMS =

  (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.51)(PORT = 1521))

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.52)(PORT = 1521))

  )

KMS =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.51)(PORT = 1521))

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.52)(PORT = 1521))

    (LOAD_BALANCE = yes)

    (FAILOVER = yes)

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = kms)

      (FAILOVER_MODE =

        (TYPE = SELECT)

        (METHOD = BASIC)

        (RETRIES = 180)

        (DELAY = 5)

      )

    )

  )

服務器租用/服務器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質保障！--億恩科技[ENKJ.COM]