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!

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 10 2010

Added on Nov 12 2010

#general-database-discussions

19 comments

4,317 views