ora 1031 insufficient privileges

Hi Friends,

OS = Windows 2000
DB = Oracle 9.2.0.1
sqlnet.ora > SQLNET.AUTHENTICATION_SERVICES = (MTS)


At command prompt, Im trying to connect:

c:> sqlplus "/ as sysdba"

But i got ora-1031 error....

s.o.s plsss...


Thanks a lot

i thought its NTS and not MTS?

You can fix your problem right here

:D sorry just a typo err...its NTS actually...

Hi im looking at metalink now.... most of the post though are little bit old...general guidelines for DB 7.3 to 9.0 and mentioning INTERNAL connections....I understand connect INTERNAL is not supported anymore.

Still searching for more clues:D ....

does your os user have the right priveleges?

hi dave...

Im using OS user Administrator.....I know its a superuser

Thanks

have you tried to connecting after setting
SQLNET.AUTHENTICATION_SERVICES= (NTS) and
are you still getting the same ora error?

needs to be part of the ORA_DBA group to do "/ as sysdba"

Hi kuya....the installer actually pre-sets SQLNET.ORA with the
value SQLNET.AUTHENTICATION_SERVICES= (NTS) , so i did not change
any settings here. I just forgot the SYS password so i tried
connect to "/ as sysdba" and found out its not working.

We have also another test server with similar set-up (same OS and DB)
and it is working fine. I did not set any ORA_DBA group here and im
using Administrator OS account also when i install oracle.

Ill try to ask our SYSTEMS ADMINISTRATOR if he had set any ORA_DBA group in the prod server.


Thanks again.

Hi...i got it....the systems administrator told me to use the local administrator acct who got ora_dba priv, not the domain administrator acct.

Thank you :D