Solution to Oracle Listener Service Failing to Start
- 2021-11-10 11:11:47
- OfStack
When the Oracle listener service is not started, the following measures can be taken to solve it:
1. Connect the host string, prompting that there is no listener
SVRMGR> connect internal/oracle@orcl ;
ORA-12541: TNS:no listener
SVRMGR>
2. Run the listener and prompt the protocol-specific component of the address to be specified incorrectly
Type lsnrctl in Start Menu Run
LSNRCTL for 32-bit Windows: Version 9.0.1.1.1 - Production on 08-6 Month -2006 14:31:53
Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL , type "help" To get information.
LSNRCTL> status
Connect to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=robust) (PORT=1521)))
TNS-01103: Protocol Specific Component Incorrect Specification for Address
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 start service, error 3.
TNS-12536: TNS : May hinder * Make
TNS-12560: TNS Error occurred in protocol adapter
TNS-00506: * Make possible blockage
32-bit Windows Error: 997: Unknown error
LSNRCTL>
3. Start the service in Control Panel with the following error
Service: The OracleOraHome91TNSListener service cannot be started on the local computer.
Error 3: The system cannot find the specified path
And the path to the executable for the OracleOraHome91TNSListener service is empty.
4. Enter the registry to modify ImagePath
Execute REGEDIT at the runtime to enter the registry to HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/OracleOraHome91TNSListener
Found that the key value of ImagePath is missing, add it, select the extensible string value, and edit the numerical data of the string as: D:/Oracle/Ora90/BIN/TNSLSNR
Exit the registry.
5. Start the service again, and the service starts normally
Step 6 Start the listener
lsnrctl
LSNRCTL for 32-bit Windows: Version 9.0.1.1.1 - Production on 08-6 Month -2006 14:31:53
Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL , type "help" To get information.
LSNRCTL> start
TNS-01106: Use name LISTENER The listener of has been started
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=64c5c4485765450)PORT=1521)))
LISTENER Adj. STATUS
------------------------
Don't Name LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 - Production
Start date 08-6 Month -2006 09:04:19
Uptime 0 Days 5 Hours 30 Points 56 Seconds
Trace level off
Security OFF
SNMP OFF
Listener parameter file D:/oracle/ora90/network/admin/listener.ora
Listener log file D:/oracle/ora90/network/log/listener.log
Listening endpoint summary ...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=64c5c4485765450)
(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=64c5c4485765450)(PORT=2484)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=nmp)(PIPENAME=//64C5C4485765450/pipe/ORAPIPE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=//./pipe/1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=//./pipe/EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=8080))(PRESENTATION=http://admin)(SESSION=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=192.168.1.3)(PORT=9090))(PRESENTATION=http://admin)(SESSION=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=2481))(PRESENTATION=GIOP)(SESSION=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=192.168.1.3)(PORT=2482))(PRESENTATION=GIOP)(SESSION=RAW))
Service Summary:
Service "MODOSE" contains 1 routine.
Routine "hzh", state READY, contains 1 handler for this service...
The service "PLSExtProc" contains 1 routine.
Routine "PLSExtProc", state UNKNOWN, contains 1 handler for this service...
Service "hzh" contains 1 routine.
The routine "hzh", state READY, contains three handlers for this service...
Command executed successfully
LSNRCTL
>
7. Connect again and the test is successful
SVRMGR> connect internal/oracle@orcl;
Connection succeeded.
SVRMGR>