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.

SiteGround Black Friday Sale Below Banner

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+

  • rizwan

    i am not able to save changes as said above in sqlnet.ora file. it says : please check if the file is open in another program. i dont know which program is using it.

    moreover, i have tried all steps from 1-5, in all steps(1-4) it shows the following errors :
    For steps 1,3,4:
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error

    For step-2:
    TNS-12560: TNS:protocol adapter error
    TNS-00530: Protocol adapter error

    • If you are using Win-7 then you should login as administrator and if you are logged in with Administrator then follow below steps.
      open notepad as administrator – Just right click on notepad and open it as administrator
      now open your file and make changes as per requirement and save..

  • Ygor

    Work. Listener come back. Thank you so much

  • Vic

    It doesn’t work for me I have oracle 11g in a windows xp x64 in my virtual machine and my host is windows 7

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