OraFAQ Forum: Server Administration » connecting Oracle8 sql*plus using Oracle9i Database

Home » RDBMS Server » Server Administration » connecting Oracle8 sql*plus using Oracle9i Database - urgent

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

connecting Oracle8 sql*plus using Oracle9i Database - urgent [message #62967]

Sun, 29 August 2004 23:41

Sachidananda Mahana
Messages: 4
Registered: July 2004

Junior Member

Pl help me
Is it possible to use older verson of oracle8 sqlplus
by connecting oracle9i database?

If Yes pl. tell me the procedure of connectivity to
oracle9i.

Regards

S. Mahana

Report message to a moderator

Re: connecting Oracle8 sql*plus using Oracle9i Database - urgent [message #62969 is a reply to message #62967]

Mon, 30 August 2004 00:15

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

you can connect to the database from lower vesrion to higher version

check out the following things on Oracle 8.version system Tnsnames file add a entry for service name of oracle 9i on ur system save the file and connect to the database with that service name

eg scott/tiger@servicename

it will work

Report message to a moderator

Re: connecting Oracle8 sql*plus using Oracle9i Database - urgent [message #62982 is a reply to message #62967]

Mon, 30 August 2004 06:52

Suresh
Messages: 189
Registered: December 1998

Senior Member

Hi,
It is possible, there is no different. configure tnsnames.ora.

If you need to know the configaration proceduere.
Here is a link for that.

http://www.easywebtech.com/exam/sqlstudyguid2.html

Suresh

Report message to a moderator

Previous Topic:	How to run the oracle with 2 different server host name?
Next Topic:	import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 04:03:28 CST 2025