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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-12560 -sqlplus

NadviNov 12 2010 — edited Nov 12 2010
Hi Experts,

I am facing ORA-12560 from windows client PC using sqlplus.


I can echo my SID.

Y:\>echo %ORACLE_SID%
TESTDB


It can connect to database once I specify the database Name:

Y:\>sqlplus system/******@TESTDB

Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production

But doesn't login with environment variable.

Y:\>sqlplus system/******

*ERROR:
ORA-12560: TNS:protocol adapter error*


I did tnsping and succeeded.

Y:\>tnsping TESTDB


Any idea?

Thanks.

Edited by: Nadvi on Nov 12, 2010 11:09 AM
This post has been answered by Prathmesh B on Nov 12 2010
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 10 2010
Added on Nov 12 2010
#general-database-discussions
19 comments
4,266 views