Configuring 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

2

Hi,

I have the same error with a similar configuration. Do someone have any idea? rahmed, do you have found a solution?
OS: AIX 5.3
webM: IS 6.5 SP1, 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)
LIBPATH=/u01/app/oracle/product/client/10.2/lib
Transaction Type NO_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
serverName xxx.xxx.xxx.xxx
user WM
password ******
databaseName
portNumber
networkProtocol tcp
Other Properties drivertype=oci;url=jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.64)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.65)(PORT = 1521))(LOAD_BALANCE = yes))(CONNECT_DATA =(SERVICE_NAME = PRD)(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 20)(DELAY = 60))))

3

This post and the thread it belongs to may be of assistance.

Mark

4

Thank’s for you answer but I’ve still an error:

-oracle client is installed and tnsmane is defined
>tnsping prd
TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 28-APR-2008 15:05:14
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files: /oracle/ora_base/product/10.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.64)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.65)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVICE_NAME = PRD) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 60))))
OK (0 msec)

  • My environment variables are defined:
    LD_LIBRARY_PATH=/oracle/ora_base/product/10.2.0/lib
    LIBPATH=/oracle/ora_base/product/10.2.0/lib

  • My connection is :
    Transaction Type NO_TRANSACTION
    DataSource Class oracle.jdbc.pool.OracleDataSource
    serverName xxx.xxx.xxx.xxx
    user WMportal
    password ******
    databaseName
    portNumber
    networkProtocol tcp
    Other Properties drivertype=oci;url=jdbc:oracle:oci:@PRD

but I cannot enable my connection
/logiciels/webMethods/IS1/IntegrationServer/lib/libwmSystemInfo_2.a: load ENOEXEC on shared library(s) /logiciels/webMethods/IS1/IntegrationServer/lib/libwmSystemInfo_2.a

5

change the driver type to thin mode…as JDBC 6.5 supports CLOBS/BLOBS no need for OCI drivers