Topic
  • 3 replies
  • Latest Post - ‏2010-12-01T22:04:49Z by mmalc
Eswararao
Eswararao
3 Posts

Pinned topic java.lang.UnsatisfiedLinkError: ocijdbc10 (Not found in java.library.path)

‏2010-11-29T18:29:21Z |
Hi All,

I had try to configure the OCI Driver data source in =Websphere process server V6.2 but i am getting java.lang.UnsatisfiedLinkError: ocijdbc10 (Not found in java.library.path) error

Please find the error:

11/28/10 6:03:13:308 CST 0000005a DataSourceCon E DSRA8040I: Failed to connect to the DataSource. Encountered "": java.lang.UnsatisfiedLinkError: ocijdbc10 (Not found in java.library.path)
at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:986)
at java.lang.ClassLoader.loadLibraryWithClassLoader(ClassLoader.java:950)
at java.lang.System.loadLibrary(System.java:453)
at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3147)
at java.security.AccessController.doPrivileged(AccessController.java:197)
at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3143)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:221)

I had try to set the variables in 2 ways

First one is to add the variables in Environmental file.

Second one is to update the variables in .profile file.

1. Environmental file:

I have added variables in environmental file. but still i am getting same error

WPS Environmental Details:

ORACLE_HOME=/oracle/app/oracle/product/11.1.0/client_1
LIBPATH=/oracle/app/oracle/product/11.1.0/client_1/lib32

2. .profile file updated :

WPS Server running under root userid. I have update the variables in root's .profile file but still I am getting same error

.Profile file details:

export ORACLE_HOME=/oracle/app/oracle/product/11.1.0/client_1
export LIBPATH=/oracle/app/oracle/product/11.1.0/client_1/lib32

but still i am getting same error.please check and suggest me for the next step
  • mmalc
    mmalc
    231 Posts

    Re: java.lang.UnsatisfiedLinkError: ocijdbc10 (Not found in java.library.path)

    ‏2010-11-29T21:25:51Z  
    See if these instructions help you:

    http://publib.boulder.ibm.com/infocenter/wasinfo/v7r0/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/tdat_oracleoci.html

    Cheers
    Marvin
  • Eswararao
    Eswararao
    3 Posts

    Re: java.lang.UnsatisfiedLinkError: ocijdbc10 (Not found in java.library.path)

    ‏2010-11-30T07:29:08Z  
    • mmalc
    • ‏2010-11-29T21:25:51Z
    See if these instructions help you:

    http://publib.boulder.ibm.com/infocenter/wasinfo/v7r0/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/tdat_oracleoci.html

    Cheers
    Marvin
    Hi Marvin,

    I already tried link given by you but still i am facing same problem.
    Error:

    11/30/10 6:03:13:308 CST 0000005a DataSourceCon E DSRA8040I: Failed to connect to the DataSource. Encountered "": java.lang.UnsatisfiedLinkError: ocijdbc10 (Not found in java.library.path)
    at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:986)
    at java.lang.ClassLoader.loadLibraryWithClassLoader(ClassLoader.java:950)
    at java.lang.System.loadLibrary(System.java:453)
    at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3147)
    at java.security.AccessController.doPrivileged(AccessController.java:197)
    at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3143)
    at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
    at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
    at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:221)
    at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:157)
    at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:94)
    at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:1254)
    at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
    at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1286)
    at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2607)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:618)
    at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:534)
    at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:462)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    Please give me any other solution.
  • mmalc
    mmalc
    231 Posts

    Re: java.lang.UnsatisfiedLinkError: ocijdbc10 (Not found in java.library.path)

    ‏2010-12-01T22:04:49Z  
    • Eswararao
    • ‏2010-11-30T07:29:08Z
    Hi Marvin,

    I already tried link given by you but still i am facing same problem.
    Error:

    11/30/10 6:03:13:308 CST 0000005a DataSourceCon E DSRA8040I: Failed to connect to the DataSource. Encountered "": java.lang.UnsatisfiedLinkError: ocijdbc10 (Not found in java.library.path)
    at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:986)
    at java.lang.ClassLoader.loadLibraryWithClassLoader(ClassLoader.java:950)
    at java.lang.System.loadLibrary(System.java:453)
    at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3147)
    at java.security.AccessController.doPrivileged(AccessController.java:197)
    at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3143)
    at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
    at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
    at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:221)
    at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:157)
    at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:94)
    at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:1254)
    at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
    at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1286)
    at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2607)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:618)
    at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:534)
    at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:462)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    Please give me any other solution.
    Try this technote:

    http://www-01.ibm.com/support/docview.wss?rs=180&uid=swg21269703

    Cheers
    Marvin