3 Replies Latest reply: Mar 7, 2013 4:43 PM by Ayush Ganeriwal-Oracle RSS

    'Connection Failed' when testing Oracle 'Data Server'

    billyofmtl
      Hello,

      I receive a 'Connection Failed' error when clicking on the Test button after creating a connection to an Oracle Data Server within ODI 10.1.3.5.

      The datasource is Oracle DB 11.2.0.3.

      The error reads:

      Connection failed

      com.sunopsis.sql.c: oracle/jdbc/driver/OracleDriver
           at com.sunopsis.sql.SnpsConnection.a(SnpsConnection.java)
           at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java)
           at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java)
           at com.sunopsis.graphical.l.pm.o(pm.java)
           at com.sunopsis.graphical.l.pm.r(pm.java)
           at com.sunopsis.graphical.l.pm.g(pm.java)
           at com.sunopsis.graphical.l.pm.a(pm.java)
           at com.sunopsis.graphical.l.pm.a(pm.java)
           at com.sunopsis.graphical.l.iz.actionPerformed(iz.java)
           at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
           at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)
           at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
           at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
           at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
           at java.awt.Component.processMouseEvent(Unknown Source)
           at java.awt.Component.processEvent(Unknown Source)
           at java.awt.Container.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.pumpOneEventForHierarchy(Unknown Source)
           at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
           at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
           at java.awt.Dialog$1.run(Unknown Source)
           at java.awt.Dialog.show(Unknown Source)
           at java.awt.Component.show(Unknown Source)
           at java.awt.Component.setVisible(Unknown Source)
           at com.sunopsis.graphical.l.pm.q(pm.java)
           at com.sunopsis.graphical.l.pm.<init>(pm.java)
           at com.sunopsis.graphical.frame.b.jh.bx(jh.java)
           at com.sunopsis.graphical.frame.bo.w(bo.java)
           at com.sunopsis.graphical.frame.bo.d(bo.java)
           at com.sunopsis.graphical.frame.w.actionPerformed(w.java)
           at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
           at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)
           at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
           at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
           at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
           at java.awt.Component.processMouseEvent(Unknown Source)
           at java.awt.Component.processEvent(Unknown Source)
           at java.awt.Container.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.pumpOneEventForHierarchy(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)

      This is a new install and we are using Java 1.4.2 which comes bundled with ODI 10.1.3.5. I have tried modifying the path to the ODI_JAVA_HOME manually in odiparams.bat and the path to the ODI_HOME manually within the topology.bat located in \bin, with no success.

      I have also tried using each of the OJDBC's along with their respective JDK/JRE's with no success:
      http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

      The ojdbc5.jar and ojdbc14.jar that we have examined seem to have the proper directory structure when examined using 7zip. (thus, no corruption)

      Has anyone seen this type of issue?

      Thanks in advance for your help.