OraFAQ Forum: Client Tools » How to connect to Oracle 7 using Oracle client

Home » Other » Client Tools » How to connect to Oracle 7 using Oracle client

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to connect to Oracle 7 using Oracle client [message #535693]

Thu, 15 December 2011 13:10

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

Re: How to connect to Oracle 7 using Oracle client [message #535694 is a reply to message #535693]

Thu, 15 December 2011 13:12

LKBrwn_DBA
Messages: 487
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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to connect to Oracle 7 using Oracle client [message #535696 is a reply to message #535695]

Thu, 15 December 2011 13:17

shikhardadhich
Messages: 4
Registered: December 2011

Junior Member

The client name is: sqldeveloper-3.0.04.34

Report message to a moderator

Re: How to connect to Oracle 7 using Oracle client [message #535697 is a reply to message #535694]

Thu, 15 December 2011 13:18

shikhardadhich
Messages: 4
Registered: December 2011

Junior Member

Then what do with the data which we have Oracle 7???

Report message to a moderator

Re: How to connect to Oracle 7 using Oracle client [message #535698 is a reply to message #535697]

Thu, 15 December 2011 13:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Then what do with the data which we have Oracle 7???
V7 Oracle can be accessed using Oracle V9 software

Report message to a moderator

Re: How to connect to Oracle 7 using Oracle client [message #535699 is a reply to message #535696]

Thu, 15 December 2011 13:34

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to connect to Oracle 7 using Oracle client [message #535700 is a reply to message #535699]

Thu, 15 December 2011 14:18

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).

Report message to a moderator

Re: How to connect to Oracle 7 using Oracle client [message #535717 is a reply to message #535700]

Thu, 15 December 2011 23:14

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	mysql selects with sqldeveloper
Next Topic:	Explain Plan problem - oracle toad

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 12:57:53 CST 2025