Message-Id: <10541.110586@fatcity.com> From: Sah Kohsuwan Date: Tue, 27 Jun 2000 16:35:14 -0400 Subject: RE: 2 Listeners 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 (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@PIOS.COM] > Sent: Tuesday, June 27, 2000 4:08 PM > To: Multiple recipients of list ORACLE-L; oracledba@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@quickdoc.co.uk