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.
ORA-12541 TNS no listener error
Now you have to follow below mentioned steps to resolve the ORA-12541 issue.
Step-1: First check your listener status.
The above command will show the current status of your listener.
Step-2: Start the listener, if listener is not running.
This command will start all your listener services.
Step-3: Stop the listener, if listener is running.
This command will stop all your listener services.
Step-4: Now restart the listener.
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.
LSNRCTL for 32-bit Windows: Version 22.214.171.124.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*
Step-5: One last and very important thing which you have to do.
Open sqlnet.ora file and make the changes as suggested.
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 !!!
Latest posts by Anil Verma (see all)
- BlueHost Affiliate Program – Earn $65 Per Referral - August 2, 2015
- WP Engine Affiliate Program – Earn $200 Per Referral - August 1, 2015
- How to fill out BlueHost Affiliate Tax form for Non-US Residents - June 20, 2015