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