• Home
• 

• Products
• DbaBar

• Oracle administration made easy

• OraSpy

• Simple Oracle monitoring

• Oracle Locator Express

• The Oracle Home Selector Replacement

• Oracle Password Changer

• Change (expired) passwords

• Oracle Listener Remover

• Remove obsolete Listeners on Windows

• Actions
• Download

• Download Free Products and Trials

• Buy Licenses

• Buy an official license

• Support

• Get support for our products

• Oracle Error Codes

• Oracle Error Messages Explained

• DbMotive
• About Us

• Everything you want to know about us

• News

• Jan 27th: New Oracle Locator Express Release

• Sitemap

• Browse our website

 ORA-12541: TNS:no listener

Make sure a listener is running. Either use lsnrctl to start the listener or startup the appropriate Windows service.

If the listener is running correctly, make sure that the connect information provided (hostname, portnumber) matches with the information in the listener.ora file or the local_listener database parameter.

If you do not know the host and port information of a given connection string, you can use the tnsping command line tool to get this information:


C:>tnsping ORA920

TNS Ping Utility for 32-bit Windows: Version 9.2.0.7.0 - Production

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
c:oracleora920networkadminsqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = DEV01)(PORT =
 2491))) (CONNECT_DATA = (SERVICE_NAME = ORA920.EU.DBMOTIVE.COM) (SERVER = DEDICATED)))
OK (200 msec)


Using the host (DEV01) and port (2491) information, goto the server identified by HOST.
Open a shell or command prompt, and check if there is a process listening on the port identified by PORT.


c:>netstat -a
...
 TCP    DEV01:2491    DEV01.eu.dbmotive.com:0  LISTENING
...