RE: another listener.ora
Morning, The listener starts using the file listener.ora in the directory pointed to by the environment variable TNS_ADMIN. By default this is set to $ORACLE_HOME/network/admin or $ORACLE_HOME/net80/admin depending on the Oracle version (%ORACLE_HOME%\net... on Windows). You can set the TNS_ADMIN environment variable manually to point to another directory on the server, and the lsnrctl utility will use the listener.ora file there instead of the default. You will have to use a different listener name, however, and some programs called by the listener appear to only run one per platform (e.g. EXTPROC). HTH, Harry Lowes Database Administrator, npower Northern Limited mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: 04 April 2002 00:38 To: Multiple recipients of list ORACLE-L How can I start another listener on same box using another listener.ora file . TIA Bp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lowes, Harry (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: another listener.ora
BP, John's example below is the proper way to do this - not having separate LISTENER.ORA files. Once you have the file setup as below, you simply: lsnrctl start LISTENER_LIVE lsnrctl start LISTENER_DEV Also look at the SET CURRENT_LISTENER command within lsnrctl to use the STATUS and SERVICES commands. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: John Hallas [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 04, 2002 12:48 AMTo: Multiple recipients of list ORACLE-LSubject: RE: another listener.ora You can start several listeners from the same listener.ora file. I am not aware that you can use 2 files to start 2 listeners. I give an example below John ### # Listener service name LISTENER_LIVE # Listens on service LIVE, ports 1522 and 1523 ### LISTENER_LIVE = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = host1)(PORT = 1522)) (ADDRESS = (PROTOCOL = TCP) (HOST =host1)(PORT = 1523)) (ADDRESS = (PROTOCOL = IPC) (KEY = MWO.LOCAL)) ) ) ) LOG_FILE_LISTENER_LIVE = host1_listener_live.log LOG_DIRECTORY_LISTENER_LIVE = /opt/oracle/local/SqlNet/log/ TRACE_LEVEL_LISTENER_LIVE = user TRACE_FILE_LISTENER_LIVE = host1_listener_live.trc TRACE_DIRECTORY_LISTENER_LIVE = /opt/oracle/local/SqlNet/trc/ ### # Listener service name LISTENER_DEV (port 1529) # Listener for DEV purposes only ### LISTENER_DEV = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1529)) ) ) LOG_FILE_LISTENER_DBAS = host1_listener_dbas.log LOG_DIRECTORY_LISTENER_DEV = /opt/oracle/local/SqlNet/log/ TRACE_LEVEL_LISTENER_DEV = off TRACE_FILE_LISTENER_DEV = host1_listener_dev.trc TRACE_DIRECTORY_LISTENER_DEV = /opt/oracle/local/SqlNet/trc/ STARTUP_WAIT_TIME_LISTENER_DEV = 0 CONNECT_TIMEOUT_LISTENER_DEV = 10 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Big PlanetSent: 04 April 2002 01:38To: Multiple recipients of list ORACLE-LSubject: another listener.ora How can I start another listener on same box using another listener.ora file . TIA Bp
another listener.ora
How can I start another listener on same box using another listener.ora file . TIA Bp
RE: another listener.ora
You can start several listeners from the same listener.ora file. I am not aware that you can use 2 files to start 2 listeners. I give an example below John ### # Listener service name LISTENER_LIVE # Listens on service LIVE, ports 1522 and 1523 ### LISTENER_LIVE = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = host1)(PORT = 1522)) (ADDRESS = (PROTOCOL = TCP) (HOST =host1)(PORT = 1523)) (ADDRESS = (PROTOCOL = IPC) (KEY = MWO.LOCAL)) ) ) ) LOG_FILE_LISTENER_LIVE = host1_listener_live.log LOG_DIRECTORY_LISTENER_LIVE = /opt/oracle/local/SqlNet/log/ TRACE_LEVEL_LISTENER_LIVE = user TRACE_FILE_LISTENER_LIVE = host1_listener_live.trc TRACE_DIRECTORY_LISTENER_LIVE = /opt/oracle/local/SqlNet/trc/ ### # Listener service name LISTENER_DEV (port 1529) # Listener for DEV purposes only ### LISTENER_DEV = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1529)) ) ) LOG_FILE_LISTENER_DBAS = host1_listener_dbas.log LOG_DIRECTORY_LISTENER_DEV = /opt/oracle/local/SqlNet/log/ TRACE_LEVEL_LISTENER_DEV = off TRACE_FILE_LISTENER_DEV = host1_listener_dev.trc TRACE_DIRECTORY_LISTENER_DEV = /opt/oracle/local/SqlNet/trc/ STARTUP_WAIT_TIME_LISTENER_DEV = 0 CONNECT_TIMEOUT_LISTENER_DEV = 10 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Big Planet Sent: 04 April 2002 01:38 To: Multiple recipients of list ORACLE-L Subject: another listener.ora How can I start another listener on same box using another listener.ora file . TIA Bp
