CREATING AN ORACLE PASSWORD FILE

CREATING AN ORACLE PASSWORD FILE
You can easily create an Oracle password file with the help of the orapwd utility. Just type orapwd at the
operating system command line to view the syntax of the command:
$ orapwd
Usage: orapwd file= password= entries= force=
ignorecase= nosysdba=
where
file - name of password file (required),
password - password for SYS (required),
entries - maximum number of distinct DBA (required),
force - whether to overwrite existing file (optional),
ignorecase - passwords are case-insensitive (optional),
nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).
There must be no spaces around the equal-to (=) character.
5
Of the six options for the orapwd utility, the file, password, and entries options are mandatory.
You can create a simple Oracle password file using the following syntax:
$ orapwd file=mydb_pwd password=sammyy1 entries=20
This command will create an Oracle password file. The default location for the password file is the
$ORACLE_HOME/dbs directory. Once you create the password file, edit your init.ora file or your spfile in the
following manner:
remote_login_passwordfile = 'EXCLUSIVE'
Once your restart your database after this, you’ll be able to log in as the sys user.