Hi all,

I wanted clarification on how to log on to a db using just '/as sysdba' (am on the db box itself). I have a test db and on that i have set remote_password_auth to EXCLUSIVE and made sure that i am a member of the ORA_DBA group. I can log in as

sys/password as sysdba

but when i try to log just using /as sysdba, i get an insufficient privs error. I just wanted an explanation as to what else i need to do to gain access this way (i know this not the ideal way of logging but am curious on what needs to be set in order to gain access this way)

Any explanations will be greatly appreciated