Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> TNS-01151: Missing listener name
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
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" #
(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)
(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.
(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 GmbHReceived on Fri Sep 21 2001 - 06:32:20 CDT