REMOTE_LOGIN_PASSWORDFILE

REMOTE_LOGIN_PASSWORDFILE specifies whether Oracle checks for a password file.

Property	Description
Parameter type	String
Syntax	REMOTE_LOGIN_PASSWORDFILE = { SHARED | EXCLUSIVE | NONE }
Default value	EXCLUSIVE
Modifiable	No
Modifiable in a PDB	No
Basic	Yes
Oracle RAC	Multiple instances must have the same value.

Values

• SHARED

  One or more databases can use the password file. The password file can contain SYS and non-SYS users.

  When REMOTE_LOGIN_PASSWORDFILE is set to SHARED:

  • The database disables modification of the password file by an ASM or RDBMS instance.

  • If you attempt to change the password of a user that is in the password file, the operation fails with “ORA-01999: password file cannot be updated in SHARED mode.

  • If you attempt to change the password of an administrative user (except SYS) that is not in the password file, the password change operation will succeed, but the new password will not go into effect. This is because the password is updated only in the data dictionary and not in the password file.

  • Grants and revokes of administrative privileges (SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, SYSKM) to or from individual users are not allowed. For example, GRANT SYSDBA TO SCOTT fails with “ORA-01999: password file cannot be updated in SHARED mode.”

  • If the password file does not exist, then the behavior is the same as setting REMOTE_LOGIN_PASSWORDFILE to NONE.

• EXCLUSIVE

  The password file is intended for use by ASM instances in the same cluster or by one or more instances of the same Oracle database.

  The password file can contain SYS and non-SYS users.

  If the password file does not exist, then the behavior is the same as setting REMOTE_LOGIN_PASSWORDFILE to NONE.

• NONE

  ASM and RDBMS instances ignore the password file. Therefore, privileged users must be authenticated by the operating system.

Note: If you change REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE or SHARED from NONE, then ensure that the password file is synchronized with the dictionary passwords.