Home » RDBMS Server » Networking and Gateways » ERROR: ORA-12560: TNS:protocol adapter error
ERROR: ORA-12560: TNS:protocol adapter error [message #10509] Tue, 27 January 2004 10:00 Go to next message
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
Re: ERROR: ORA-12560: TNS:protocol adapter error [message #10514 is a reply to message #10509] Tue, 27 January 2004 21:23 Go to previous message
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
Previous Topic: listener process size increasing abnormaly
Next Topic: ORA-12549 - Cant attach to oracle
Goto Forum:
  


Current Time: Wed May 01 21:10:38 CDT 2024