Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | String |
Syntax | REMOTE_LOGIN_PASSWORDFILE = { shared | exclusive | none } |
Default value | exclusive |
Modifiable | No |
Basic | Yes |
Oracle RAC | 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:
WhenREMOTE_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
.