Oracle listener service can not solve the problem starts Author: Unknown Source: network Hits: 2467 Updated: 2005-10-29
Connect from the client to the server, this error occurs, ORA12541-TNS: No listener, start OracleraHome92TNSListener service in the server, display "Unable to start OracleraHome92TnsLisTener service, error 3, and the system cannot be found in the local computer."
Cause: Windows Optimization Master will "optimize the Oracle's listening service"
First, connect the host string, say no listener SVRMGR> Connect INTERNAL / ORACLE @ Orcl; ORA-12541: TNS: No Listenervrmgr>
Second, run the listener, say the address of the protocol special components specify incorrect C: /> LSNRCTLLSNRCTL for 32-Bit Windows: Version 8.1.6.0.0 - Production ON 14- March-2003 14:17:51
(c) CopyRight 1998, 1999, Oracle Corporation. All Rights Reserved.
Welcome to LSNRCTL, type "Help" to get information.
LSNRCTL> Status Connect to (deScription = (Host = Robust)) TNS-01103: The protocol dedicated component of the address specifies incorrect TNS-12541: TNS: no audio TNS -12560: TNS: Agreement adapter error TNS-00511: No listener 32-Bit Windows Error: 61: Unknown Error
LSNRCTL> Start launches TNSLSNR: Please wait ...
Failed to Start Service, Error 3.TNS-12536: TNS: Must be hindered * TNS-12560: TNS: Protocol Adapter Error TNS-00506: * Make Block 32-Bit Windows Error: 997: Unknown Error
Lsnrctl>
Third, start the service in the control panel, the following error service appears: OracleraHome81 TNSListener service cannot be started on the local computer. Error 3: The system cannot find the specified path
And the path to the OracleraHome81 TNSListener service is empty.
Fourth, enter the registry to modify imagePath to execute regedit in runtime to enter the registration table to hkey_local_machine / system / currentControlset / services / oracleraHome81tnslistener found that the keypath key value is not, add him, select the expandable string value, edit the value data of the string : F: / Oracle / ORA81 / BIN / TNSLSNR Exit Registry.
5. Go to the service, the service is normal.
Sixth, start listener C: /> LSNRCTLLSNRCTL for 32-bit windows: Version 8.1.6.0.0 - Production on 14- March-2003 14:42:10 (C) Copyright 1998, 1999, Oracle Corporation. All Rights Reserved Welcome to LSNRCTL, type "Help" to get information. LSNRCTL> StartTns-01106: Lisnrctl> Status using Name Listener is connected to (Description = (Protocol = TCP)) (port = 1021))) Listener's Status ----- ------------------- Alias Listener version TNSLSNR for 32-bit windows: Version 8.1.6.0.0 - Production Start Date 14- March -2003 14:40:15 Normal Operation Time 0 Day 2:66 Track Level OFF Security OffsNMP Off Listener Parameter File F: /oracle/ora81/neetwork/admin/Listener.ora Listening Log File F: / Oracle / ORA81 / Network / LOG /Listener.log service summary ..plsextproc has 1 service handler ORC2 has 1 service handler orcl 具有 has 2 service handler ORCLs have 2 service handler commands perform success lsnrctl> seven, then connect, success SVRMGR> Connect Internal / Sys @ Orcl; connection is successful. SVRMGR>