Home » SQL & PL/SQL » Client Tools » How to connect to Oracle 7 using Oracle client
How to connect to Oracle 7 using Oracle client [message #535693] Thu, 15 December 2011 13:10 Go to next message
shikhardadhich
Messages: 4
Registered: December 2011
Junior Member
HI

I have Oracle 7 database on Server1. I need to connect this using Oracle client from windows XP.

I have downloaded Oracle client 3.0 and when I am trying to connect it saying "Unable to connect: Unsupported Oracle version".

Please help.

Thanks
SD

[Updated on: Thu, 15 December 2011 13:11]

Report message to a moderator

icon4.gif  Re: How to connect to Oracle 7 using Oracle client [message #535694 is a reply to message #535693] Thu, 15 December 2011 13:12 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 449
Registered: July 2003
Location: WPB, FL
Senior Member
shikhardadhich wrote on Thu, 15 December 2011 14:10
HI

I have Oracle 7 database on Server1. I need to connect this using Oracle client from windows XP.

I have downloaded Oracle client 3.0 and when I am trying to connect it saying "Unable to connect: Unsupported Oracle version".

Please help.

Thanks
SD


Could it be that Oracle 7 is no longer supported?
What do you think?

[Updated on: Thu, 22 December 2011 00:26] by Moderator

Report message to a moderator

Re: How to connect to Oracle 7 using Oracle client [message #535695 is a reply to message #535693] Thu, 15 December 2011 13:14 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I have downloaded Oracle client 3.0


What is Oracle client 3.0?
Where do you download it from?

Regards
Michel
Re: How to connect to Oracle 7 using Oracle client [message #535696 is a reply to message #535695] Thu, 15 December 2011 13:17 Go to previous messageGo to next message
shikhardadhich
Messages: 4
Registered: December 2011
Junior Member
The client name is: sqldeveloper-3.0.04.34
Re: How to connect to Oracle 7 using Oracle client [message #535697 is a reply to message #535694] Thu, 15 December 2011 13:18 Go to previous messageGo to next message
shikhardadhich
Messages: 4
Registered: December 2011
Junior Member
Then what do with the data which we have Oracle 7???

Re: How to connect to Oracle 7 using Oracle client [message #535698 is a reply to message #535697] Thu, 15 December 2011 13:25 Go to previous messageGo to next message
BlackSwan
Messages: 23146
Registered: January 2009
Senior Member
>Then what do with the data which we have Oracle 7???
V7 Oracle can be accessed using Oracle V9 software
Re: How to connect to Oracle 7 using Oracle client [message #535699 is a reply to message #535696] Thu, 15 December 2011 13:34 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
shikhardadhich wrote on Thu, 15 December 2011 20:17
The client name is: sqldeveloper-3.0.04.34


You can use SQL Developer with Oracle 7 or any 10g or 11g client.
You can use an old version of SQL*Plus (find a 9i or below client) or TOAD or other tool.

Regards
Michel
Re: How to connect to Oracle 7 using Oracle client [message #535700 is a reply to message #535699] Thu, 15 December 2011 14:18 Go to previous messageGo to next message
shikhardadhich
Messages: 4
Registered: December 2011
Junior Member
Michel Cadot wrote on Thu, 15 December 2011 13:34
shikhardadhich wrote on Thu, 15 December 2011 20:17
The client name is: sqldeveloper-3.0.04.34


You can use SQL Developer with Oracle 7 or any 10g or 11g client.
You can use an old version of SQL*Plus (find a 9i or below client) or TOAD or other tool.

Regards
Michel




By the way, I found a note (207303.1) that shows that a 7.3.3 can't connect to a 9i database.
It also shows that all connections using a client version below 9.2.0 is unsupported by Oracle (so, impossible to use the Oracle Service Support).
Re: How to connect to Oracle 7 using Oracle client [message #535717 is a reply to message #535700] Thu, 15 December 2011 23:14 Go to previous message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
By the way, I found a note (207303.1) that shows that a 7.3.3 can't connect to a 9i database

This is why we ask Oracle version with at least 4 decimals. In addition, your case is the opposite: connect a version 7 database from a 9i client.

Quote:
It also shows that all connections using a client version below 9.2.0 is unsupported by Oracle

Yes but with a database in 7.3.3 I should not be worry about my client...

Regards
Michel
Previous Topic: mysql selects with sqldeveloper
Next Topic: Explain Plan problem - oracle toad
Goto Forum:
  


Current Time: Fri Dec 19 05:12:37 CST 2014

Total time taken to generate the page: 0.12467 seconds