Skip to Main Content

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!

OS authentication

845641May 30 2012 — edited May 30 2012
I wondered OS authentication for SYSDBA users disabled automatically if I STARTUP the database by login as SYSDBA through PASSWORDFILE authentication.



For example:-



$ sqlplus



sys@orcl as sysdba

password:-



SQL>STARTUP

After starting database if you try to login as SYSDBA through OS authentication you can't.



$ sqlplus "/as sysdba"



SQL> CONNECTED TO IDLE INSTANCE (Even your database is running).



If anyone already faced this issues and have some solutions, please tell me
This post has been answered by Girish Sharma on May 30 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2012
Added on May 30 2012
4 comments
336 views