2009-08-27

Oracle password file

Just syntax reminder.

RDBMS 11.1
orapwd FILE=filename [ENTRIES=numusers] [FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}]
Unix file name: orapwsid
Windows file name: PWDsid.ora

RDBMS 10.2 for UNIX-Based Operating Systems
orapwd file=orapwsid password=password entries=max_users force=y/n
if FILE is not full path, it is created in current directory.
the password file should be in the $ORACLE_HOME/dbs directory


RDBMS 10.2 for Microsoft Windows
orapwd FILE=PWDsid.ora PASSWORD=password ENTRIES=max_users FORCE=y/n
if FILE is not full path, it is created in current directory.
Oracle Database looks in the registry for the value of parameter ORA_SID_PWFILE. If no value is specified,
then it looks in the registry for the value of parameter ORA_PWFILE, which points to a file containing usernames,
passwords, and privileges. If that is not set, then it uses the default.
so the order is
ORA_SID_PWFILE
ORA_PWFILE
ORACLE_BASE\ORACLE_HOME\DATABASE\PWDsid.ORA

No comments:

Post a Comment