solution that the Oracle Listener service cannot start _oracle

Source: Internet
Author: User
Tags reserved time 0

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>
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.