Configuring JDBC Adapter connection in OCI mode

, ,
1

Hi,

I am trying to configure a JDBC connection with driver type OCI.

Environment:

OS: AIX 5.3

webM: IS 6.5 SP2, JDBC 6.5

JVM: J2RE 1.4.2 build 1.4.2, IBM AIX

DB : Oracle 10g RAC 10.2.0.2.0 (also, Client is Installed at wM host)

Steps followed:

  1. Installed Oracle 10g Client at wM host.

  2. Created tnsnames.ora with appropriate entries.

  3. Set the following paths in Environment

LIBPATH=/u01/app/oracle/product/client/10.2/lib32

LD_LIBRARY_PATH=/u01/app/oracle/product/client/10.2/lib32

ORACLE_HOME=/u01/app/oracle/product/client/10.2

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:
/usr/java14/bin:/u01/app/oracle/product/client/10.2/lib32:/u01/app/oracle/product/client/10.2/bin

  1. Copied the ojdbc14.jar from “/u01/app/oracle/product/client/10.2/jdbc/lib” to “/opt/webMethods6/IntegrationServer/lib/jars”

  2. Started IS and created an adapter connection with following parameters.

Transaction Type NO_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
serverName xxx.xxx.xxx.xxx
user WM
password ******
databaseName DEV01
portNumber 1521
networkProtocol tcp
Other Properties drivertype=oci

While enabling the connection, I am getting the below exception.

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Test.OCI:OCI_Conn.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
/opt/webMethods6/IntegrationServer/lib/libwmSystemInfo_2.a: load ENOEXEC on shared library(s) /opt/webMethods6/IntegrationServer/lib/libwmSystemInfo_2.a

I see that, file libwmSystemInfo_2.a has read and execute privilages granted for user.

Any help will be appreciated.

Warm regards,
Raheel