Connecting to Oracle 8.1.7 database on Unix
705403Sep 22 2009 — edited Sep 22 2009Hi All
I have a query regarding connecting to an instance on a 8.1.7 database that is running in Unix. I am attempting to connect to the box via Sql Dev 1.5.1 and am getting the following message -
java.lang.ArrayIndexOutOfBoundsException: 4
at oracle.jdbc.driver.T4C8TTIdty.marshal(T4C8TTIdty.java:465)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:329)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465)
at oracle.dbtools.raptor.conntypes.RaptorConnectionWrapper.createConnectionImpl(RaptorConnectionWrapper.java:258)
at oracle.dbtools.raptor.conntypes.RaptorConnectionWrapper.createConnection(RaptorConnectionWrapper.java:171)
at oracle.dbtools.raptor.conntypes.RaptorConnectionWrapper.getJdbcConnection(RaptorConnectionWrapper.java:202)
at oracle.dbtools.raptor.conntypes.RaptorConnectionWrapper.getPresentation(RaptorConnectionWrapper.java:68)
at oracle.dbtools.raptor.utils.Connections$ConnectionInfo.createConnection(Connections.java:1004)
at oracle.dbtools.raptor.utils.Connections$ConnectionInfo$ConnectRunnable.doWork(Connections.java:876)
at oracle.ide.dialogs.ProgressRunnable.run(ProgressRunnable.java:159)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:553)
at java.lang.Thread.run(Thread.java:595)
I googled the query and it came up with the possibility that 1.5.1 SDev is not compatible with earlier versions of Oracle so I tried SDev 1.2.1 from the Oracle website. No luck there either.
I have verified that the database listener is running and have edited my local TNSNAMES. ora and LISTENER.ora to ensure the details are correct. I am attempting to connect via the TNSNAMES which says the listener is not available - ORA 12514. If I try without TNS and use Basic connection it comes up with the error above.
Any suggestions would be great. What I am attempting to do is view the tables on the 8.1.7 box with SQL Dev in Windows XP.
CHEERS!!