The Oracle password file is a file that is created automatically during installation.
Users defined in this file can connect to oracle via sqlplus without entering a password.
To add users to this file, you must give the sysdba permission to a user.
You can give or revoke the sysdba permission to the users with the help of the following script.
GRANT SYSDBA TO username;
REVOKE SYSDBA FROM username;
You can learn which users are defined in this file by using the following script.
Select * FROM V$PWFILE_USERS;
In the following command, we create an oracle password file named orapassfile .
In this file you will be able to define 10 users.
You can find the file in the $ORACLE_HOME/dbs directory.
orapwd FILE=orapassfile ENTRIES=10