REMOTE_LOGIN_ PASSWORDFILE

Setting REMOTE_LOGIN_ PASSWORDFILE

In addition to creating the password file, you must also set the initialization parameter REMOTE_LOGIN_PASSWORDFILE to the appropriate value. The values recognized are:

• NONE
• Setting this parameter to NONE causes Oracle Database to behave as if the password file does not exist. That is, no privileged connections are allowed over nonsecure connections.
• EXCLUSIVE
• (The default) An EXCLUSIVE password file can be used with only one instance of one database. 
• Only an EXCLUSIVE file can be modified. Using an EXCLUSIVE password file enables you to add, modify, and delete users. 
• It also enables you to change the SYS password with the ALTER USER command.
• SHARED
• A SHARED password file can be used by multiple databases running on the same server, or multiple instances of an Oracle Real Application Clusters (RAC) database. 
• A SHARED password file cannot be modified. This means that you cannot add users to a SHARED password file. 
• Any attempt to do so or to change the password of SYS or other users with the SYSDBA or SYSOPER privileges generates an error. 
• All users needing SYSDBA or SYSOPER system privileges must be added to the password file when REMOTE_LOGIN_PASSWORDFILE is set to EXCLUSIVE. 
• After all users are added, you can change REMOTE_LOGIN_PASSWORDFILE to SHARED, and then share the file.
• This option is useful if you are administering multiple databases or a RAC database.

If REMOTE_LOGIN_PASSWORDFILE is set to EXCLUSIVE or SHARED and the password file is missing, this is equivalent to setting REMOTE_LOGIN_PASSWORDFILE to NONE.