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.
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.
Thanks for the tips! We have two client machines connecting to the same VM with an Oracle database. The one machine’s TNSPING is successful. The second machine can TNSPING 3 times and then we receive No Listener error. We introduced the TNS entry to another machine and did a TNSPING successfully… What could be wrong with the second machine?
Does this is applicable for OpenVMS platform as well?
i had installed two machines in vmware and i mentioned same ip address two both of them..when i am trying to connect listener by using ‘tnsping’ it showing “tns-12541: no listener”…
can someone help me…
hello guys i am dba
guys just check your ip please
1)firstly check that ip and hostname are ping correctly.
2)reload lsnrctl file also by lsnrctl reload and lsnrctl status.
3)now make sure instance is connected and running by command
select name,open_mode from v$database;
4)now check tnsnames by tnsping (dbname) if it show OK then it works.
if still issue continue please make new files by NETCA
dont use “SQLNET.AUTHENTICATION_SERVICES = (NONE)”
this is for authentication purpose only as it ask for password when connect with sql.
Hello Sir, I have installed Oracle DB-11G R2 (Windows 64) bit and also installed Oracle Client. I am able to connect to Database using Sqlplus, but unable to connect through SQL Developer, Toad etc. While connecting I get error : “TNS: No listener available”. I tried to start the listener by LSNRCTL > start and got similar error. While doing TNSPING ORCL I’m getting the same error. Can you share one sample listener & TNSName file so that I can verify if file available at my end is correct or not. Thanks
Hello Sir, I am new in ORACLE. I have a Issue in Oracle I have made two database one for Demo and one for Dev for other mount point. When I connect with Demo this can be connected but when I try to connect with DEV its not able connect. I have given to add the listner details as given below but when I am tnsping with DEV its giving TNS 12541 error. I try to find out but not able to connect.Below are the details, Please help
[oracle@CVM-1429 ~]$ sqlplus sys/sys as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sat Oct 8 18:11:55 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name from v$database;
NAME
———
CSMEC
SQL>
[oracle@CVM-1429 ~]$ ps -ef|grep pmon
oracle 1286 1 0 Oct07 ? 00:00:10 ora_pmon_CSDEV
oracle 17032 1 0 Sep27 ? 00:01:40 ora_pmon_CSMEC
oracle 30817 30328 0 18:12 pts/2 00:00:00 grep pmon
[oracle@CVM-1429 ~]$
[oracle@CVM-1429 admin]$ pwd
/u03/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin
[oracle@CVM-1429 admin]$ more listener.ora
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=10.56.184.32)(PORT=1525))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))
))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=CSMEC)
(ORACLE_HOME=/u03/oracle/app/oracle/product/12.1.0/dbhome_1/)
(SID_NAME=CSMEC))
))
LISTENER1=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=10.56.184.32)(PORT=1530))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))
))
SID_LIST_LISTENER1=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=CSDEV)
(ORACLE_HOME=/u03/ORCDEV/oracle/app/oracle/product/12.1.0/dbhome_1/)
(SID_NAME=CSDEV))
))
[oracle@CVM-1429 admin]$
[oracle@CVM-1429 admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /u03/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
CSMEC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.56.184.32)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CSMEC)
)
)
CSDEV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.56.184.32)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CSDEV)
)
)
[oracle@CVM-1429 admin]$
[oracle@CVM-1429 admin]$ tnsping CSDEV
TNS Ping Utility for Linux: Version 12.1.0.2.0 – Production on 08-OCT-2016 18:20:18
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.56.184.32)(PORT = 1530)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CSDEV)))
TNS-12541: TNS:no listener
[oracle@CVM-1429 admin]$
in sqlnet.ora
# sqlnet.ora Network Configuration File: E:oracleASHRAFJAMALproduct11.1.0db_1networkadminsqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install “Software Only”, this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES = (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
but same network adaptor error……………
i have copleted all 5 step as u said but again same error network adaptor……………
plz resolve problem
Change NTS to NONE
SQLNET.AUTHENTICATION_SERVICES = (NONE)
i have changed but again error (no listener) i m using 11 g enterprise
I am getting the same error while try to ping db from windows machine, I have make the changes as per your suggestion but still getting the same error. please note listener is up on my Linux machine
I was trying to resolve this issue from many days……but now it’s get resolved.
Thank you very much
Hii
How may i find sqlnet.ora file in my computer..
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’
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
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..
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
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.
Thanks a lott man! Love you!
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
Work. Listener come back. Thank you so much
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..