Oracle listener cannot be started. "error 3. The specified path cannot be found"

Source: Internet
Author: User
Tags time 0

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.