REMOTE_LOGIN_PASSWORDFILE

Property	Description
Parameter type	String
Syntax	REMOTE_LOGIN_PASSWORDFILE = { shared | exclusive | none }
Default value	exclusive
Modifiable	No
Basic	Yes
Real Application Clusters	Multiple instances must have the same value.

REMOTE_LOGIN_PASSWORDFILE specifies whether Oracle checks for a password file.

Values:

• shared

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

• exclusive

The password file can be used by only one database. The password file can contain SYS as well as non-SYS users.

• none

Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system.

Note

1. When REMOTE_LOGIN_PASSWORDFILE is set to either exclusive or shared, but the password file does not exist, then the behavior is the same as setting REMOTE_LOGIN_PASSWORDFILE to none.

2. Basic Oracle parameter.

3. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = 'REMOTE_LOGIN_PASSWORDFILE';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE		ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
remote_login_passwordfile	EXCLUSIVE	FALSE	FALSE	FALSE	FALSE		FALSE	password file usage parameter

Oracle initializatoin parameters