Home » SQL & PL/SQL » Client Tools » Protocol Adapter Error (SQL*Plus, 11.1.0.6.0, Windows 2003)
icon9.gif  Protocol Adapter Error [message #321255] Mon, 19 May 2008 11:58 Go to next message
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
Re: Protocol Adapter Error [message #321259 is a reply to message #321255] Mon, 19 May 2008 12:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORACLE_SID variable name and/or value in upper case?
Wrong ORACLE_SID?

Regards
Michel
Re: Protocol Adapter Error [message #321265 is a reply to message #321259] Mon, 19 May 2008 12:39 Go to previous messageGo to next message
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
Re: Protocol Adapter Error [message #321270 is a reply to message #321265] Mon, 19 May 2008 12:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
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
icon7.gif  Re: Protocol Adapter Error [message #321274 is a reply to message #321270] Mon, 19 May 2008 12:59 Go to previous message
natelpeterson
Messages: 6
Registered: May 2008
Location: San Fran
Junior Member
Michel,
It works fine now.
Thanks you very much,
Nathan
Previous Topic: plsql developer error
Next Topic: SQL developer detecting wrong TnsName file
Goto Forum:
  


Current Time: Fri Dec 09 23:05:01 CST 2016

Total time taken to generate the page: 0.10921 seconds