Re: insufficient privileges as sysdba 8.1.7 on Win2k

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 2 Oct 2002 20:08:57 -0700
Message-ID: <92eeeff0.0210021908.1aafc164@posting.google.com>

> Use oradim to drop the Oracle Windows service
> Delete the password file PWD<sid_name>.ora
> Recreate the Oracle Windows service with oradim
>
> That should do it unless somehow you have been playing around in the
> registry and dropped the pointer to the password file.
>
> Daniel Morgan

You can also just recreate the password file using orapwd.

1) Shutdown database as internal from svrmgrl
2) Delete old PWD<SID>.ora file
3) orapwd file=%ORACLE_HOME%\database\pwd<sid>.ora password=xxxxxx
4) Start database as internal from svrmgrl
5) grant sysdba to system;
6) Exit from svrmgrl and login as system then try again

/Rauf Sarwar Received on Wed Oct 02 2002 - 22:08:57 CDT