oracle集群管理的java进程,java 连Oracle集群(转载)

Java連oracle庫—(數據庫在改為集群之后URL的相應調整)

出于系統性能以及安全方面考慮﹐我們工廠的其中一系統的數據庫的方式改為集群方式。這樣我們的JAVA系統的連庫方式也要改動﹐因以前沒有使用過集群數據庫﹐也沒有相應的資料﹐系統就暫時采用連接集群中的一台電腦。

經過測試最后才知道﹐原來URL還可以以Oracle別名字串來連接數據庫。

問題最終得以解決。

Oracle 別名

原別名﹕

test =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA = (SID = test))

)

集群方式別名﹕

test =

(DESCRIPTION =

(ADDRESS_LIST =

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

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

(LOAD_BALANCE = yes)

(FAILOVER = yes)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(INSTANCE_ROLE = PRIMARY)

(FAILOVER_MODE =

(TYPE = SESSION)

(METHOD = BASIC)

)

(SERVICE_NAME = test)

)

)

Java連庫URL方式變更如下

原方式﹕

jdbc.url=jdbc:oracle:thin:@112.117.12.50:1521:test

改為集群后的方式﹕

jdbc.url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 112.117.12.50)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 112.117.12.51)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = yes))(CONNECT_DATA = (SERVER = DEDICATED)(INSTANCE_ROLE = PRIMARY)(FAILOVER_MODE = (TYPE = SESSION)(METHOD = BASIC))(SERVICE_NAME = test)))