ORA-12541: TNS no listener

Posted under Technical on August 12th, 2011 by
So you have bumped on this error. You have started your database, you have started your listeners… successfully, but still the client is adamant that there is are “no listeners”.

All the website will ask you politely, just to “start your listeners”(lsnrctl start). You can ping the host machine but tnsping gives error. tnsnames.ora, listener.ora and sqlnet.ora are as perfect as they can get… but still “ORA-12541: TNS: no listener”. There is one precaution you need to do. The sequence of starting your database should be:
  • Start the database
  • And then start the listeners
Because listeners register with the database you have started. If you have not started the database, or started listeners before starting the database… listeners do not know which database to register with.

Hold on, you do not need to shutdown your database. If you have already started the database and then the listeners, then go to sqlplus and issue the command 
 ALTER SYSTEM REGISTER
This should make your client listen to your database 🙂
Tags: , , ,
  1. Rajivdh left a comment on March 16, 2012 at 3:13 PM

    Alert!: Oracle has announced their marquee event JavaOne and Oracle Develop 2012 being held in Hyderabad on 3-4 May. Registrations have also started (Link: http://www.oracle.com/javaone/in-en/index.html?pcode=WWMK11024795MPP084&src=7268797&Act=155 ).

    Reply
  2. Lucifer left a comment on January 10, 2013 at 8:29 PM

    Hi Vivek,

    I did as you suggested but it is not working for me.

    Are you online now?

    Can you help me?

    Best Regards,
    Vikram

    Reply
    • Vivek Bhat left a comment on January 12, 2013 at 12:30 PM

      Hey Vikram, I hope you have solved your problem. I am travelling for few days and would not be able to be online. If you are getting the same oracle error try other solutions there on the net. There are a lot of reasons why we get no tns error.

      Reply

Leave a Comment

Your email address will not be published. Required fields are marked *

CAPTCHA

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.

©2024 By Vivek Bhat.