1 2 3 Previous Next 30 Replies Latest reply on Nov 29, 2010 10:08 AM by nadhem

Impossible to start a listener: Failed to start service, error 3 TNS-12560

705249 Mar 16, 2010 2:45 PM

Hi all,

I had a database in my machine in 10g.
I have installed oracle 11.1.0.7 on the same machine.

So now i have 2 oracle_home.
With 10g I have a default listener which is running on port 1521.
I wanted to run an other listener under the 11g oracle home.

listener.ora:

# listener.ora Network Configuration File: C:\ora111\network\admin\listener.ora
# Generated by Oracle configuration tools.
 
LISTENER2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = T0009696.corp.gltrade.com)(PORT = 1522))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

C:\ora111\BIN>lsnrctl start listener2 

LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 16-MARS -2010 15:21:19 

Copyright (c) 1991, 2008, Oracle.  All rights reserved. 

Lancement de tnslsnr: Veuillez patienter... 

Failed to start service, error 3.

TNS-12560: TNS : erreur d'adaptateur de protocole

 TNS-00530: Erreur d'adaptateur de protocole

Even if I stop the 10g listener I can't start the 11g listener. I also tried to start a default listener with 11g (name=listener and port=1521) but I get the same error.

Please, can someone explain me the reason of such error ?

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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions

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é ;)
Like Show 0 Likes(0)

Actions
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"
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions

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
Like Show 0 Likes(0)

Actions

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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions

1 2 3 Previous Next

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.