Re: Listener question

From: Stephen Ferracioli <ferracioli_at_101freeway.com>
Date: Tue, 10 Jun 2003 06:49:33 GMT
Message-ID: <1cfFa.2443$GQ1.127486207@newssvr21.news.prodigy.com>

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:jnpaev805if0ek9ct72r44lfi63a9eodl8_at_4ax.com...

> Can you have a listener listening on more than one port on the same
> machine?
> Thanks
>
>


            Doc ID:  Note:232010.1
            Subject:  How to Create Multiple Oracle Listeners and Multiple
Listener Addresses
            Type:  BULLETIN
            Status:  PUBLISHED
     Content Type:  TEXT/PLAIN
            Creation Date:  10-MAR-2003
            Last Revision Date:  27-MAR-2003

PURPOSE ------- Guide for Creating Multiple Listeners and Configuring Multiple Addresses in a Single Listener.ora File Creating Multiple Listeners and Configuring Multiple Listener Addresses for a Single

Listener -------------------------------------------------------------------
----------  Important items to note before you begin editing your
listener.ora file:  	a.   IPC KEY values cannot be duplicated across
multiple listeners or in a single listener. 	b.   TCP Port values cannot be
duplicated across multiple listeners or in a single listener
running on a single nic/ip address. 	     (an exception to this is when
multiple nics/IP addresses are used, Reference below)         c.   Unless

the Intelligent agent is used or an External Procedure listener is required, SID_LIST_<listener_name> is not necessary for Oracle version 8i

and newer. 	d.   Non default port specifications in the listener.ora file


(1521 is default) require the               init.ora file parameter

LOCAL_LISTENER be set in order for dynamic registration to work.   	e.   The
version 9i database requires a version 9i listener.     I.  Example of a
single listener with multiple listening addresses  LISTENER =  (ADDRESS_LIST
=       	(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))        	(ADDRESS =


(PROTOCOL = IPC)(KEY = EXTPROC0)) 	(ADDRESS = (PROTOCOL = TCP)(HOST =

hostname.com)(PORT = 1521))        	(ADDRESS = (PROTOCOL = TCP)(HOST =

hostname.com)(PORT = 1526)) ) Note the unique KEY values and PORT numbers are unique. The init.ora LOCAL_LISTENER parameter would be set for all instances serviced by this listener to LOCAL_LISTENER=LSNR_ALIAS. LSNR_ALIAS would be defined in the tnsnames.ora file LOCAL to the database.

Example:  LSNR_ALIAS=       (ADDRESS_LIST=   	(ADDRESS = (PROTOCOL =
TCP)(HOST = hostname.com)(PORT = 1521))        	(ADDRESS = (PROTOCOL =
TCP)(HOST = hostname.com)(PORT = 1526))      )  This will allow PMON to

dynamically register the instance against the listener at both addresses. See Note 76636.1 in Reference section for complete explanation. II. Example of multiple listeners using non-default listener names The following example shows a listener configured for 2 non-default listener names. LSNR817 and LSNR901. LSNR817 is servicing a pre-8i database installed in a separate ORACLE_HOME. Note the ORACLE_HOME value in the

SID_DESC section.  #Listener.ora file 	 LSNR817 =  (ADDRESS_LIST =


(ADDRESS = (PROTOCOL = IPC)(KEY = V817))        (ADDRESS = (PROTOCOL =

IPC)(KEY = extproc1))        (ADDRESS = (PROTOCOL = TCP)(HOST =
hostname.com)(PORT = 1522))     ) SID_LIST_LSNR817=   (SID_LIST =


(SID_DESC =        (SID_NAME = V817)

  (ORACLE_HOME=c:\Oracle\ora81)      )     (SID_DESC =        (SID_NAME =
ORCL806)        (ORACLE_HOME=c:\Orant)      )      (SID_DESC =


(SID_NAME = extproc)       (ORACLE_HOME=c:\Oracle\ora81)        (PROGRAM =

extproc)     )    )     LSNR901 =   (ADDRESS_LIST =        (ADDRESS =


(PROTOCOL = IPC)(KEY = V901))        (ADDRESS = (PROTOCOL = IPC)(KEY =

EXTPROC0))        (ADDRESS = (PROTOCOL = TCP)(HOST = NT1)(PORT = 1521))   )
SID_LIST_LSNR901=     (SID_DESC =        (SID_NAME = extproc)


(ORACLE_HOME=c:\Oracle\ora81)        (PROGRAM = extproc)     )    )   Notes:

The same rules as section I apply here. No duplicate KEY values for IPC and no duplicate port numbers for TCP. LOCAL_LISTENER should be set for non-default (1521 is default) ports to allow dynamic instance registration. The LSNRCTL utility will require that you specify the non-default listener name when issuing commands: e.g. C:\> lsnrctl start LSNR901 C:\> lsnrctl status LSNR901 Or alternatively, c:\>lsnrctl lsnrctl>set current_listener LSNR901 lsnrctl>status When starting listeners for different versions of Oracle be sure to have the Windows Oracle 'Home Selector' or the UNIX env variable ORACLE_HOME set to point to the correct

location.  Troubleshooting -----------------         If lsnrctl start yields

any of the following errors: ORA-12542 TNS:address already in use. TNS-1106 Listener using listener name %s has already been started ORA-12542 occurs when the port specified in the listener.ora file is already in use by another process. Typically another listener process is already running. Check netstat -an |grep on <port#>. TNS-1106 occurs when a KEY value has been duplicated. e.g. A listener using KEY=EXTPROC is already running when you attempt to start a listener configured with KEY=EXTPROC. See note 118999.1 in References for additional troubleshooting tips.

 References ----------------- 76636.1  Service Registration in Net 8i

111966.1 Configuring Multiple Listeners to Use the Same TCP Port Number 226880.1 Configuration of Load Balancing and Transparent Application Failover 161634.1 Configuring the Database Listener for External Procedures 118999.1 Starting the Listener on Windows NT - Troubleshooting . Received on Tue Jun 10 2003 - 01:49:33 CDT