Oracle Database - Configuration of the Listener (listener.ora)

Card Puncher Data Processing

About

A listener is configured with one or more listening protocol addresses, information about supported services, and parameters that control its run-time behavior. The listener configuration is stored in the configuration file named listener.ora.

Located on the database server, this configuration file may include:

  • Protocol addresses it is accepting connection requests on
  • Database and nondatabase services it is listening for
  • Control parameters used by the listener

If the file is not found in the directory specified by the TNS_ADMIN, then Oracle Net will check the ORACLE_HOME/network/admin directory.

Because all of the configuration parameters have default values, it is possible to start and use a listener with no configuration. This default listener has a name of LISTENER, supports no services on startup, and listens on the following TCP/IP protocol address:

(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1521))

The listener forwards client requests to supported services. These services can be configured statically in the listener.ora file or they can be dynamically registered with the listener. This dynamic registration feature is called service registration.

Example and Syntax

The LISTENER entry defines the listening protocol address for a listener named LISTENER, and the SID_LIST_LISTENER entry provides information about the external services statically supported by the listener LISTENER.

LISTENER=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc) (queuesize=50))
    )
   )
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (SID_NAME=plsextproc)
      (ORACLE_HOME=/oracle11g)
      (PROGRAM=extproc)
     )
     (SID_DESC = 
        (SDU=16384)
        (TDU=16384) 
        (ORACLE_HOME = /.....)
        (SID_NAME = SOLAP)
     ) 
   )

To know more about the parameters, see this page: Oracle Net Listener Parameters (listener.ora)

Example of a listener.ora of an EBS database:

VIS =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ebs121.gerardnico.com)(PORT = 1521))
    )
  )

SID_LIST_VIS =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME= /d01/oracle/VIS/db/tech_st/11.1.0)
      (SID_NAME = VIS)
    )
  )

STARTUP_WAIT_TIME_VIS = 0
CONNECT_TIMEOUT_VIS = 10
TRACE_LEVEL_VIS = OFF

LOG_DIRECTORY_VIS = /d01/oracle/VIS/db/tech_st/11.1.0/network/admin
LOG_FILE_VIS = VIS
TRACE_DIRECTORY_VIS = /d01/oracle/VIS/db/tech_st/11.1.0/network/admin
TRACE_FILE_VIS = VIS
ADMIN_RESTRICTIONS_VIS = OFF
SUBSCRIBE_FOR_NODE_DOWN_EVENT_VIS = OFF


IFILE=/d01/oracle/VIS/db/tech_st/11.1.0/network/admin/VIS_ebs121/listener_ifile.ora

Configuration with Net configuration assistant

With Net configuration assistant : Add/install > “Listener Configuration” > “Add” > Tape a LISTENER name of leave the default value : “LISTENER” > More Listener ? : No > Use the standard port number of 1521 > The listener must install. At the end of the installation, you must view it in the services.

DEFAULT_SERVICE_MYLISTENER

The DEFAULT_SERVICE_listener_name parameter to enable users to connect to the database without having to specify a service name.

DEFAULT_SERVICE_LISTENER=ORCL.gerardnico.local





Discover More
Obia Powercenter Topology
OBIA - Installation Version 7.9.6 with EBS, PowerCenter, Oracle Database on Windows

Roadmap To install and set up Oracle BI Applications, do the following: preinstallation steps for the source...
Hs Odbc Excel Define Name
Oracle Database - How to read data through an ODBC connection with Gateway (Heterogeneous services)

This article is aimed to show how you can access data from oracle database via an odbc connection direct by using the gateway odbc agent (or program) generic connectivity. In this example, an odbc connection...
Oracle Database Listener
Oracle Database - Listener

When an database instance starts, it registers itself with a listener using one or more service names. When a client program or database connects to a listener, it requests a connection to a service. ...
Oracle Database Service Registration
Oracle Database - Service Registration

A feature by which the PMON process automatically registers information with a listener. Because this information is registered with the listener, the listener.ora file does not need to be configured with...
Card Puncher Data Processing
Oracle Database - Session Data Unit (SDU) parameter

SDU is a buffer that Oracle Net uses to place data before transmitting it across the network. Oracle Net sends the data in the buffer either when requested or when it is full. Under typical database configuration,...
Oracle Database File Location Variable
Oracle Database - System Identifier (SID)

The System Identifier (SID) identifies a specific database instance. The SID uniquely distinguishes the instance from any other instance on the same computer. Each database instance requires a unique SID...



Share this page:
Follow us:
Task Runner