Solution for Oracle listener service failure, oracle listener

Solution for Oracle listener service failure, oracle listener

When the Oracle listener service is not started, take the following measures:

1. Connection host string, prompting no listener

SVRMGR> connect internal/oracle@orcl；ORA-12541: TNS:no listenerSVRMGR>

Ii. Run the listener, Indicating that the protocol-specific component specified for the address is incorrect
In the Start Menu, enter lsnrctl

LSNRCTL for 32-bit Windows: Version 9.0.1.1.1-Production on-2006 14: 31: 53 Copyright (c) 1991,200 1, Oracle Corporation. all rights reserved. welcome to LSNRCTL. Enter "help" for information. LSNRCTL> status

Connect 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 block * TNS-12560: TNS: protocol adapter Error TNS-00506: * may block 32-bit Windows Error: 997: Unknown errorLSNRCTL>

3. Start the service in the control panel, The following error occurs:

Service: The OracleOraHome91TNSListener service cannot be started on the local computer.
Error 3: The specified path cannot be found.

In addition, the executable file path of the OracleOraHome91TNSListener service is empty.

4. Go to the Registry and modify ImagePath.

Run REGEDIT to go to the Registry to HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/OracleOraHome91TNSListener.
If the key value of ImagePath is missing, add it, select the expandable string value, and edit the string value data as: D:/Oracle/Ora90/BIN/TNSLSNR.
Exit the registry.

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

6. Start the listener

LsnrctlLSNRCTL for 32-bit Windows: Version 9.0.1.1.1-Production on-2006 14: 31: 53 Copyright (c) 1991,200 1, Oracle Corporation. all rights reserved. welcome to LSNRCTL. Enter "help" for information. LSNRCTL> startTNS-01106: listeners with the name LISTENER have started LSNRCTL> status being connected to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 64c5c4485765450) PORT = 1521 ))) listener status ---------------------- do not name LISTENER version TNSLSNR for 32-bit Windows: version 9.0.1.1.1-Production start date:-2006 09:04:19 normal running time: 0 days, 5 hours, 30 minutes, 56 seconds tracking level off security offsnmp off listener parameter file D: /oracle/ora90/network/admin/listener. ora listener log file D:/oracle/ora90/network/log/listener. summary of log listening endpoints... (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 Abstract:

The Service "MODOSE" contains one routine.
Routine "hzh", status READY, contains 1 handler of this service...
The Service "PLSExtProc" contains one routine.
Routine "PLSExtProc", status UNKNOWN, contains one handler of this service...
The Service "hzh" contains one routine.
Routine "hzh", status READY, contains three processing programs of this service...
Command executed successfully
LSNRCTL>

7. Connect again. The test is successful.

SVRMGR> connect internal/oracle @ orcl; connection successful. SVRMGR>