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>

Related articles: