OraFAQ Forum: Networking and Gateways » TNS protocol adapter error on windows 98

Home » RDBMS Server » Networking and Gateways » TNS protocol adapter error on windows 98

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

TNS protocol adapter error on windows 98 [message #3868]

Wed, 23 October 2002 03:48

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

Report message to a moderator

Re: TNS protocol adapter error on windows 98 [message #3874 is a reply to message #3868]

Wed, 23 October 2002 06:39

B
Messages: 327
Registered: August 1999

Senior Member

did U set ORACLE_SID and ORACLE_HOME ?

Report message to a moderator

Re: TNS protocol adapter error on windows 98 [message #3876 is a reply to message #3874]

Wed, 23 October 2002 06:59

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

Report message to a moderator

Re: TNS protocol adapter error on windows 98 [message #3878 is a reply to message #3874]

Wed, 23 October 2002 07:26

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 )

Report message to a moderator

Previous Topic:	INSERT with single quote
Next Topic:	Listener trivial question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 22:38:35 CST 2024