RE: 2 Listeners

From: Sah Kohsuwan <skohsuwan_at_comforce.com>
Date: Tue, 27 Jun 2000 16:35:14 -0400
Message-Id: <10541.110586@fatcity.com>

Hi David,
Yes you can set up multiple listeners. All you have to do is set up different listener name and port number for the second listener (in listener.ora).
Example:
 The default name of the listener is "listener". We created another listener called "train".

#
TRAIN =
(ADDRESS_LIST =

        (ADDRESS= (PROTOCOL= TCP)(Host= cf1)(Port= 1527))   )
SID_LIST_TRAIN =
(SID_LIST =
(SID_DESC =

     (GLOBAL_DBNAME = hr7trn)
     (SID_NAME = hr7trn)
     (ORACLE_HOME = /e40/app/oracle/product/8.0.5)
     )

  )
STARTUP_WAIT_TIME_TRAIN = 0
CONNECT_TIMEOUT_TRAIN = 10
TRACE_LEVEL_TRAIN = OFF LISTENER =
(ADDRESS_LIST =

        (ADDRESS= (PROTOCOL= TCP)(Host= cf1)(Port= 1521))   )
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

     (GLOBAL_DBNAME = hr7sys)
     (SID_NAME = hr7sys)
     (ORACLE_HOME = /e40/app/oracle/product/8.0.5)
     )

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF ------->>>

HTH,
- Sah Kohsuwan

Note: Don't forget to append the name of the listener when you start and stop the listener process.
  Ex: lsnrctl start <listenerName> (default is listener)

         lsnrctl start <----------  Brings up the listener's listener
         lsnrctl start train <---  Brings up the train's listener


> -----Original Message-----
> From:	Olson, David [SMTP:OlsonD_at_PIOS.COM]
> Sent:	Tuesday, June 27, 2000 4:08 PM
> To:	Multiple recipients of list ORACLE-L; oracledba_at_lazydba.com
> Subject:	2 Listeners
> 
> DBA's,
> 
> We have 5 instances running on one large UNIX box.  They are all the same
> version of oracle, 8.0.5.  Connections to the database is starting to get
> the following error:
> 
> [Microsoft][ODBC driver for Oracle][Oracle]ORA-12500: TNS:listener failed
> to
> start a dedicated server process 
> 
> The error message is not constant abd not always from an ODBC connection.
> Talking to our UNIX admin group, we are hitting a max number of child
> process for our listener.  Is it possible to run multiple listeners,
> listening to different ports on the same server?    Or is there another
> work
> around for this problem.  
> 
> Thanks,
> Dave
> 
> Dave Olson
> DBA - Tech. Support Team
> 216-332-3195
> 
> 
> 
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com

> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk Received on Tue Jun 27 2000 - 15:35:14 CDT