Java串連Oracle叢集的OCI連接字串寫法

 上次記錄了Java使用thin方式串連Oracle叢集的Uri寫法，參考網上資料有串連不穩定的說法，本人尚未做測試，但是查資料發現OCI(Oracle Call Interface)的方式更為穩定，最後決定使用這種方式。按照以下步驟完成環境配置：

1.安裝Oracle client，根據提示或者直接在安裝目錄建立設定檔：tnsnames.ora，內容可參考下面內容：

DBCENTER =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

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

      (LOAD_BALANCE = yes)

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = dbcenter)

    )

  )

DBCENTER1 =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = dbcenter)

      (INSTANCE_NAME = dbcenter1)

    )

  )

 

DBCENTER2 =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = dbcenter)

      (INSTANCE_NAME = dbcenter2)

    )

宋體;mso-bidi-font-family:"Times New Roman";mso-font-kerning:1.0pt;mso-ansi-language:
EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA'>  )

宋體;mso-bidi-font-family:"Times New Roman";mso-font-kerning:1.0pt;mso-ansi-language:
EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA'>2.在C:/WINDOWS/system32/drivers/etc/hosts 檔案增加IP配置。

3.在代碼中使用jdbc:oracle:oci:@dbcenter的方式串連Oracle叢集。

經測試連接正常。