Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlplus - ORACLE_SID - UNIX

848959Sep 8 2011 — edited Sep 8 2011
Hi,

I would like to connect to SQLPLUS from UNIX without providing database name like given below,

$sqlplus username/password

I tried providing ORACLE_SID value with the DB Name and invoked the above command, it gives "ORA-12162: TNS:net service name is incorrectly specified" error message.

What is the real use of ORACLE_SID here?

When I try as given below, it works well.

$sqlplus username@dbname/password

Please guide me, thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2011
Added on Sep 8 2011
#general-database-discussions
4 comments
9,170 views