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
02-28-2007, 06:19 PM
02-28-2007, 08:56 PM
Like Davey asked, Version would help, but here it goes anyhow.
What is REMOTE_LOGIN_PASSWORDFILE set to?
And remote_password_auth ???
03-01-2007, 04:08 AM
OS? That would be fine on Windows, but on UNIX the group should be DBA
03-01-2007, 04:28 AM
sorry guys, the o/s is windows and version is 10.2.0.1. REMOTE_LOGIN_PASSWORDFILE is set to exclusive.
03-01-2007, 07:01 PM
Chucks, Everything you did looks good to me. Works well with me in my test box.
One more question :
What is the value of SQLNET.AUTHENTICATION_SERVICES in SQLNET.ora file? Should be (NTS)
Sorry am out of ideas.
03-01-2007, 10:30 PM
try to set ORACLE_SID, ORACLE_HOME
03-02-2007, 09:09 AM
Thanks Dil, setting the SQLNET.ora parameter to NTS did the trick. I had it set to NONE.