7-step solution to Oracle listener service failure

1. Connection host string, said no listener SVRMGR> connect internal/oracle @ orcl; ORA-12541: TNS: no listener SVRMGR>
2. Run the listener to indicate that the protocol-specific component of the address is incorrectly specified. C:> lsnrctl LSNRCTL for 32-bit Windows: Version 8.1.6.0.0-Production on 14-3 month-2003: 51 (c) copyright 1998,199 9, Oracle Corporation. all rights reserved. welcome to LSNRCTL. Enter "help" for information. LSNRCTL> status connection to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = robust) (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 tnslsnr: Please wait...

Failed to start service, error 3.

TNS-12536: TNS: may hinder *

Error in TNS-12560: TNS: protocol adapter

TNS-00506: * may block 32-bit Windows Error: 997: Unknown error LSNRCTL> 3. Start the service in the control panel with the following Error service: OracleOraHome81TNSListener service cannot be started on the local computer. Error 3: The system cannot find the specified path and the executable file path of OracleOraHome81TNSListener service is empty. 4. Modify ImagePath in the Registry and execute REGEDIT at the runtime to go to the Registry to HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesOracleOraHome81TNSListener to find that the ImagePath key value is missing. Add the ImagePath, select: f: OracleOra81BINTNSLSNR exit the registry.

5. Start the service again. The service starts normally.

6. Start the listener

C:> lsnrctl LSNRCTL for 32-bit Windows: Version 8.1.6.0.0-Production on month 14-3-2003: 10 (c) Copyright 1998,199 9, Oracle Corporation. all rights reserved. welcome to LSNRCTL. Enter "help" for information.

LSNRCTL> start TNS-01106: listeners that use the name LISTENER have started

LSNRCTL> status connection to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = robust) (PORT = 1521 ))) listener status ---------------------- alias LISTENER version TNSLSNR for 32-bit Windows: version 8.1.6.0.0-Produc tion start date: 14-3 months-2003 14:40:15 normal running time 0 days 0 hours 2 minutes 6 seconds tracking level off security off snmp off listener parameter file f: OracleOra81networkadminlistener. ora listener log file f: OracleOra81networkloglistener. log Service summary ..

PLSExtProc has 1 service handler orc2 has 1 service handler orcl has 1 service handler orcl has 2 service handler commands executed successfully LSNRCTL>

7. connect again. SVRMGR> connect internal/sys @ orcl; the connection is successful.