– Set init parameter to REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE.
parameter be set to either SHARED or EXCLUSIVE.
SHARED the password file can be used by multiple databases and only the SYS user is recognized.
EXCLUSIVE the password file can be used by only one database and multiple users can exist in the file.
The parameter value can be confirmed by:
SQL> show parameter password
NAME TYPE VALUE
—————————– ———– ———-
remote_login_passwordfile string EXCLUSIVE
– Create the password file using the ORAPWD utility.
orapwd file=<filename> password=<password> entries=<max_users>
– Connect to the database as user SYS (or as another user with the administrative privilege).
If the user does not already exist in the database, create the user.
Grant the SYSDBA or SYSOPER system privilege to the user.
This will add the user to the password file, and that user’s name and privilege information are added to the password file.
SQL> grant sysdba to scott;
– Confirm that the user is listed in the password file.
SQL> select * from v$pwfile_users;
USERNAME SYSDBA SYSOPER
—————————— —— ——-
SYS TRUE TRUE
SCOTT TRUE FALSE