Re: listener.ora - what is wrong?

>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)
> )
> )

Change (GLOBAL_DBNAME= zerberus.(none)) line to (GLOBAL_DBNAME= zerberus)

I tried adding .(none) as a domain name for one of our databases and had the same problem..

Hope this helps

--
Cheers

Steve Bright

steve.bright_at_capgemini.co.uk

Martin Boroske wrote in message ...
>
>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 - 06:13:15 CDT