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 TNS protocol Adapter error in 11g (11.1.0.6)

700536Jun 20 2009 — edited Jun 20 2009

Hello All,

I have Oracle 11g installed on my machine and when i tried to log in to sql plus i got the error below:

ORA-12560 TNS protocol Adapter error

By setting the ORACLE_SID = orcl by browsing to the bin directory of Oracle Installation the above error disappaears and i am able to log in from sql plus.

My intention is to create a db backup for which i am trying to use the exp command...this time the same error appears.

Also the solution of setting the ORACLE_SID is cumbersome..everytimt i want to use sql plus i need to go in and set the ORACLE_SID.

Can anybody please help me out find a good solution for this?

Any help would be appreciated friends.....

Thanks in Advance!!!!!

Regards.

Alicia

This post has been answered by Aman.... on Jun 20 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2009

Added on Jun 20 2009

#general-database-discussions

6 comments

531 views