craigalbritton
asked on
How do I connect to a remote Oracle 9i database from Windows 7?
I recently upgraded my laptop to Windows 7, and I am now unable to connect to a legacy Oracle 9i database with the Oracle 10g Client or the Oracle 9i Client. The 9i client would never fully install for compatibility reasons, and the 10g client yields this error -->
ORA-03134: Connections to this server version are no longer supported.
I have been digging around this issue for a week or so to no avail, so any help would be greatly appreciated.
ORA-03134: Connections to this server version are no longer supported.
I have been digging around this issue for a week or so to no avail, so any help would be greatly appreciated.
ASKER
slightwv - That's the answer I was dreading, but I will wait a few days to see if any solution surfaces. Thanks!
Not correct...
I connect to a Oracle 9i and 10b from windows 7 using the clients Oracle provide..
Then use Toad or C#..
I connect to a Oracle 9i and 10b from windows 7 using the clients Oracle provide..
Then use Toad or C#..
You will NEED to run it in compatibility mode for Vista if you download the vista client.
You can do this with the help of SQL Developer tool provided by Oracle itself. It is java based and it does not have hassles of installations. In that you can do a direct connect by specifying the IP and SID and no need for TNS configuration. I think SQL Developer can solve your problem easily.
ASKER
After installing the SQL Developer v2.1.1.64, I created a connection for an Oracle 9i database with Connection Type: Basic. Everything else is correct as I have done this many times on pre-Windows7 OS's without any issue. Any ideas?
Here is the error I receive:
java.lang.NullPointerExcep tion
at oracle.jdbc.driver.T4C8TTI dty.marsha l(T4C8TTId ty.java:46 5)
at oracle.jdbc.driver.T4CConn ection.log on(T4CConn ection.jav a:329)
at oracle.jdbc.driver.Physica lConnectio n.<init>(P hysicalCon nection.ja va:490)
at oracle.jdbc.driver.T4CConn ection.<in it>(T4CCon nection.ja va:202)
at oracle.jdbc.driver.T4CDriv erExtensio n.getConne ction(T4CD riverExten sion.java: 33)
at oracle.jdbc.driver.OracleD river.conn ect(Oracle Driver.jav a:465)
at oracle.jdeveloper.db.adapt er.Abstrac tConnectio nCreator.g etConnecti on(Abstrac tConnectio nCreator.j ava:153)
at oracle.dbtools.raptor.stan dalone.con nection.Ra ptorConnec tionCreato r.getConne ction(Rapt orConnecti onCreator. java:195)
at oracle.dbtools.raptor.dial ogs.conn.C onnectionP rompt.prom ptForPassw ord(Connec tionPrompt .java:67)
at oracle.jdeveloper.db.adapt er.Databas eProvider. getConnect ion(Databa seProvider .java:321)
at oracle.jdeveloper.db.adapt er.Databas eProvider. getConnect ion(Databa seProvider .java:254)
at oracle.jdevimpl.db.adapter .CADatabas eFactory.c reateConne ctionImpl( CADatabase Factory.ja va:60)
at oracle.javatools.db.Databa seFactory. createConn ection(Dat abaseFacto ry.java:53 4)
at oracle.javatools.db.Databa seFactory. createData base(Datab aseFactory .java:208)
at oracle.jdeveloper.db.Datab aseConnect ions.getDa tabase(Dat abaseConne ctions.jav a:607)
at oracle.jdeveloper.db.Datab aseConnect ions.getDa tabase(Dat abaseConne ctions.jav a:562)
at oracle.dbtools.raptor.util s.Connecti ons$Connec tionInfo.g etDatabase (Connectio ns.java:14 9)
at oracle.dbtools.raptor.util s.Connecti ons.getCon nection(Co nnections. java:896)
at oracle.dbtools.raptor.util s.Connecti ons.getCon nection(Co nnections. java:877)
at oracle.dbtools.raptor.navi gator.Data baseConnec tion.openC onnectionI mpl(Databa seConnecti on.java:11 7)
at oracle.dbtools.raptor.navi gator.Abst ractConnec tionNode.g etConnecti on(Abstrac tConnectio nNode.java :30)
at oracle.dbtools.raptor.navi gator.Conn ectionFilt er.getFact ory(Connec tionFilter .java:92)
at oracle.dbtools.raptor.navi gator.Conn ectionFilt er$1.doWor k(Connecti onFilter.j ava:117)
at oracle.dbtools.raptor.navi gator.Conn ectionFilt er$1.doWor k(Connecti onFilter.j ava:102)
at oracle.dbtools.raptor.back groundTask .RaptorTas k.call(Rap torTask.ja va:193)
at java.util.concurrent.Futur eTask$Sync .innerRun( FutureTask .java:303)
at java.util.concurrent.Futur eTask.run( FutureTask .java:138)
at oracle.dbtools.raptor.back groundTask .RaptorTas kManager$R aptorFutur eTask.run( RaptorTask Manager.ja va:492)
at java.util.concurrent.Execu tors$Runna bleAdapter .call(Exec utors.java :441)
at java.util.concurrent.Futur eTask$Sync .innerRun( FutureTask .java:303)
at java.util.concurrent.Futur eTask.run( FutureTask .java:138)
at java.util.concurrent.Threa dPoolExecu tor$Worker .runTask(T hreadPoolE xecutor.ja va:886)
at java.util.concurrent.Threa dPoolExecu tor$Worker .run(Threa dPoolExecu tor.java:9 08)
at java.lang.Thread.run(Threa d.java:619 )
Here is the error I receive:
java.lang.NullPointerExcep
at oracle.jdbc.driver.T4C8TTI
at oracle.jdbc.driver.T4CConn
at oracle.jdbc.driver.Physica
at oracle.jdbc.driver.T4CConn
at oracle.jdbc.driver.T4CDriv
at oracle.jdbc.driver.OracleD
at oracle.jdeveloper.db.adapt
at oracle.dbtools.raptor.stan
at oracle.dbtools.raptor.dial
at oracle.jdeveloper.db.adapt
at oracle.jdeveloper.db.adapt
at oracle.jdevimpl.db.adapter
at oracle.javatools.db.Databa
at oracle.javatools.db.Databa
at oracle.jdeveloper.db.Datab
at oracle.jdeveloper.db.Datab
at oracle.dbtools.raptor.util
at oracle.dbtools.raptor.util
at oracle.dbtools.raptor.util
at oracle.dbtools.raptor.navi
at oracle.dbtools.raptor.navi
at oracle.dbtools.raptor.navi
at oracle.dbtools.raptor.navi
at oracle.dbtools.raptor.navi
at oracle.dbtools.raptor.back
at java.util.concurrent.Futur
at java.util.concurrent.Futur
at oracle.dbtools.raptor.back
at java.util.concurrent.Execu
at java.util.concurrent.Futur
at java.util.concurrent.Futur
at java.util.concurrent.Threa
at java.util.concurrent.Threa
at java.lang.Thread.run(Threa
Probably you have not downloaded the sql developer which comes bundled with java. You might be using the one where you have to install java. Try using the bundled one.
Hi
for example right click on sqlplus and then properties
and change the compatibility mode to windowsXP/2000 ......
for example right click on sqlplus and then properties
and change the compatibility mode to windowsXP/2000 ......
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you have the horsepower on the laptop you can create a virtual machine with a supported OS for 9i and connect through it.