View Single Post

   
  #1 (permalink)  
Old 02-25-2008, 06:11 AM
nx2zdk@gmail.com
 
Posts: n/a
Default Listener failed to start

$ lsnrctl start MSMMIC

LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 22-JUN-2006
20:25:18

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /export/home/oracle/product/9i/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
System parameter file is
/export/home/oracle/product/9i/network/admin/listener.o
ra
Log messages written to
/export/home/oracle/product/9i/network/log/msmmic.log
TNS-01151: Missing listener name, MSMMIC, in LISTENER.ORA

Listener failed to start. See the error message(s) above...

.................I got above error....

..............I've tried to see in listener.ora.................


SID_LIST_LISTENER_MSMMIC =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = msmmic)
(ORACLE_HOME = /export/home/oracle/product/9i)
(SID_NAME = msmmic)
)
)

LISTENER_MSMMIC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stmossr9)(PORT = 1522))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 43.72.1.107)(PORT = 1522))
)
)

and in tnsname.ora

MSMMIC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = stmossr9)(PORT = 1522))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = msmmic)
)
)


It seems fine....???.... I don't know why I got this kind of error
Any help would be greatly appreciated... Thanks

Reply With Quote