Tuesday, June 14, 2011

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.

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.

No comments:

Post a Comment