Home » RDBMS Server » Networking and Gateways » Problems connecting to 8i (Oracle 8i, win xp)
Problems connecting to 8i [message #303926] Mon, 03 March 2008 05:33 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
hI,

I am working at a client side where they had an old 8i system.

I am trying to connect to 8i system but getting error

Quote:
ora-12560 - tns:protocol adapter error


I tried editing the tnsnames.ora, listener.ora file but the problem still persists. I tried to configure the files through net configuration assistant but it does not open.


What steps should I take to resolve this issue?

Please let me know if this information is not enough.

- Das
Re: Problems connecting to 8i [message #303928 is a reply to message #303926] Mon, 03 March 2008 05:36 Go to previous messageGo to next message
Michel Cadot
Messages: 58851
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What steps should I take to resolve this issue?

First posting how you tried to connect.

Regards
Michel
Re: Problems connecting to 8i [message #303955 is a reply to message #303928] Mon, 03 March 2008 07:29 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

Here it is

Attached are copies of the tnsnames.ora, listener.ora and sqlnet.ora files. This is the state I got it when I was assigned the work. The systems also has an installation of oracle 10g (which has the service name PRO).

The default home is of 8i so when did the following

cmd>sqlplus


8i opened asking for username, I did the following

sql> username /as sysdba
and it connected to 10g

Then I checked the tnsnames.ora file and it showed PRO(10g) as the sid name. so I changed it to Oracle (8i), then tried again

sql> username /as sysdba
sql> username sys
sql> password sys


but it gave me error
Quote:
ora-12560 - tns:protocol adapter error
.

I know the I will have to configure listener and edit the files but not very sure how to go about it.

Any suggestions?

- Das
  • Attachment: data.txt
    (Size: 2.53KB, Downloaded 171 times)
Re: Problems connecting to 8i [message #303960 is a reply to message #303955] Mon, 03 March 2008 07:54 Go to previous messageGo to next message
Michel Cadot
Messages: 58851
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Connection from 8i to 10g and the opposite is not supported.

Regards
Michel
Re: Problems connecting to 8i [message #303963 is a reply to message #303960] Mon, 03 March 2008 08:09 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks

but how do I connect to 8i.. which is still there on the server.

Should I deinstall 10g first? Or should I use the net8 configuration assistant and try something out

- Das
Re: Problems connecting to 8i [message #303965 is a reply to message #303963] Mon, 03 March 2008 08:12 Go to previous message
Michel Cadot
Messages: 58851
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use 8i or 9i product to connect to 8i database.
Don't use 10g ones.
You don't have to deinstall 10g, just use another home.

Regards
Michel
Previous Topic: Remote connection to Oracle
Next Topic: Oracle Connectivity Puzzle
Goto Forum:
  


Current Time: Thu Aug 21 04:09:02 CDT 2014

Total time taken to generate the page: 0.06851 seconds