Oracle Password File

You can create a password file using the password file creation utility, ORAPWD. For some operating systems, you can create this file as part of your standard installation.

To enable authentication of an administrative user using password file authentication you must do the following:

1. If not already created, create the password file using the ORAPWD utility:

   ORAPWD FILE=filename PASSWORD=password ENTRIES=max_users
   
   

   Note:

   REMOTE_LOGIN_PASSWORDFILE is a static initialization parameter and therefore cannot be changed without restarting the database.

2. Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE. (This is the default).

Connect to the database as user SYS (or as another user with the administrative privileges).

1. If the user does not already exist in the database, create the user.

2. Grant the SYSDBA or SYSOPER system privilege to the user:

   GRANT SYSDBA to oe;
   This statement adds the user to the password file, thereby enabling connection AS SYSDBA.