How to create a password file

1. Log on as the Oracle owner

2. Shutdown the database

3. UNIX:
cd $ORACLE_HOME/dbs
Windows:
cd $ORACLE_HOME\database

4. Issue the following command. (See explanatory comments at bottom for help)

$ ORAPWD FILE=filename [ENTRIES=numusers] [FORCE={YN}] [IGNORECASE={YN}] [NOSYSDBA={YN}] (NOTE: the NOSYSDBA option can be used only if Oracle OLAP has been implemented)


5. Add, in the init.ora file, the following:

REMOTE_LOGIN_PASSWORDFILE=exclusive

6. Restart the database for this to take affect. (NOTE: If the password file is created for the first time, the database need not be restarted. But if a password file already exists, rename/backup the existing file, create a new password file and restart database for the changed to take effect)



Argument Description
========== ==================================
FILE: Name to assign to the password file. See your operating system documentation for name requirements. You must supply a complete path. If you supply only a file name, the file is written to the current directory.

ENTRIES: (Optional) Maximum number of entries (user accounts) to permit in the file.

FORCE: (Optional) If y, permits overwriting an existing password file.

IGNORECASE: (Optional) If y, passwords are treated as case-insensitive.

NOSYSDBA: (Optional) For Data Vault installations. See the Data Vault installation guide for your platform for more information.

=====================================
NOTE: Under UNIX, the file name MUST be orapw'SID' for the database in which the password file is being created has to be used.