4 Replies Latest reply: Feb 17, 2013 12:07 PM by EdStevens RSS

    Listener issue

    Naseer CHVT
      Hi,

      I am using oracle 11g database on linux. I can start the database ACTVDG. but when i trying to start $lsnrctl start ACTVDG, then it showing error message like this.

      " TNS-01151: Missing listener name, ACTVDG, in LISTENER.ORA
      Listener failed to start. See the error message(s) above... "

      But when I start
      $lsnrctl start listener is working. And i could not access dbconsole from windows 7 os.

      Please reply in this regards.
      with thanks Nas
        • 1. Re: Listener issue
          Osama_Mustafa
          Error: TNS 1151
          Text: Missing listener name, %s, in LISTENER.ORA
          -------------------------------------------------------------------------------
          Cause: The listener could not find the listener name specified.
          Action: Make sure valid addresses on which to listen are specified for the listener name in LISTENER.ORA.
          • 2. Re: Listener issue
            Naseer CHVT
            Hi,

            Thanks for the reply.
            could you please specify how to check listener?
            ----------------------------------------------------------------------
            i could find listener.ora "$ORACLE_HOME/network/admin" folder.
            The entries are

            "LISTENER =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = orares1.customs.gov.qa)(PORT = 1521))
            )
            )

            ADR_BASE_LISTENER = /u01/app/oracle"

            And i tried to edit this like
            "LISTENER =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = orares1.customs.gov.qa)(PORT = 1521))
            )
            )

            SID_LIST_LISTENER=
            (SID_LIST=
            (SID_DESC=
            (GLOBAL_DBNAME=ACTVDG.orares1.customs.gov.qa)
            (ORACLE_HOME=/oracle11g)
            (SID_NAME=ACTVDG)))

            ADR_BASE_LISTENER = /u01/app/oracle"

            but still error.
            • 3. Re: Listener issue
              Osama_Mustafa
              First why you need to create another listener , You listener name is LISTENER , if you need to change it Use netca GUI it will be easy just follow the screen otherwise no need to create 2 listener for the same database .
              • 4. Re: Listener issue
                EdStevens
                Naseer CHVT wrote:
                Hi,

                I am using oracle 11g database on linux. I can start the database ACTVDG. but when i trying to start $lsnrctl start ACTVDG, then it showing error message like this.

                " TNS-01151: Missing listener name, ACTVDG, in LISTENER.ORA
                Listener failed to start. See the error message(s) above... "

                But when I start
                $lsnrctl start listener is working. And i could not access dbconsole from windows 7 os.

                Please reply in this regards.
                with thanks Nas
                You seem to have a severe mis-understandng of the relationship between the listener and the database.

                read: [url http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/] Help! I can’t connect to my database
                read: [url http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/] Help! I can’t connect to my database (part duex)