2 Replies Latest reply: Dec 27, 2012 6:54 AM by EdStevens RSS

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

    user8643895
      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
          http://install-climber.blogspot.in/2012/04/howtocreatestartlistneroracle11gr2.html
          • 2. Re: TNS-01151: Missing listener name, KMSDB, in LISTENER.ORA
            EdStevens
            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