ORA-12541: TNS no listener

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 This should make your client listen to your database 🙂

3 thoughts on “ORA-12541: TNS no listener

  1. Lucifer

    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
    1. Vivek Bhat Post author

      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 Reply to Lucifer Cancel reply

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

*

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