Home » RDBMS Server » Networking and Gateways » TNS protocol adapter error on windows 98
TNS protocol adapter error on windows 98 [message #3868] Wed, 23 October 2002 03:48 Go to next message
Balaji
Messages: 102
Registered: October 2000
Senior Member
Hi all,

I have installed Oracle 9iAS on Windows 98 OS. The installation went on smooth without any problems.

But when I start the SQL Plus, I get prompted with the error as,

ORA 12560:TNS:protocol adapter error.

I tried for the answers over the forum but in vain. Can anyone please help me how sort out this problem.

Thanks in advance,

With Regards,

Balaji.SN
Re: TNS protocol adapter error on windows 98 [message #3874 is a reply to message #3868] Wed, 23 October 2002 06:39 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
did U set ORACLE_SID and ORACLE_HOME ?
Re: TNS protocol adapter error on windows 98 [message #3876 is a reply to message #3874] Wed, 23 October 2002 06:59 Go to previous messageGo to next message
Balaji
Messages: 102
Registered: October 2000
Senior Member
Hi,

Thankx for your reply.

To what path do I need to set the both of the above variables. I have not done anything about the same. Could u please guide me.

Thanking you,

With Regards,

Balaji.SN
Re: TNS protocol adapter error on windows 98 [message #3878 is a reply to message #3874] Wed, 23 October 2002 07:26 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
ORACLE_SID=name of ur database
ORACLE_HOME=installation path of Oracle

DOS> set ORACLE_HOME
DOS> set ORACLE_SID

to show the actual value

DOS> set ORACLE=HOME=PATH_ORACLE ( to set it )
Previous Topic: INSERT with single quote
Next Topic: Listener trivial question
Goto Forum:
  


Current Time: Thu Feb 29 09:04:34 CST 2024