Thanks for the input. You might find it interesting to know that Pete
Sharman provided a simper solution that also worked. It is:
- The ORA-01994 is because the remote_login_paswordfile parameter is
either
not set or set to SHARED in your init.ora. Change it to EXCLUSIVE, bounce
the
database, and you should be OK.
- The insufficient privileges error means you need to connect as internal
to
perform the grant.
Jonathan Gauthier <jonathan.gauthier_at_cgi.ca> wrote in message
news:oWAz3.47$BV6.308_at_198.235.216.4...
> 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 09 1999 - 12:33:17 CDT
