| Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-03 |
|
|
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.