6 Replies Latest reply: Jan 23, 2013 2:20 AM by 986120 RSS

    go error TNS: no :listener

    Vandy_Kh
      Dear All Expert,

      I try to install Oracle Database till step testing confguration, it's shown error message as below:

      Connecting...ORA-12541: TNS:no listener
      The test did not succeed.

      Some of the information you provided may be incorrect.
      Click Back to review the information provided for net service name, or Change Login to change username.


      Please kindly give advice for this.

      Thanks and regards,
      Vandy
        • 1. Re: go error TNS: no :listener
          Niket Kumar
          start the listener

          cmd>lsnrctl status

          cmd>lsnrctl start
          • 2. Re: go error TNS: no :listener
            Vandy_Kh
            Dear Niket,

            Thank you very much for your prompt reply and help.

            Note: My Oracle Database (11g Release 2) is installed on Oracle Linux 5.8

            I have checked with your advice and get result as below:

            [oracle@ovmmger ~]$ lsnrctl status

            LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-JAN-2013 03:36:29

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

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ol5-112.localdomain)(PORT=1521)))
            TNS-12545: Connect failed because target host or object does not exist
            TNS-12560: TNS:protocol adapter error
            TNS-00515: Connect failed because target host or object does not exist
            Linux Error: 111: Connection refused
            [oracle@ovmmger ~]$ lsnrctl start

            LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-JAN-2013 03:36:39

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

            Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

            TNSLSNR for Linux: Version 11.2.0.1.0 - Production
            System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
            Log messages written to /u01/app/oracle/diag/tnslsnr/ovmmger/listener/alert/log.xml
            Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ol5-112.localdomain)(PORT=1521)))
            TNS-12545: Connect failed because target host or object does not exist
            TNS-12560: TNS:protocol adapter error
            TNS-00515: Connect failed because target host or object does not exist
            Linux Error: 111: Connection refused

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

            [oracle@ovmmger ~]$

            Please kindly give advice for this.

            Thanks and regards,
            Vandy
            • 3. Re: go error TNS: no :listener
              kuljeet singh -
              HOST=ol5-112.localdomain
              give ip address inplace of hostname and try to bring listener up.

              if still not work then create new listener by netca.
              • 4. Re: go error TNS: no :listener
                EdStevens
                Vandy_Kh wrote:
                Dear All Expert,

                I try to install Oracle Database till step testing confguration, it's shown error message as below:

                Connecting...ORA-12541: TNS:no listener
                The test did not succeed.
                <snip>
                http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/ (Help! I can’t connect to my database )
                http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/ (Help! I can’t connect to my database (part duex) )
                • 5. Re: go error TNS: no :listener
                  Ankur ...
                  Please post listener.ora and tnsnames.ora entries that will give a correct picture of what is wrong?
                  • 6. Re: go error TNS: no :listener
                    986120
                    export ORACLE_SID=<sid>

                    start listener: lsnrctl start

                    wait for sometimes and start sqlplus