Re: Multiple Listeners on Same Oracle Homes

This is easily possible. Go to your listener.ora file and create two listener entries. For example:

LISTENER1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.12.13)(PORT = 1521))     )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = orcl))     )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = SPX)(SERVICE = jonathan_listener))     )
  )

LISTENER2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = jonathan)(PORT = 1523))     )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = orcl1))     )
  )

>From here you can start each listener by doing:

lsnrctl start listener1
lsnrctl start listener2

You may need to create a LISTENER1_SID_LIST and a LISTENER2_SID_LIST. For other listener parameters, the listener name becomes part of the parameter name. For example:

USE_PLUG_AND_PLAY_LISTENER1 = ON
USE_PLUG_AND_PLAY_LISTENER2 = ON You don't need this setting. It's just an example. I hope this makes sense. I realize this is a very quick explanation.

Best regards,

Jonathan
mailto:jonathan_at_gennick.com
http://gennick.com

Thursday, December 07, 2000, 10:27:33 PM, you wrote:

OA> I would like to know if there is a way to start
OA> multiple listeners from the same Oracle Home.
OA> Basically what we want to do is start two listeners on
OA> two different port numbers, one for regular users and
OA> one for overseas users, since we want to monitor the
OA> network traffic between the server and overseas users.