This discussion is archived
2 Replies Latest reply: Dec 27, 2012 4:54 AM by EdStevens RSS

TNS-01151: Missing listener name, KMSDB, in LISTENER.ORA

user8643895 Newbie
Currently Being Moderated
I am getting following error when i start the oracle database lisner

this is how i start the database listner

+[ora112@localhost admin]$ echo $ORACLE_SID+
JIPDB
+[ora112@localhost admin]$ lsnrctl start JIPDB+

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 27-DEC-2012 02:09:29

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Starting /opt/oracle/11.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /opt/oracle/11.2.0/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/localhost/kmsdb/alert/log.xml
TNS-01151: Missing listener name, JIPDB, in LISTENER.ORA

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

+[ora112@localhost admin]$+

But i have configured lisner JIPDB in listner.ora file, this is how i have configured it


LISTENER_JIPDB =
+(DESCRIPTION_LIST =+
+(DESCRIPTION =+
+(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1531))+
+)+
+)+

please help me to understand, why i am getting this error message

Edited by: user8643895 on Dec 27, 2012 1:16 AM

Edited by: user8643895 on Dec 27, 2012 1:17 AM

Edited by: user8643895 on Dec 27, 2012 1:18 AM
  • 1. Re: TNS-01151: Missing listener name, KMSDB, in LISTENER.ORA
    Niket Kumar Pro
    Currently Being Moderated
    http://install-climber.blogspot.in/2012/04/howtocreatestartlistneroracle11gr2.html
  • 2. Re: TNS-01151: Missing listener name, KMSDB, in LISTENER.ORA
    EdStevens Guru
    Currently Being Moderated
    user8643895 wrote:
    I am getting following error when i start the oracle database lisner

    this is how i start the database listner

    +[ora112@localhost admin]$ echo $ORACLE_SID+
    JIPDB
    +[ora112@localhost admin]$ lsnrctl start JIPDB+
    There is no relationship between the listener and ORACLE_SID. The current value of ORACLE_SID has zero bearing on the listener.

    Further, one single listener, using the default name of LISTENER and the default port of 1521 is quite capable of - WAS DESIGNED TO - service multiple database instances of multiple versions running from multiple homes. Even implying that there is some sort of one-to-one relationship between listener and database instance (by naming the listener the same as the database) really makes as much sense as the telephone company identifying a particular switchboard by the name of one particular customer. As you have discovered, it only complicates matters.

    Do the following:
    cd $ORACLE_HOME/network/admin
    mv listener.ora listener.sav
    lsnrctl stop
    lsnrctl start
    LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 27-DEC-2012 02:09:29

    Copyright (c) 1991, 2011, Oracle.  All rights reserved.

    Starting /opt/oracle/11.2.0/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 11.2.0.3.0 - Production
    System parameter file is /opt/oracle/11.2.0/network/admin/listener.ora
    Log messages written to /opt/oracle/diag/tnslsnr/localhost/kmsdb/alert/log.xml
    TNS-01151: Missing listener name, JIPDB, in LISTENER.ORA

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

    +[ora112@localhost admin]$+

    But i have configured lisner JIPDB in listner.ora file, this is how i have configured it


    LISTENER_JIPDB =
    +(DESCRIPTION_LIST =+
    +(DESCRIPTION =+
    +(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1531))+
    +)+
    +)+

    please help me to understand, why i am getting this error message

    Edited by: user8643895 on Dec 27, 2012 1:16 AM

    Edited by: user8643895 on Dec 27, 2012 1:17 AM

    Edited by: user8643895 on Dec 27, 2012 1:18 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points