Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> TNS-01151: Missing listener name

TNS-01151: Missing listener name

From: Manfred Rebentisch <mr_at_comparat.de>
Date: Fri, 21 Sep 2001 13:32:20 +0200
Message-ID: <de8fo9.k93.ln@lxs5.comparat.intra>


Hello,
I did not understand the error TNS-01151. The a76999.pdf (Error Messages) to this point is only bla-bla.

The error:

======================snip====================================
oracle_at_ws15:~ > lsnrctl start
/opt/oracle/product/8.1.7/network/admin/listener.ora

LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 21-SEP-2001 13:14:28

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

Starting /opt/oracle/product/8.1.7/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 8.1.7.0.0 - Production System parameter file is
/opt/oracle/product/8.1.7/network/admin/listener.ora Log messages written to /opt/oracle/product/8.1.7/network/admin/listener.ora TNS-01151: Missing listener name,
/opt/oracle/product/8.1.7/network/admin/listener.ora, in LISTENER.ORA

oracle_at_ws15:~ >

=====================snap====================================

The file listener.ora:

=====================snip====================================
# m3oracle has an entry in /etc/services: "m3oracle 1521/tcp" #
m3oracle =

   (DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ws15)(PORT = 1521))
      )

    )
  )

SID_LIST_m3oracle =
  (SID_LIST =
(SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/8.1.7)
      (PROGRAM = extproc)

    )
(SID_DESC =
      (GLOBAL_DBNAME = m3ora.WS15)
      (ORACLE_HOME = /opt/oracle/product/8.1.7)
      (SID_NAME = m3ora)

    )
  )
=====================snap====================================

The file tnsnames.ora (all of this was automatically generated by the installations process):

=====================snip====================================
# "COMPARAT.INTRA" is the Intranet-Domain of my network
#   I never give this name to the installer. The program
#   has take it automatically.

# "WS15" is the host, on which oracle is installed #
M3ORA.COMPARAT.INTRA =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = ws15)(PORT = 1521))     )
(CONNECT_DATA =

      (SERVICE_NAME = m3ora.WS15)
    )
  )
# The following lines can I delete without a changed result: INST1_HTTP.COMPARAT.INTRA =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = ws15)(PORT = 1521))     )
(CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = m3ora.WS15)
      (PRESENTATION = http://admin)

    )
  )

EXTPROC_CONNECTION_DATA.COMPARAT.INTRA =   (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))     )
(CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )
=====================snap====================================

I would be glad, if somebody can help me. At this point, the database was successfully startet (with /bin/dbstart) and I can use sqlplus and select the system tables, but I cannot connect to the database from another workstation.

Thank you in advance.

-- 
Manfred Rebentisch
COMPARAT GmbH
Received on Fri Sep 21 2001 - 06:32:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US