$ cd $ORACLE_HOME/dbs
$ orapwd file=orapw
Where,
file = the filename where the password is stored.
password = the password for sys user
entries = the number of users that can connect as sys user at a time. This parameter is optional.
Once the password file is created you need to set the init parameter remote_login_passwordfile for the database to use it.
The possible values for the parameter is
EXCLUSIVE - Only one database can use the password file. Multiple users can exist in the password file.
SHARED - More than one database can use the password file. However only Sys users allowed to have sysdba privilege. You will receive ORA-01999 error when you grant sysdba privilege to other users.
NONE - The password file is not used.
Thanks
No comments:
Post a Comment