Home » SQL & PL/SQL » Client Tools » How to login to Sql *Plus
How to login to Sql *Plus [message #610322] Wed, 19 March 2014 07:22 Go to next message
Messages: 82
Registered: May 2008
Location: bangalore


I need to login to my db via sql*plus but when I m trying to login to db I m getting below error.
ORA-12560: TNS:protocol adapter error

can you please let me know how I can log to sql*plus.
My user name:Control
My db name: Dev#3562

Thanks in advanced.
Re: How to login to Sql *Plus [message #610327 is a reply to message #610322] Wed, 19 March 2014 07:34 Go to previous message
Messages: 520
Registered: September 2013
Senior Member
You've not stated anything about which version of Oracle, nor what OS, but I'll hazard a guess anyway.

Typically I see this problem from people who are running on Windows, and they have either
1) not set ORACLE_SID properly, or
2) the Windows service for the database is not started.

Both of the above also assume that the client and database are on the same machine.
Previous Topic: Replacing &amp
Next Topic: Time stored as a NUMBER field
Goto Forum:

Current Time: Sun Nov 29 21:06:55 CST 2015

Total time taken to generate the page: 0.13292 seconds