IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

Configuring JDBC Adapter connection in OCI mode

  • 1.  Configuring JDBC Adapter connection in OCI mode

    Posted Thu July 12, 2007 04:48 AM

    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


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods