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.