Fixed – ORA-12541: TNS no listener error

Yesterday my friend asked me about this error "ORA-12541 TNS no listener error" while connecting with oracle database. I told him about the below solution and it worked very well.

He suggested me to post this article on TechiesDigest so that this tutorial can help other newbie database administrators too.

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.

This solution worked for my friend and I hope it will also work for you, if not please write on comment section. I will try to provide you the solution at the earliest.

Subscribe to get free tech advice, tips and in-depth articles.


Start Your Dream Website Today & Earn Money Online

To Start a dream website, choose a Domain Name & Reliable Hosting Provider, Self-hosted Blogging Platform, WordPress Theme, Email Marketing and SEO Tool for traffic.

SiteGround Hosting Discount - 60% OFF
ConvertKit The Best Email Marketing Software
Free SEMRush SEM and SEO Tool
Get Your Hosting Package with SiteGround, Increase new email subscribers with ConvertKit and Research Keywords with SEMRush to Boost Organic Traffic.





Leave a Reply

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