ora-01031 insufficient privileges
Got a newly upgraded db from 9i to 10g r2.
Cannot use conn /as sysdba in sqlplus for the life of me. everything i read points to nt authentication but the user logged onto the server is in the ora_dba group.
can connect another user as sysdba but prefer to use the above.
or is there a way to turn nt authentication off???
cheers muchly sean
Last edited by savourys; 01-12-2007 at 09:09 AM.
Have u created the password file?
that has got nothing to do with 'connect / as sysdba' password files arent used in that situation
To the OP - whats in your sqlnet.ora file?
Sorted it, was a combination of the path enivro variable not being set correctly and also the sqlnet.ora file missing the nt authentication entry missing.
cheers for your suggestions anyway.
Click Here to Expand Forum to Full Width