ora 1031 insufficient privileges
OS = Windows 2000
DB = Oracle 18.104.22.168
sqlnet.ora > SQLNET.AUTHENTICATION_SERVICES = (MTS)
At command prompt, Im trying to connect:
c:> sqlplus "/ as sysdba"
But i got ora-1031 error....
Thanks a lot
i thought its NTS and not MTS?
You can fix your problem right here
Oracle it's not just a database it's a lifestyle!
BTW....You need to get a girlfriend who's last name isn't .jpg
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 ....
does your os user have the right priveleges?
Im using OS user Administrator.....I know its a superuser
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.
Click Here to Expand Forum to Full Width