NyQuest logo
HomeBanner 7 FAQTips & Tricksnavtab
menubar
#
# Version Date: Sep-16-97
# Sample Listener.ora file for UNIX Systems running a single listener
# 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'
#
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


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.