When the Oracle Listener service does not start, the following measures can be taken to resolve:
A, connect the host string, prompt no listener
Svrmgr> connect INTERNAL/ORACLE@ORCL;
Ora-12541:tns:no listener
svrmgr>
second, run the listener , the protocol-specific component of the prompt address specified incorrectly
Type Lsnrctl in the Start menu run
Lsnrctl for 32-bit windows:version 9.0.1.1.1-production on August-June -2006 14:31:53
Copyright (c) 1991, 2001, Oracle Co Rporation. All rights reserved.
Welcome to LSNRCTL, please type "help" for information.
lsnrctl> Status
Connect to (description= (address= (protocol=tcp) (Host=robust) (port=1521))
TNS-01103: The protocol-specific component of the address specified incorrectly
Tns-12541:tns: No Listener
TNS-12560:TNS: Protocol Adapter error occurred
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 * for
TNS-12560:TNS: Protocol Adapter Error
TNS-00506: * Make possible block
32-bit Windows error:997:unknown Error
lsnrctl>
third, starting the service in Control Panel , the following error occurred
Service: The Oracleorahome91tnslistener service cannot be started on the local computer.
Error 3: The system could not find the specified path
and the path to the executable file for the Oracleorahome91tnslistener service is empty.
Four, enter the registry to modify ImagePath
Execute regedit into the registry at run place to Hkey_local_machine/system/currentcontrolset/services/oracleorahome91tnslistener
Found ImagePath key value No, add him, select an expandable string value, edit the string's numeric data as: D:/oracle/ora90/bin/tnslsnr
Exits the registration form.
Five, start the service again, service start normal
Six, start the listener
Lsnrctl lsnrctl for 32-bit windows:version 9.0.1.1.1-production on August-June -2006 14:31:53 Copyright (c) 1991, 2001, Orac Le Corporation.
All rights reserved.
Welcome to LSNRCTL, please type "help" for information. lsnrctl> start TNS-01106: Listener with Name Listener has started lsnrctl> status is connected to (description= (address=) (protocol=tcp 64c5c4485765450) port=1521)) LISTENER STATUS------------------------alias LISTENER version Tnslsnr for 3 2-bit windows:version 9.0.1.1.1-production Start date August-June-2006 09:04:19 Normal running time 0 days 5 hours 30 minutes 56 seconds tracking level Off security off SNMP off listener parameter file D:/oracle/ora90/network/admin/listener.ora listener log file d:/oracle/or
A90/network/log/listener.log Listener 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)) (Address= (PROTOCOL=IPC) (description=) (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:
The service "Modose" contains 1 routines.
Routine "Hzh", State READY, contains 1 handlers for this service ...
The service "Plsextproc" contains 1 routines.
Routine "Plsextproc", State UNKNOWN, contains 1 handlers for this service ...
The service "Hzh" contains 1 routines.
Routine "Hzh", State READY, contains 3 handlers for this service ...
Command execution succeeded
Lsnrctl>
Seven, again to connect, test success
Svrmgr> Connect INTERNAL/ORACLE@ORCL;
The connection was successful.
svrmgr>