listener.ora - what is wrong?

From: Martin Boroske <boroske_at_stud.uni-hannover.de>
Date: 19 Jul 1999 12:36:38 +0200
Message-ID: <lw6r9m553k9.fsf@studserv.stud.uni-hannover.de>

Hello!

I installad Oracle 8.0.5 on a SuSE 6.0 Linux System.

When doing "lsnctrl start", I get the following message:

------listener.log----------

TNSLSNR for Linux: Version 8.0.5.0.0 - Production on 19-JUL-99 10:13:34

(c) Copyright 1997 Oracle Corporation. All rights reserved.

System parameter file is /opt/oracle/product/8.0.5/network/admin/listener.ora Log messages written to /opt/oracle/product/8.0.5/network/log/listener.log

Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=sid0))
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=192.168.1.2)(PORT=1521))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
 NL-00303: syntax error in NV string  

------listener.log----------

So I ask myself, what is wrong with my listener.ora file?

------listener.ora----------

#
# Installation Generated Net8 Configuration
# Version Date: Jun-17-97
# Filename: Listener.ora
#

LISTENER =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= sid0))
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
        (ADDRESS= (PROTOCOL= TCP)(Host= zerberus)(Port= 1521))

  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME= zerberus.(none))
      (ORACLE_HOME= /opt/oracle/product/8.0.5)
      (SID_NAME = sid0)

    )
    (SID_DESC =

      (SID_NAME = extproc)
      (ORACLE_HOME = /opt/oracle/product/8.0.5)
      (PROGRAM = extproc)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
------listener.ora----------

Thanks in advance for your help.

Martin

--

Martin Boroske
Martin.Boroske_at_stud.uni-hannover.de Received on Mon Jul 19 1999 - 05:36:38 CDT