Oracle Database Administration: The Essential Refe

listener.ora

The following file will configure a listener for a single database instance (ORAC) using the TCP/IP protocol:

SQLNET.AUTHENTICATION_SERVICES = (NONE)
USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF
LISTENER =
  (ADDRESS_LIST =
          (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= ORAC.world)
         )
          (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= ORAC)
         )
          (ADDRESS =
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = 10.10.1.2)
          (Port = 1526)
         )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORAC.world)
      (SID_NAME = ORAC)
      (ORACLE_HOME = /disk01/oracle/product/7.3.4)
      (PRESPAWN_MAX = 10)
      (PRESPAWN_LIST =
        (PRESPAWN_DESC = (PROTOCOL = TCP) (POOL_SIZE = 10) (TIMEOUT = 0))
      )
    )
  )