ORA-12541: TNS: no listeners

ORA-12541: TNS: no listeners
Solution:

1. Connection host string, no listener reported
C: \ Documents ents and Settings \ u120594> connect username/password @ orcl;
ORA-12541: TNS: no listener
C: \ Documents ents and Settings \ u120594>



Ii. Run the listener

C: \ Documents ents and Settings \ u120594> lsnrctl

LSNRCTL for 32-bit Windows: Version 9.2.0.1.0-Production on-2009
: 08

Copyright (c) 1991,200 2, Oracle Corporation. All rights reserved.

Welcome to LSNRCTL. Enter "help" for information.

3. Provide a solution by checking the listener status

Case 1: Only Report No listener

LSNRCTL> status
Connecting to (ADDRESS = (PROTOCOL = tcp) (PORT = 1521 ))
TNS-12541: TNS: No listener
TNS-12560: TNS: protocol adapter error.
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error


LSNRCTL> start
Start tnslsnr: Please wait...

Failed to open service <OracleOraHome92TNSListener>, error 1060.
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0-Production
Log information written to D: \ oracle \ ora92 \ network \ log \ listener. log
Listener :( DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = sha120594n02. clients. apac. cpwr. c
Orp) (PORT = 1521 )))

Connecting to (ADDRESS = (PROTOCOL = tcp) (PORT = 1521 ))
LISTENER STATUS
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0-Produc
Tion
Start Date:-2009 10:08:49
Normal operation time 0 days 0 hours 0 minutes 4 seconds
Tracking level off
Security OFF
SNMP OFF
Listener log file D: \ oracle \ ora92 \ network \ log \ listener. log
Listener endpoint overview...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = sha120594n02. clients. apac. cpwr. corp)
(PORT = 1521 )))
Listener does not support services
Command executed successfully

Scenario 2: In addition to reporting no listener, the protocol-specific component specified by the reported address is incorrect.

LSNRCTL> status
Connect to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (PORT = 1521 )))
TNS-01103: the Protocol-specific component specified for the address is incorrect
TNS-12541: TNS: No listener
Error in TNS-12560: TNS: protocol adapter
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error


LSNRCTL> start
Start tnslsnr: Please wait...
Failed to start service, error 3.
TNS-12536: TNS: may hinder *
Error in TNS-12560: TNS: protocol adapter
TNS-00506: * possible blocking
32-bit Windows Error: 997: Unknown error
LSNRCTL>

The solution is as follows:
1. When you start the service on the control panel, the following error occurs:
Service: The OracleOraHome92TNSListener service cannot be started on the local computer.
Error 3: The specified path cannot be found.
In addition, the executable file path of the OracleOraHome92TNSListener service is empty.

2. Go to the Registry and modify ImagePath.
Run REGEDIT to go to the Registry to HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ OracleOraHome92TNSListener.
If you find that the key value of ImagePath is missing, add it, select the expandable string value, and edit the string value data as: D: \ oracle \ ora92 \ BIN \ TNSLSNR to exit the registry.

3. Start the listener again
LSNRCTL> start
TNS-01106: listeners that use the name LISTENER have started

4. Check the listener status and the listener has recovered to normal.
LSNRCTL> status
Connecting to (ADDRESS = (PROTOCOL = tcp) (PORT = 1521 ))
LISTENER STATUS
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0-Produc
Tion
Start Date:-2009 10:08:49
Normal operation time 0 days 0 hours 2 minutes 18 seconds
Tracking level off
Security OFF
SNMP OFF
Listener log file D: \ oracle \ ora92 \ network \ log \ listener. log
Listener endpoint overview...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = sha120594n02. clients. apac. cpwr. corp)
(PORT = 1521 )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = sha120594n02. clients. apac. cpwr. corp)
(PORT = 8080) (Presentation = HTTP) (Session = RAW ))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = sha120594n02. clients. apac. cpwr. corp)
(PORT = 2100) (Presentation = FTP) (Session = RAW ))
Service summary ..
The Service "Covisint" contains one routine.
Routine "Covisint", status READY, contains 1 handler of this service...
The Service "CovisintXDB" contains one routine.
Routine "Covisint", status READY, contains 1 handler of this service...
Command executed successfully


5. Connect again. Successful
C: \ Documents ents and Settings \ u120594> connect username/password @ orcl;
Connection successful.
C: \ Documents ents and Settings \ u120594>