Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connecting to Oracle 8.1.7 database on Unix

705403Sep 22 2009 — edited Sep 22 2009
Hi 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!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2009
Added on Sep 22 2009
4 comments
479 views