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

REMOTE_LISTENER

Property	Description
Parameter type	String
Syntax	REMOTE_LISTENER = network_name
Default value	There is no default value.
Modifiable	ALTER SYSTEM
Basic	Yes

REMOTE_LISTENER specifies a network name that resolves to an address or address list of Oracle Net remote listeners (that is, listeners that are not running on the same machine as this instance). The address or address list is specified in the TNSNAMES.ORA file or other address repository as configured for your system.

Note

1. See Also:

• Oracle Database Concepts for more information about instances, listener processes, and dispatcher processes
• Oracle Database Net Services Administrator's Guide and your operating system-specific Oracle documentation for more information about specifying network addresses for the protocols on your system

2. 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_LISTENER';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE		ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
remote_listener		TRUE	FALSE	IMMEDIATE	TRUE		FALSE	remote listener

Oracle initializatoin parameters

REMOTE_DEPENDENCIES_MODE

Property	Description
Parameter type	String
Syntax	REMOTE_DEPENDENCIES_MODE = { TIMESTAMP | SIGNATURE }
Default value	TIMESTAMP
Modifiable	ALTER SESSION, ALTER SYSTEM

REMOTE_DEPENDENCIES_MODE specifies how Oracle should handle dependencies upon remote PL/SQL stored procedures.

Values:

• TIMESTAMP

The client running the procedure compares the timestamp recorded on the server-side procedure with the current timestamp of the local procedure and executes the procedure only if the timestamps match.

• SIGNATURE

Oracle allows the procedure to execute as long as the signatures are considered safe. This setting allows client PL/SQL applications to be run without recompilation.

Note

1. See Also Oracle Database Advanced Application Developer's Guide for information about the consequences of the settings of this parameter

2. 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_DEPENDENCIES_MODE';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE		ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
remote_dependencies_mode	TIMESTAMP	TRUE	TRUE	IMMEDIATE	TRUE		FALSE	remote-procedure-call dependencies mode parameter

Oracle initializatoin parameters