This content has been marked as final.
Show 30 replies
-
1. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
MsJ Mar 16, 2010 2:53 PM (in response to 705249)SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSXetProc2)
(ORACLE_HOME = /oracle/ORAHome2)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = TEST)
(ORACLE_HOME = /oracle/ORAHome2)
(SID_NAME = TEST)
)
)
LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
(ADDRESS = (PROTOCOL = TCP)(HOST = <IP or host>)(PORT = 1522))
)
)
C>lsnrctl start LISTENER2 -
2. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
Anil Malkai Mar 16, 2010 2:52 PM (in response to 705249)C:\ora111\BIN>lsnrctl start listener2
instead of this do
C:\ora111\BIN>lsnrctl status
seesms to be environment variable are not set properly
set oracle_home
set path=%oracle_home%\bin;%path%
set tns_admin=%oracle_home%\network\admin
Thenn again try.
it should work
Anil Malkai -
3. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
470572 Mar 16, 2010 2:52 PM (in response to 705249)set your %ORACLE_HOME% and %PATH% before starting Listener
Rachid -
4. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
705249 Mar 16, 2010 3:23 PM (in response to Anil Malkai)It does not work:
C:\ora111\BIN>set oracle ORACLE_HOME=C:\ora111 oracle_sid=ubix11 C:\ora111\BIN>set tns tns_admin=C:\ora111\network\admin C:\ora111\BIN>lsnrctl status listener2 LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 16-MARS -2010 16:13:47 Copyright (c) 1991, 2008, Oracle. All rights reserved. Connexion Ó (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=T0009696.corp.gltrade.com)(PORT=1522))) TNS-12541: TNS : aucun processus d'Úcoute TNS-12560: TNS : erreur d'adaptateur de protocole TNS-00511: Pas de processus d'Úcoute 32-bit Windows Error: 61: Unknown error Connexion Ó (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS : aucun processus d'Úcoute TNS-12560: TNS : erreur d'adaptateur de protocole TNS-00511: Pas de processus d'Úcoute 32-bit Windows Error: 2: No such file or directory
-
5. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
470572 Mar 16, 2010 3:34 PM (in response to 705249)Là c'est normal, tu ne l'as pas encore démarré ;) -
6. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
705249 Mar 16, 2010 3:46 PM (in response to 470572)Salut rachid,
I get the same error whith "lsnrctl start listener2" -
7. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
sb92075 Mar 16, 2010 4:23 PM (in response to 705249)post results from following command
SET -
8. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
705249 Mar 16, 2010 5:12 PM (in response to sb92075)C:\ora111\BIN>set ALLUSERSPROFILE=C:\Documents and Settings\All Users ANT_HOME=U:\eclipse\plugins\org.apache.ant_1.7.0.v200706080842 CLIENTNAME=Console CommonProgramFiles=C:\Program Files\Fichiers communs COMPUTERNAME=T0009696 ComSpec=C:\WINDOWS\system32\cmd.exe ECLIPSE_HOME=C:\Program Files\Eclipse FP_NO_HOST_CHECK=NO HOMEDRIVE=C: JAVA_HOME=U:\JDK JMS_ADAPTER=ActiveMQJMS JMS_SERVERURL=tcp://SRV-JMS:61616 LOGONSERVER=\\SRV-46-CORP1 MSDevDir=C:\msdev\Common\MSDev98 NUMBER_OF_PROCESSORS=2 ORACLE_HOME=C:\ora111 oracle_sid=ubix11 OS=Windows_NT Path=C:\ora111\bin;C:\ora111\bin;C:\ora102\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Prog ram Files\Fichiers communs\Adaptec Shared\System;c:\uti\exew32;c:\Perforce;c:\uti;C:\WINDOWS\system32\WindowsP owerShell\v1.0;C:\Sun\SDK\bin;C:\Program Files\EclipsePATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH ;.PSC1 PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.PSC1 PERL5LIB=C:\ora102\perl\lib\5.8.3\MSWin32-x86;C:\ora102\perl\lib\5.8.3;C:\ora102\perl\5.8.3\lib\MSWin32-x86-mu lti-thread;C:\ora102\perl\site\5.8.3;C:\ora102\perl\site\5.8.3\lib;C:\ora102\sysman\admin\scripts PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 15 Model 75 Stepping 2, AuthenticAMD PROCESSOR_LEVEL=15 PROCESSOR_REVISION=4b02 ProgramFiles=C:\Program Files PROMPT=$P$G PYDEVHOME=C:\Program Files\Eclipse\plugins\org.python.pydev.debug_1.3.13\pysrc SESSIONNAME=Console SystemDrive=C: SystemRoot=C:\WINDOWS tns_admin=C:\ora111\network\admin UBIXDEV_DRIVE=U USERDNSDOMAIN=CORP.GLTRADE.COM USERDOMAIN=CORP USERNAME=EMB UTI=c:\uti Vs6CommonDir=c:\msdev windir=C:\WINDOWS
-
9. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
sb92075 Mar 16, 2010 5:15 PM (in response to 705249)post results from following
ping T0009696.corp.gltrade.com -
10. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
705249 Mar 17, 2010 9:51 AM (in response to sb92075)C:\>ping T0009696.corp.gltrade.com Envoi d'une requête 'ping' sur T0009696.corp.gltrade.com [10.215.18.184] avec 32 octets de données : Réponse de 10.215.18.184 : octets=32 temps<1ms TTL=128 Réponse de 10.215.18.184 : octets=32 temps<1ms TTL=128 Réponse de 10.215.18.184 : octets=32 temps<1ms TTL=128 Réponse de 10.215.18.184 : octets=32 temps<1ms TTL=128 Statistiques Ping pour 10.215.18.184: Paquets : envoyés = 4, reçus = 4, perdus = 0 (perte 0%), Durée approximative des boucles en millisecondes : Minimum = 0ms, Maximum = 0ms, Moyenne = 0ms
-
11. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
Anil Malkai Mar 17, 2010 10:17 AM (in response to 705249)how did you create listener? use netca or how?
i seet EXTPROC1521 is right check..
Anil Malkai -
12. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
705249 Mar 17, 2010 10:32 AM (in response to Anil Malkai)yes merely by using netca: listername = listener2 and port=1522 -
13. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
Anil Malkai Mar 17, 2010 10:35 AM (in response to 705249)can you delete and re-create this listener? using netca itself and update if still same error persist.
note: set all oracle_home and path properly before you invoke netca
Anil Malkai
Edited by: Anil Malkai on Mar 17, 2010 3:34 AM -
14. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
705249 Apr 5, 2010 12:04 AM (in response to Anil Malkai)I uninstalled both 10g and 11g databases.
I installed oracle 11.1.0.7 but the windows service associated to the listener can't start, so i have a database but it's impossible to start a listener.
Can someone help me please? I need a listener on my machine