Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot log in as SYSDBA or SYSOPER - why?
I had a similar problem here's the fix for NT from Oracle support:
1- Set dba_authorization=bypass in the registry
2- Delete and recreate password file, go in oradim and edit password it will
recreate
3- remove dba_authorization=bypass from registry
4- Reboot the server, yes you have to
And after that it should work
> Thanks for the reply, Pete. When I perform the "grant sysdba to <user>"
> command as SYS, I get this:
> ERROR at line 1:
> ORA-01031: insufficient privileges
Received on Thu Sep 02 1999 - 15:16:20 CDT
![]() |
![]() |