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.
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