Oracle Password File

Creating a Password File and Adding New Users to It
Use the following procedure to create a password and add new users to it:
1. Follow the instructions for creating  a password file as explained in "Creating a Password File with ORAPWD"  on page 1-23.
2. Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE. (This is the default.)
3. Connect with SYSDBA  privileges as shown in the following example, and enter the SYS  password when prompted:CONNECT SYS AS SYSDBA
4. Start up the instance and create the databa se if necessary, or mount and open an existing database.
5. Create users as necessary. Grant SYSDBA  or  SYSOPER privileges to yourself and other users as appropriate. See  "Granting and Revoking SYSDBA and SYSOPER Privileges" , later in this section.

 

1. Identify the users who have  SYSDBA  or  SYSOPER privileges by querying the V$PWFILE_USERS view.
2. Delete the existing password file.
3. Follow the instructions for creating a new password file using the ORAPWD  utility in "Creating a Password File with ORAPWD"  on page 1-23. Ensure that the ENTRIES parameter is set to a number larger than you think you will ever need.

4. Follow the instructions in  "Adding Users to a Password File" on page 1-26.

 

ps:  REMOTE_LOGIN_PASSWORDFILE is in $ORACLE_HOME/dbs/init.ora