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.

23 thoughts on “Resolved ORA-12541: TNS no listener error”

  1. Zayne du Bery

    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?

  2. Gowthami

    Does this is applicable for OpenVMS platform as well?

  3. uday kumar

    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…

  4. anand gupta

    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.

  5. Amit Chaudhary

    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

  6. Suhail Rashid

    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]$

  7. ASHRAF JAMAL

    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……………

  8. ASHRAF JAMAL

    i have copleted all 5 step as u said but again same error network adaptor……………

    plz resolve problem

  9. ASHRAF JAMAL

    Change NTS to NONE

    SQLNET.AUTHENTICATION_SERVICES = (NONE)

    i have changed but again error (no listener) i m using 11 g enterprise

  10. shahbaz khursheed

    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

  11. milind chopde

    I was trying to resolve this issue from many days……but now it’s get resolved.
    Thank you very much

  12. Mohd Aman

    Hii
    How may i find sqlnet.ora file in my computer..

    1. shahbaz khursheed

      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’

  13. 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..

  14. Kajal Banga

    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

    1. 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..

  15. 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

  16. 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.

  17. 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

  18. Ygor

    Work. Listener come back. Thank you so much

  19. 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

    1. 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..

Leave a Comment

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

Scroll to Top
Scroll to Top