HELP WITH LISTENER.ORA

From: Rogers <aseaton_at_home.com>
Date: Wed, 05 May 1999 02:41:43 GMT
Message-ID: <HdOX2.714$VK.118877@news2.rdc1.on.home.com>

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

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 - 21:41:43 CDT