OraFAQ Forum: Client Tools » Protocol Adapter Error

Home » Other » Client Tools » Protocol Adapter Error (SQL*Plus, 11.1.0.6.0, Windows 2003)

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

Protocol Adapter Error [message #321255]

Mon, 19 May 2008 11:58

natelpeterson
Messages: 6
Registered: May 2008
Location: San Fran

Junior Member

I downloaded 11g for dev purposes. I can open SQL*Plus directly, but when I type the following in the command prompt:

set oracle_sid=db11g
sqlplus /

It names the SQL*Plus version it's trying to open but throws the following error:
ORA-12560: TNS:protocol adapter error

I wonder how I can figure out why this is happening?

Thanks,
Nathan

Report message to a moderator

Re: Protocol Adapter Error [message #321259 is a reply to message #321255]

Mon, 19 May 2008 12:07

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORACLE_SID variable name and/or value in upper case?
Wrong ORACLE_SID?

Regards
Michel

Report message to a moderator

Re: Protocol Adapter Error [message #321265 is a reply to message #321259]

Mon, 19 May 2008 12:39

natelpeterson
Messages: 6
Registered: May 2008
Location: San Fran

Junior Member

Thank you very much Michel. I mis-interpreted what the ORACLE_SID was supposed to be. (btw it's not case-sensitive)
Regards,
Nathan

Report message to a moderator

Re: Protocol Adapter Error [message #321270 is a reply to message #321265]

Mon, 19 May 2008 12:49

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is the name of the Oracle service, you can find it in Windows Services box (just the last part after "OracleService).

Regards
Michel

Report message to a moderator

Re: Protocol Adapter Error [message #321274 is a reply to message #321270]

Mon, 19 May 2008 12:59

natelpeterson
Messages: 6
Registered: May 2008
Location: San Fran

Junior Member

Michel,
It works fine now.
Thanks you very much,
Nathan

Report message to a moderator

Previous Topic:	plsql developer error
Next Topic:	SQL developer detecting wrong TnsName file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 07:35:14 CST 2025