java oracle thin 和 oci 串連方式實現多資料庫的故障切換

標籤：java   oracle thin oci   oracle thin   oracle oci   資料庫故障切換   

java oracle thin 和 oci 串連方式實現多資料庫的故障切換

一、thin方式
其中URL為
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
      (ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))
      (ADDRESS=(PROTOCOL=TCP)(HOST=10.132.111.14)(PORT=1521))
      (CONNECT_DATA=(SERVICE_NAME=bomc)))

其中LOAD_BALANCE=on表示負載開啟,java以隨機的方式建立會話串連；
LOAD_BANLANCE=off表示負載關閉,java以順序的方式建立會話串連,只有
當第一個資料庫出現故障無法串連時才會選擇第二個資料庫進行會話串連。

二、oci方式
1. 具體程式部署的本機需要安裝oracle用戶端,並在PATH路徑下指定oracle用戶端bin目錄,並拷貝
oracle用戶端裡內建的jdbc驅動到自己的工程項目。

2. 配置TNSNAMES.ORA檔案如下：
HA_DB =
  (DESCRIPTION_LIST =
     (LOAD_BALANCE = on)
     (FAILOVER = on)    
       (DESCRIPTION =
           (ADDRESS_LIST =
              (LOAD_BALANCE=OFF)
              (FAILOVER=ON)
              (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
           )
           (CONNECT_DATA =
              (SERVICE_NAME = bomc)
              (INSTANCE_NAME = bomc)
              (FAILOVER_MODE=(TYPE=session)(METHOD=basic)(RETRIES=4)(DELAY=1))
           )
        )
        (DESCRIPTION =
           (ADDRESS_LIST =
              (LOAD_BALANCE=OFF)
              (FAILOVER=ON)
              (ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.111.14)(PORT = 1521))
           )
           (CONNECT_DATA =
             (SERVICE_NAME = bomc)
             (INSTANCE_NAME = bomc)
             (FAILOVER_MODE=(TYPE=session)(METHOD=basic)(RETRIES=4)(DELAY=1))
           )
        )
        (DESCRIPTION =
           (ADDRESS_LIST =
              (LOAD_BALANCE=OFF)
              (FAILOVER=ON)
              (ADDRESS = (PROTOCOL = TCP)(HOST = 10.112.11.161)(PORT = 1521))
           )
           (CONNECT_DATA =
              (SERVICE_NAME = bomc)
              (INSTANCE_NAME = bomc)
              (FAILOVER_MODE=(TYPE=session)(METHOD=basic)(RETRIES=4)(DELAY=1))
           )
        )
       
  )
 
關於其中的配置參數作用請查相關資料!
 
3. java jdbc串連
其中URL寫為java:oracle:oci:@ha_db