OraFAQ Forum: Networking and Gateways » Problems connecting to 8i

Home » RDBMS Server » Networking and Gateways » Problems connecting to 8i (Oracle 8i, win xp)

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

Problems connecting to 8i [message #303926]

Mon, 03 March 2008 05:33

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

Report message to a moderator

Re: Problems connecting to 8i [message #303928 is a reply to message #303926]

Mon, 03 March 2008 05:36

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: Problems connecting to 8i [message #303955 is a reply to message #303928]

Mon, 03 March 2008 07:29

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 1354 times)

Report message to a moderator

Re: Problems connecting to 8i [message #303960 is a reply to message #303955]

Mon, 03 March 2008 07:54

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Connection from 8i to 10g and the opposite is not supported.

Regards
Michel

Report message to a moderator

Re: Problems connecting to 8i [message #303963 is a reply to message #303960]

Mon, 03 March 2008 08:09

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

Report message to a moderator

Re: Problems connecting to 8i [message #303965 is a reply to message #303963]

Mon, 03 March 2008 08:12

Michel Cadot
Messages: 68641
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

Report message to a moderator

Previous Topic:	Remote connection to Oracle
Next Topic:	Oracle Connectivity Puzzle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 03:30:42 CDT 2024