Friday, February 13, 2009

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