ora-01301 insufficient privileges

[savourys]

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.

any ideas??

or is there a way to turn nt authentication off???


cheers muchly sean

[Chucks_k]

Have u created the password file?

[davey23uk]

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?

[savourys]

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.