Re: HELP WITH LISTENER.ORA

There should be a reference to oracle_home in sid_list_listener following sid_desc, (ORACLE_HOME = ....)
Hth,

Sybrand Bakker, Oracle DBA

Rogers wrote in message ...
>Hi,
>
> I know this should be elementry, but I just can't seem to work this
out.
>I am running Oracle Server 7.3.4 on Windows NT. This is a new installation
>and contains one single instance named 'PEG' on a NT server named
>'scmntpega' with one database called 'PEGA'. I have updated the registry
>setting for the SID and created the necessary environment variables. I can
>connect to the instance using all the accounts and all the utilities if I
do
>not specify a service name. My SQL*Net file has an alias called 'PEG'
using
>TCP/IP on host 'scmntpega'. I cannot get the listener service to start, as
>it gives me 'A service cannot start! Windows NT Internal Error - 2014". I
>look at the listner log file and it reveals that my listener.ora file has
>problems. I can't seem to create a proper listener.ora file. Here is my
>error log followed by the contents of my listener.ora file. I would
>appreciate if anyone could offer some insight.
>
>-------------------------
>Contents of listener.log:
>-------------------------
>
>TNSLSNR for 32-bit Windows: Version 2.3.4.0.0 - Production on 04-MAY-99
>20:43:20
>
>Copyright (c) Oracle Corporation 1994. All rights reserved.
>
>System parameter file is E:\Oracle\network\admin\listener.ora
>Log messages written to E:\Oracle\network\log\listener.log
>Trace information written to E:\Oracle\network\trace\listener.trc
>Trace level is currently 0
>
>Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\oracle.worldipc))
>Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\ORCLipc))
>Listening on: (ADDRESS=(PROTOCOL=nmp)(PIPENAME=\\SCMNTPEGA\pipe\ORAPIPE))
>Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=136)(HOST=10.12.5.25)(PORT=1521))
>Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=180)(HOST=127.0.0.1)(PORT=1521))
>Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=204)(HOST=10.12.5.25)(PORT=1526))
>TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
>TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in
LISTENER.ORA
> NL-00305: the specified path name does not exist
>
>
>------------------------------------------------
>Contents of listener.ora:
>------------------------------------------------
>
>
>################
># Filename......: listener.ora
># Node..........: local.world
># Date..........: 24-MAY-94 13:23:20
>################
>LISTENER =
> (ADDRESS_LIST =
> (ADDRESS=
> (PROTOCOL= IPC)
> (KEY= oracle.world)
> )
> (ADDRESS=
> (PROTOCOL= IPC)
> (KEY= ORCL)
> )
> (ADDRESS=
> (COMMUNITY= NMP.world)
> (PROTOCOL= NMP)
> (SERVER= SCMNTPEGA)
> (PIPE= ORAPIPE)
> )
> (ADDRESS=
> (COMMUNITY= TCP.world)
> (Host = scmntpega)
> (PROTOCOL= TCP)
> (Port= 1521)
> )
> (ADDRESS=
> (COMMUNITY= TCP.world)
> (Host = 127.0.0.1)
> (PROTOCOL= TCP)
> (Port= 1521)
> )
> (ADDRESS=
> (COMMUNITY= PEG.world)
> (Host = scmntpega)
> (PROTOCOL= TCP)
> (Port= 1526)
> )
> )
>STARTUP_WAIT_TIME_LISTENER = 0
>CONNECT_TIMEOUT_LISTENER = 10
>TRACE_LEVEL_LISTENER = 0
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID DESC =
> (SID_NAME = PEG)
> )
> )
>PASSWORDS_LISTENER = (oracle)
>
>
>
>-------------------------------------------
>
>Thanks,
>
> Aaron Seaton
>
>
>
Received on Tue May 04 1999 - 23:47:02 CDT