Resolved ORA-12541: TNS no listener error

N no. of articles you will find on the internet about “ORA-12541 TNS no listener error” but still finding an effective solution. Don’t worry this solution helped me a lot and I hope it will help you too.

I got the same issue while working on Oracle 10g database then I decided to share my experience and steps to resolve this issue.

Error Message:

ORA-12541 TNS no listener error

Resolution:

Now you have to follow below mentioned steps to resolve the ORA-12541 issue.

Step-1: First check your listener status.

C:\>lsnrctl status

The above command will show the current status of your listener.

Step-2: Start the listener, if listener is not running.

C:\>lsnrctl start

This command will start all your listener services.


Step-3: Stop the listener, if listener is running.

C:\>lsnrctl stop

This command will stop all your listener services.

Step-4: Now restart the listener.

C:\>lsnrctl reload

This command will restart all your listener services.

Note: If you want to see all the available listener commands. Type lsnrtcl help on command prompt and you will get all available options.

C:\>lsnrctl help

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 – Production on 02-JUL-2015 20:25:14

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

The following operations are available
An asterisk (*) denotes a modifier or extended command:

start                           stop                status
services                     version           reload
save_config              trace               change_password
quit                            exit                  set*
show*

Step-5: One last and very important thing which you have to do.

Open sqlnet.ora file and make the changes as suggested.

ora-12541-error

Change NTS to NONE

SQLNET.AUTHENTICATION_SERVICES = (NONE)

Now restart the listener services and your listener problem ORA-12541 will be resolved.

If this is not working, do write in comment section. I will try to help you at the earliest.



Get Free Blogging Tips & Technology updates in your Email !!!

Subscribe via RSS feed

The following two tabs change content below.
Anil Kumar
IT Blogger Tips focus on Blogging Tips, SEO Tips, Social Media, SQL Tips, PL/SQL Tips, Oracle DBA, Linux/Unix, Latest Technology, How Tos and Technical Solutions. You can find us on Facebook | Twitter |
Find on Google+

  • Kajal Banga

    Hi
    I tried out the above given solution but the listener is still not getting up and also i am not able to edit the sqlnet.ora file

    • Hi Kajal,

      As you have not specified your OS but I hope your are
      using Win-7 and above. Now in this case you must login as administrator
      and if you are logged in as Administrator then follow below steps.
      Open
      notepad as administrator – Search Notepad and right click on notepad
      and open it as administrator. Now open your file and make changes as per
      requirement and save..

  • Hi Kajal,

    As you have not specified your OS but I hope your are using Win-7 and above. Now in this case you must login as administrator and if you are logged in as Administrator then follow below steps.
    Open notepad as administrator – Search Notepad and right click on notepad and open it as administrator. Now open your file and make changes as per requirement and save..

  • Mohd Aman

    Hii
    How may i find sqlnet.ora file in my computer..

    • shahbaz khursheed

      If you have installed it on windows machine path would be something like
      C:appv-shkhurproduct11.2.0dbhome_1NETWORKADMIN
      in your case drive would be ‘C,D,E’

Siteground SALE
60% OFF SiteGround WordPress Hosting – $3.95/month (Exclusive Offer !!!)