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.

ERROR: ORA-12560: TNS:protocol adapter error

953769Aug 3 2012 — edited Sep 26 2012
OS: Windows 7 64-bit
Oracle 11g installed

Error Message:

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter user-name: Ajinkya
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Please Help!!

Comments

mseberg
Try

ALTER SESSION SET CURRENT_SCHEMA=QA



There's also an Oracle note on this :

ALTER SESSION returns ORA-02421 missing or invalid schema authorization identifier. [ID 848248.1]

Best Regards

mseberg
user3636719
Where can I find the note?
mseberg
Answer
Try it without the single quotes.

Best Regards

mseberg


Test on mine :

Release 11.2.0.1.0 - 64bit Productio

I get the same error with quotes

ERROR at line 1:
ORA-02421: missing or invalid schema authorization identifier

Edited by: mseberg on Aug 15, 2011 2:50 PM

So this and then the verify
ALTER SESSION SET CURRENT_SCHEMA=QA
You can verify using this :
select sys_context('USERENV','SESSION_SCHEMA') from dual;
Edited by: mseberg on Aug 15, 2011 3:08 PM
Marked as Answer by user3636719 · Sep 27 2020
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 24 2012
Added on Aug 3 2012
#general-database-discussions
9 comments
323,510 views