OraFAQ Forum: Networking and Gateways » ERROR: ORA-12560: TNS:protocol adapter error

Home » RDBMS Server » Networking and Gateways » ERROR: ORA-12560: TNS:protocol adapter error

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

ERROR: ORA-12560: TNS:protocol adapter error [message #10509]

Tue, 27 January 2004 10:00

Eric
Messages: 78
Registered: April 1999

Member

Hi,

I tried setting up the SQL*Plus environment as suggested here:

http://www.orafaq.org/faqplus.htm#USE

I typed in

Click on "Start" -> "Run" and enter "cmd"
C:> set ORACLE_SID=orcl
C:> sqlplus scott/tiger

and the output I got was this:

ERROR:
ORA-12560: TNS:protocol adapter error

What is the problem? And how to resolve this?

Thanks in advance!

Eric

Report message to a moderator

Re: ERROR: ORA-12560: TNS:protocol adapter error [message #10514 is a reply to message #10509]

Tue, 27 January 2004 21:23

georphin
Messages: 3
Registered: January 2004

Junior Member

If protocol adapter error occur just check whether tnslistener/
oracle serice is started or not .you can see the status of both
in services

Report message to a moderator

Previous Topic:	listener process size increasing abnormaly
Next Topic:	ORA-12549 - Cant attach to oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 13 17:34:46 CST 2026