I am trying to create an adapter connection using OCI driver mode. I have downloaded “instantclient-basic-win32-10.2.0.3-20061115.zip” from Oracle.
Extracted the files to a location on the disk.
Set the PATH (environment variable) pointing above location.
Copied ojdbc14.jar to <IS_HOME>\lib\jars.
Environment:
wM 6.5, JDBC Adapter 6.5, Oracle 10g RAC (10.2.0.2.0), Windows XP Professional
Transaction Type LOCAL_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
serverName
user username
password ******
databaseName DBNAME
portNumber 1521
networkProtocol tcp
Other Properties url=jdbc:oracle:oci:@(DESCRIPTION=(failover=on)(failover_mode=(type=session)(method=basic))(address_list=(ADDRESS=(PROTOCOL=TCP)(Host=host1)(Port=1521))(ADDRESS=(PROTOCOL=TCP)(Host=host2)(Port=1521))(load_balance=on))(CONNECT_DATA=(service_name=)))
also tried:
Other Properties driverType=oci
I am getting following error:
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource test.flowService:testConn.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
C:\instantclient\ocijdbc10.dll: The specified procedure could not be found
When driverType is set as “Thin” it is working perfectly.
I think OCI drivers are backward compatible, as i got 10.2.0.3 drivers and my DB version is 10.2.0.2.
Thanks in advance!
Raheel