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+

  • Graham

    Thanks a lott man! Love you!

  • Haja Mohideen

    Hi Anil Kumar,
    I am facing ERROR: ORA-12541: TNS:no listener, and i followed the step as you mentioned above, but i am not able to fix it above issue and i think this issue is coming because of some different problem that is Previously i tried to take expdp at the time i faced following error,

    C:\Documents and Settings\user>expdp HAJA/HAJA@DBA01 FULL=y DIRECTORY=DBA01_EXP
    DB DUMPFILE=full.dmp LOGFILE=myfullexp.log JOB_NAME=myfullJob

    Export: Release 11.2.0.1.0 – Production on Thu Aug 28 12:44:33 2014

    Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

    UDE-12541: operation generated ORACLE error 12541
    ORA-12541: TNS:no listener

    Please help me.

  • shiva

    i installed oracle 10g and i try to connect i got thAt error and i tried tat command in command prompt for starting listner but it dnt worked what should i do now? any other way to resolve the issue

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