Oracle Password Reset

From Oracle FAQ

ORAPWD is a utility used to create a password file for an Oracle Database.

Run orapwd utility before:

    * setting REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE|SHARED
    * Grant OSDBA/OSOPER to users

Check V$PWFILE_USERS to see who was granted OSDBA/OSOPER access.
[edit] Examples

Create a new password file:

orapwd file=orapwSID password=oracle entries=5

If the password file already exists:

orapwd file=orapwSID password=oracle entries=5 FORCE=Y

The FORCE parameter is available starting from Oracle 10g.

---

All the latest on four wheels and more Get it now.