WebMethod connect to Oracle10g RAC
Issue
I've would like to know what is the url model for JDBC pools when we use a database Oracle 10g RAC.
Same question for repository server.
Resolution
For internal IS JDBC Pools (Core Audit, Process Audit, TN, XRef, Document History), only OEM version of DataDirect ConnectJDBC is supported. The JDBC connection string to use in this case should be like:
"jdbc:wm:oracle://192.168.7.64:1521;ServiceName=PRD;AlternateServers=(192.168.7.65:1521);LoadBalancing=true"
Note: There is an issue with CJDBC 3.4 that would affect all customers using Oracle RAC. Although the correct syntax for setting a URL for Oracle
RAC is as follows:
"jdbc:wm:oracle://HOST1:1521;ServiceName=SERVICENAME;AlternateServers=(HOST2:1521);LoadBalancing=true"
with 3.4 if you set the above URL, the IS JDBC pools throw an error. Instead of "AlternateServers", using "AlternateServer" ( Singular) the connection gets enabled, but the property is just ignored by the Driver. So in effect your customer is exposed to a failure in case the primary RAC node goes down.
This issue does not exist on the 3.3 toolkit. This issue is fixed in 3.5 and 3.6 versions CJDBC.
For webMethods JDBC Adapter, in your case to access to Oracle 10g, you need to use the specific Oracle JDBC Driver, from Oracle itself, and the JDBC connection string to use should be as:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.7.64)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.7.65)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PRD)))
You can use Oracle RAC facility using following in 'Other Properties' when configuring JDBC adapter connection:
Using thin driver something like:
driverType=thin;url=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=service)))
You can also use the OCI Driver, tnsnames file needs to have the entry for the nodes in the RAC. Then in the connection settings you need the following:
DataSource Class = oracle.jdbc.pool.OracleDataSource therProperties=tnsEntryName=EMPWR2D;driverType=oci
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-626202/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- What's the webmethodWeb
- about oracle10g racOracle
- about oracle10g rac(轉)Oracle
- Oracle10g RAC管理 - CRSOracle
- ORACLE10g修改RAC VIPOracle
- Oracle10g RAC配置standbyOracle
- 【RAC】Oracle10g RAC 節點重配的方式Oracle
- Oracle10g RAC 加節點Oracle
- oracle10g rac for linux as 4.0OracleLinux
- 關於 RAC VIP (Oracle10G RAC) 的探討(zt)Oracle
- oracle10g RAC Default gateway is not defined (host=rac2) (vm)OracleGateway
- oracle10g ASM+RAC安裝OracleASM
- Oracle10g RAC設定記錄Oracle
- VMware 搭建 Oracle10g RAC 筆記Oracle筆記
- Oracle10g VMWare RAC搭建圖解Oracle圖解
- oracle10g rac(rhel)_PROC-22Oracle
- Oracle10g RAC ASM磁碟組[zt]OracleASM
- 【RAC】Oracle10g rac新增刪除節點命令參考Oracle
- 如何查詢Oracle10g RAC CRS版本Oracle
- Oracle10g RAC ASM 環境日常管理OracleASM
- oracle10g rac常用命令整理Oracle
- Oracle10g RAC with ocfs在windows安裝OracleWindows
- windows下oracle10g RAC的安裝WindowsOracle
- Oracle10g RAC安裝手冊 (zt)Oracle
- Oracle10g RAC 關閉及啟動Oracle
- Oracle10g RAC叢集基本命令Oracle
- Oracle10g rac 必須掌握的知識Oracle
- Oracle10g RAC開啟關閉過程Oracle
- Oracle10g RAC叢集基本命令(轉)Oracle
- Oracle10g RAC下啟用歸檔模式Oracle模式
- 在Oracle10g RAC下新增ASM磁碟組OracleASM
- 搭建 VM + RHLE5 + Oracle10g Rac + ASMOracleASM
- 在AIX上安裝配置Oracle10g RACAIOracle
- 在VMware 上安裝配置Oracle10g RACOracle
- Oracle10g RAC 刪除及加入節點Oracle
- oracle 10g rac 單例項恢復至ORACLE10G RAC RMANOracle 10g單例
- Oracle10g RAC 關閉及啟動步驟Oracle
- 近期oracle10g rac(rhel4)測試提要Oracle