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
na.dharma@gmail.com
Messages: 74
Registered: May 2008
Location: bangalore
Member

Hi,

I need to login to my db via sql*plus but when I m trying to login to db I m getting below error.
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.
Razz
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
EdStevens
Messages: 309
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: Sat Oct 25 03:00:20 CDT 2014

Total time taken to generate the page: 0.12575 seconds