Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error logging in to SQL*Plus

The problem I encountered was that I login into SQL*PLUS as system/manager and later if I connect with scott/tiger in the same session I get an error message saying ORA-12560 TNS protocol adapter error. Can you tell me what the exact problem is?
I'm not sure what the exact problem is. But I have seen others with the same problem lately. Basically, once they connect as one user in SQL*Plus, when they attempt to connect as another user in SQL*Plus, they get the ORA-12560 error. I personally haven't experienced the problem. The workaround is to exit SQL*Plus and start a new session. I do recall others saying that applying the latest patchset has fixed their problems.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close