LOCAL_LISTENER

Property	Description
Parameter type	String
Syntax	LOCAL_LISTENER = network_name
Default value	(ADDRESS = (PROTOCOL=TCP)(HOST=hostname)(PORT=1521)) where hostname is the network name of the local host.
Modifiable	ALTER SYSTEM
Basic	No

LOCAL_LISTENER specifies a network name that resolves to an address or address list of Oracle Net local listeners (that is, listeners that are 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. Parameter: MTS_LISTENER_ADDRESS

   Parameter: MTS_MULTIPLE_LISTENERS

   Parameter: INSTANCE_NAME

This is the preferred parameter for specifying a listener end point.  Oracle uses this address to perform dynamic instance registration, which is required for failover operations to work properly. When it is present, the LOCAL_LISTENER parameter overrides the obsolete MTS_LISTENER_ADDRESS and MTS_MULTIPLE_LISTENERS parameters if specified.

The instance and dispatchers register certain information with the listener. This information enables the listener to connect clients to the appropriate dispatchers and dedicated servers. In order to connect clients to dedicated servers, the listener and the instance must be running on the same machine.

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) = ‘LOCAL_LISTENER’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
local_listener		TRUE	FALSE	IMMEDIATE	TRUE	FALSE	local listener

Oracle initializatoin parameters