When starting oracle on the local machine today, an error is prompted:
"The oracleorahome92tnslistener service cannot be started on the local computer. Error 3: The specified path cannot be found"
Start the command in cmd:
C:/Documents and Settings/Administrator> LSNRCTL start
LSNRCTL for 32-bit windows: Version 9.2.0.1.0-production on 13-9 month-2007
: 12
Copyright (c) 1991,200 2, Oracle Corporation. All rights reserved.
Start tnslsnr: Please wait...
Failed to start service, error 3.
TNS-12536: TNS: operation may be congested
TNS-12560: TNS: protocol adapter error.
TNS-00506: operation may be congested
32-bit Windows Error: 997: Unknown error
C:/Documents and Settings/Administrator>
System Platform:
OS: Win2000 + SP4
ORACLE: 1, 9.2
Think about what it will do to your computer? This is not the case. Oh, I think of it. I used to use 360 to sort out my computer a few days ago. Maybe
The listening service is broken.
Symptom:
Unable to start the listener, but can be locally logged in SQL * Plus; I can not log in with PL/SQL, prompt "ora-12535: TNS: Operation timeout"
A problem occurs. Do I not need to use a listener for local login?
1. You can directly log on to the local system without the listener. login method:
Single Instance:
SQL> Conn/As sysdba
Multiple instances
A. Set oracle_sid = orcl (the system logs on to the instance specified by oracle_sid by default)
B. SQL> Conn/As sysdba
2. Local login requires the listener login method:
SQL> Conn/@ orcl as sysdba // you only need to use the @ orcl style to listen to the service.
Through the above analysis, you will understand why the listener is not available, but you can log on to the local SQL * Plus, but cannot log on with PL/SQL.
Error message "ora-12535: TNS: Operation timeout"
After careful analysis
Cause of error: 360 clear the ImagePath keyword in the registry. This key value indicates the position of the listener service startup command (tnslsnr. EXE ).
Modification Method: Enter the registry,
HKEY_LOCAL_MACHINE/system/CurrentControlSet/services/oracleorahome92tnslistener to check whether imagepa exists
Th key value. If not, create it. The type is extensible string value. Its value (my machine) is: "D:/Oracle/ora92/bin/tnslsnr. EXE"
Exit and save the registry.
C:/Documents and Settings/Administrator> LSNRCTL start
LSNRCTL for 32-bit windows: Version 9.2.0.1.0-production on 13-9 month-2007
: 27
Copyright (c) 1991,200 2, Oracle Corporation. All rights reserved.
Start tnslsnr: Please wait...
Tnslsnr for 32-bit windows: Version 9.2.0.1.0-Production
The system parameter file is D:/Oracle/ora92/Network/admin/listener. ora.
Log information written to D:/Oracle/ora92/Network/log/listener. Log
Listener :( description = (address = (Protocol = IPC) (pipename = //./pipe/extproc0ipc )))
Listener :( description = (address = (Protocol = TCP) (host = hsf--skate) (Port = 1521 )))
Connecting to (description = (address = (Protocol = IPC) (Key = extproc0 )))
Listener status
------------------------
Alias listener
Version tnslsnr for 32-bit windows: Version 9.2.0.1.0-produc
Tion
Start Date: 13-9-2007 15:29:27
Normal operation time 0 days 0 hours 0 minutes 1 second
Tracking level off
Security off
SNMP off
Listener parameter file D:/Oracle/ora92/Network/admin/listener. ora
Listener log file D:/Oracle/ora92/Network/log/listener. Log
Listener endpoint overview...
(Description = (address = (Protocol = IPC) (pipename = //./pipe/extproc0ipc )))
(Description = (address = (Protocol = TCP) (host = hsf--skate) (Port = 1521 )))
Service summary ..
The Service "plsextproc" contains one routine.
Routine "plsextproc", status unknown, contains one handler of this service...
The Service "orcl" contains one routine.
Routine "orcl", status unknown, contains 1 handler of this service...
Command executed successfully
C:/Documents and Settings/Administrator>
Now everything is OK