Home » Other » 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: 82
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

Report message to a moderator

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: 1376
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.

Report message to a moderator

Previous Topic: Replacing &amp
Next Topic: Time stored as a NUMBER field
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 24 21:46:08 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.