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