NyQuest logo
HomeBanner 7 FAQTips & Tricksnavtab
menubar
#
# Version Date: Aug-16-04
# Sample Listener.ora file for UNIX Systems running multiple listeners
#
# This file MUST reside in the directory $ORACLE_HOME/network/admin OR
# in the directory as specified by the $TNS_ADMIN environment variable
#
# the hostname/IP and port of the oracle listener must be specified below
# valid port numbers are 1-65535. Note that running the Oracle listener on ports
# less than 1024 require root privileges.
#
# each listener can service mutiple databases, each corresponding database SID and
# $ORACLE_HOME must be defined in the SID_DESC sections
#
# to start the listener, login as the oracle user, run the oraenv environment initialization file, then
# type 'lsnrctl start'
#
# starting a listener without any arguments assumes a listener NAMED LISTENER
#
# Other Listeners must be started by explicitly specifying the name
# EG lsnrctl start LISTENER2
#
# this file defines TWO Listeners, called LISTENER and LISTENER2 #
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= TCP)(Host= <replace with you IP/HOST>)(Port= <port #>))
  )
SID_LIST_LISTENER =
  (SID_LIST =
# begin entry for database #1
   (SID_DESC =
      (ORACLE_HOME= <oracle home directory of database #1>)
      (SID_NAME = <oracle_sid of database #1>)
    )
# end entry for database #1
# begin entry for database #2
   (SID_DESC =
      (ORACLE_HOME= <oracle home directory of database #2>)
      (SID_NAME = <oracle_sid of database #2>)
    )
# end entry for database #2
  )
#
# the following parameters are for program tracing & debugging
# leave alone unless you really know what you're doing
#
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
#
# End definition for LISTENER
# Start definition for LISTENER2
#
LISTENER2 =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= TCP)(Host= <replace with you IP/HOST>)(Port= <port #>))
  )
SID_LIST_LISTENER2 =
  (SID_LIST =
# begin entry for database #3
   (SID_DESC =
      (ORACLE_HOME= <oracle home directory of database #3>)
      (SID_NAME = <oracle_sid of database #3>)
    )
# end entry for database #3
# begin entry for database #4
   (SID_DESC =
      (ORACLE_HOME= <oracle home directory of database #4>)
      (SID_NAME = <oracle_sid of database #4>)
    )
# end entry for database #4
  )
#
# the following parameters are for program tracing & debugging
# leave alone unless you really know what you're doing
#
STARTUP_WAIT_TIME_LISTENER2 = 0
CONNECT_TIMEOUT_LISTENER2 = 10
TRACE_LEVEL_LISTENER2 = OFF


The contents of www.nyquest.com are Copyright © 2007 by Nyquest Consulting.
Sungard® and Banner® are registered trademarks of Sungard® Corporation.
Nyquest is not affiliated in any way with Sungard®.
All Rights Reserved.