5 Replies Latest reply: Feb 9, 2012 5:17 AM by 916438 RSS

    AWM Error while connecting to 11.1.0.7 db with OLAP option

    chakra
      While connecting to 11.1.0.7 OLAP DB through AWM 11.2.0.1.0A Standalone, the following error is coming. Please advice.

      C:\> set path=C:\Program Files\Java\jre1.6.0_07\bin;%path%
      C:\Arnab\Work\soft\AWM>java -mx1024m -jar awm11.2.0.1.0A.jar
      java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.pathC:\Arnab\Work\soft\AWM\Log\session_2011_06_06_12_44_20_0354_PM.sql
      02011.June.06 AD 12:44:20:0525 PM [ERR] ConnectionManager.connect() Exception:
      java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path
      at java.lang.ClassLoader.loadLibrary(Unknown Source)
      at java.lang.Runtime.loadLibrary0(Unknown Source)
      at java.lang.System.loadLibrary(Unknown Source)
      at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3487)
      at java.security.AccessController.doPrivileged(Native Method)
      at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java
      :3483)
      at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:252)
      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
      531)
      at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:148)
      at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtensio
      n.java:53)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
      at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSou
      rce.java:280)
      at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java
      :207)
      at oracle.ucp.jdbc.DataSourceConnectionFactoryAdapter.createConnection(D
      ataSourceConnectionFactoryAdapter.java:100)
      at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPool
      Internal.createOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1613
      )
      at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPool
      Internal.access$600(UniversalConnectionPoolImpl.java:1421)
      at oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnecti
      on(UniversalConnectionPoolImpl.java:488)
      at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithout
      CountingRequests(UniversalConnectionPoolImpl.java:303)
      at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(Univer
      salConnectionPoolImpl.java:130)
      at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPoo
      l.java:119)
      at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.j
      ava:656)
      at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.j
      ava:614)
      at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.j
      ava:608)
      at oracle.olap.awm.connection.ConnectionManager.connect(Unknown Source)
      at oracle.olap.awm.connection.ConnectionDialogActionThread.doAction(Unkn
      own Source)
      at oracle.olap.awm.ui.dialog.ThreadedDialogActionThread.run(Unknown Sour
      ce)
      java.util.MissingResourceException: Can't find resource for bundle oracle.olap.a
      wm.app.AwmResources2, key no ocijdbc11 in java.library.path
      at java.util.ResourceBundle.getObject(Unknown Source)
      at java.util.ResourceBundle.getString(Unknown Source)
      at oracle.olap.awm.util.ResourceUtils.getStringFromResource(Unknown Sour
      ce)
      at oracle.olap.awm.util.ResourceUtils.getStringFromResource(Unknown Sour
      ce)
      at oracle.olap.awm.util.ResourceUtils.getString(Unknown Source)
      at oracle.olap.awm.connection.ConnectionDialog.dialogCannotBeDismissed(U
      nknown Source)
      at oracle.olap.awm.ui.dialog.ThreadedDialogActionThread$2.run(Unknown So
      urce)
      at java.awt.event.InvocationEvent.dispatch(Unknown Source)
      at java.awt.EventQueue.dispatchEvent(Unknown Source)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
      at java.awt.Dialog$1.run(Unknown Source)
      at java.awt.Dialog$3.run(Unknown Source)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.awt.Dialog.show(Unknown Source)
      at java.awt.Component.show(Unknown Source)
      at java.awt.Component.setVisible(Unknown Source)
      at java.awt.Window.setVisible(Unknown Source)
      at java.awt.Dialog.setVisible(Unknown Source)
      at oracle.bali.ewt.dialog.JEWTDialog.runDialog(Unknown Source)
      at oracle.bali.ewt.dialog.JEWTDialog.runDialog(Unknown Source)
      at oracle.olap.awm.app.AwmFrame.openConnection(Unknown Source)
      at oracle.olap.awm.navigator.node.DatabaseNode.setExpanded(Unknown Sourc
      e)
      at oracle.bali.ewt.dTree.DTreeButtonDecoration.processMouseEvent(Unknown
      Source)
      at oracle.bali.ewt.dTree.DTreeStackingDecoration.processMouseEvent(Unkno
      wn Source)
      at oracle.bali.ewt.dTree.DTree.processMouseEvent(Unknown Source)
      at oracle.olap.awm.navigator.Navigator.processMouseEvent(Unknown Source)

      at java.awt.Component.processEvent(Unknown Source)
      at java.awt.Container.processEvent(Unknown Source)
      at oracle.bali.ewt.LWComponent.processEventImpl(Unknown Source)
      at oracle.bali.ewt.dTree.DTree.processEventImpl(Unknown Source)
      at oracle.bali.ewt.LWComponent.processEvent(Unknown Source)
      at java.awt.Component.dispatchEventImpl(Unknown Source)
      at java.awt.Container.dispatchEventImpl(Unknown Source)
      at java.awt.Component.dispatchEvent(Unknown Source)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
      at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
      at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
      at java.awt.Container.dispatchEventImpl(Unknown Source)
      at java.awt.Window.dispatchEventImpl(Unknown Source)
      at java.awt.Component.dispatchEvent(Unknown Source)
      at java.awt.EventQueue.dispatchEvent(Unknown Source)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.run(Unknown Source)
      02011.June.06 AD 12:44:20:0634 PM [ERR] ErrorDialog.initialize() Exception:
      java.sql.SQLException: no ocijdbc11 in java.library.path
      at oracle.olap.awm.connection.ConnectionManager.connect(Unknown Source)
      at oracle.olap.awm.connection.ConnectionDialogActionThread.doAction(Unkn
      own Source)
      at oracle.olap.awm.ui.dialog.ThreadedDialogActionThread.run(Unknown Sour
      ce)
      Error Dialog = more_details
        • 1. Re: AWM Error while connecting to 11.1.0.7 db with OLAP option
          User472013-Oracle
          You will encountered bug 12343482 once you get your path to your
          OCI client bin directory fixed. The error message suggests that the
          OCI client bin directory is not on you SYSTEM path leading to the error
          message. Is there some reason that you need to go through a JDBC-think
          connection and not simply use a jdbc thin type i.e. host:port:sid

          There is a workaround that I put in the bug as I filed
          bug 12343482. Please read below.

          I have determined the following is very important:
          The 11.2.0.1 Oracle Client has a version of the ocijdbc11.dll dated
          2/24/2010 size 102,400. This version of the ocijdbc11.dll does not work
          against ojdbc5.jar on Windows XP SP3 and results in the aforementioned
          java.lang.UnsatisfiedLinkError: getLibraryVersionNumber
          at oracle.jdbc.driver.T2CConnection.getLibraryVersionNumber(Native
          Method)
          error.
          Interestingly, if I substitute the version of the ocijdbc11.dll from an
          Oracle Instant Client installation for 11.2, I get a newer version of the
          ocijdbc11.dll dated 11/19/2010 and a companion ocijdbc11.sym also dated
          11/19/2010 which works correctly with the jdbc-thick connection.

          You need to update the ocijdbc11.dll and ocijdbc11.sym in your bin directory
          for the OCI client installation with the files from the 11.2.0.1 Oracle client.

          Once you get past the SYSTEM path issue, you will get the
          java.lang.UnsatisfiedLinkError: getLibraryVersionNumber
          at oracle.jdbc.driver.T2CConnection.getLibraryVersionNumber(Native
          Method)
          error.
          If you wish to open an SR on this error, that would be a good idea please mention
          bug 12343482 if you wish to open an SR on this. If the workaround is sufficient, that
          is fine as well.
          • 2. Re: AWM Error while connecting to 11.1.0.7 db with OLAP option
            chakra
            Hi,
            But I am not using any Oracle 11.2 client. I am using awm112020A as Standalone and its has been able to connect to other 11.1.0.7 OLAB DBs.

            Regards, Anirban
            • 3. Re: AWM Error while connecting to 11.1.0.7 db with OLAP option
              User472013-Oracle
              Hi,
              The error message tells me that you have configured a thick-jdbc connection, the T2CConnection is
              a thick client connection using OCI. Please double check how you have configured your connection
              in AWM. You will find that you have provided a tns alias to the connection string instead of
              host:port:sid. It sounds like you do not want or need an OCI type thick jdbc connection so please
              check and update the connection string for the connection in AWM to host:port:sid.
              • 4. Re: AWM Error while connecting to 11.1.0.7 db with OLAP option
                chakra
                Thanks. We have figured out the issue. We have been giving ServiceName instead of SID in the AWM. Its solved now.
                • 5. Re: AWM Error while connecting to 11.1.0.7 db with OLAP option
                  916438
                  Thanks a lot. Advice to change tns alias to host:port:sid really helps with AWM errors like oracle.jdbc.driver.T2CConnection.getLibraryVersionNumber() etc.

                  Edited by: 913435 on 09.02.2012 3:17