Re: How to start two listeners on one databsase

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Sat, 20 Apr 2002 05:18:40 -0500
Message-ID: <uc2g41ou5juga0@corp.supernews.com>

Hi:

An excert from the latest edition of my book: 'So You Want to be an Oracle DBA?' (third Edition) (Due out any day. Available at www.iuniverse.com )

Multiple Listeners - On an extremely busy system that supports a large quantity of connections, it may be beneficial to configure a second listener on a second port. This port can use a second TCP/IP address if your system has been configured for multiple TCP/IP addresses. This method is also useful for a system that has high data base link activity. You can configure the second listener to listen only for requests over the data base link. In your listener.ora file add: LSNR_MYSID =

(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = MYMACHINE2)
(PORT = 1526)

)
)
STARTUP_WAIT_TIME_LSNR_MYSID = 0
CONNECT_TIMEOUT_LSNR_MYSID = 10
LOG_DIRECTORY_LSNR_MYSID = /opt/dbms/oracle/ora816/network/ log
LOG_FILE_LSNR_MYSID = LSNR_MYSID.log
SID_LIST_LSNR_MYSID =

(SID_LIST =
(SID_DESC =
(SID_NAME = MYSID)
(ORACLE_HOME= /opt/dbms/oracle/ora816/)))

TRACE_LEVEL_LSNR_MYSID = OFF
You should notice all occurrences of LISTENER, which is the default listener name, are now the second listener's name. The use of lsnrctl utility is the same as normal except that you add the listener name to your command. For example to start your second listener: lsnrctl start LSNR_MYSID

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Nir Oran" <nir_oran_at_yahoo.com> wrote in message news:25ff970b.0204200104.5a45f68c_at_posting.google.com...
> Hi.
>
> Please tell me the syntax for starting two listeners on different
> ports on the same database. ( 8.1.7 )
>
>
> Thanx a LOT !
Received on Sat Apr 20 2002 - 05:18:40 CDT