Forum Stats

  • 3,735,154 Users
  • 2,247,122 Discussions
  • 7,857,749 Comments

Discussions

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

705249
705249 Member Posts: 149
edited Nov 29, 2010 5:08AM in General Database Discussions
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

Answers

  • MsJ
    MsJ Member Posts: 936
    edited Mar 16, 2010 10:53AM
    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
  • Anil Malkai
    Anil Malkai Member Posts: 603
    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
  • 470572
    470572 Member Posts: 50
    set your %ORACLE_HOME% and %PATH% before starting Listener

    Rachid
  • 705249
    705249 Member Posts: 149
    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
  • 470572
    470572 Member Posts: 50
    Là c'est normal, tu ne l'as pas encore démarré ;)
  • 705249
    705249 Member Posts: 149
    Salut rachid,

    I get the same error whith "lsnrctl start listener2"
  • sb92075
    sb92075 Member Posts: 42,196
    post results from following command


    SET
  • 705249
    705249 Member Posts: 149
    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
  • sb92075
    sb92075 Member Posts: 42,196
    post results from following

    ping T0009696.corp.gltrade.com
  • 705249
    705249 Member Posts: 149
    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
  • Anil Malkai
    Anil Malkai Member Posts: 603
    how did you create listener? use netca or how?
    i seet EXTPROC1521 is right check..

    Anil Malkai
  • 705249
    705249 Member Posts: 149
    yes merely by using netca: listername = listener2 and port=1522
  • Anil Malkai
    Anil Malkai Member Posts: 603
    edited Mar 17, 2010 6:35AM
    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
  • 705249
    705249 Member Posts: 149
    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
  • sb92075
    sb92075 Member Posts: 42,196
    I need a listener on my machine
    You do NOT need a listener to run an Oracle RDBMS.

    My car won't start.
    Tell me how to make my car go.

    Do we get any clues as what might be wrong; like the error code & error message?
  • EdStevens
    EdStevens Member Posts: 28,155 Gold Crown
    Farenheiit wrote:
    I uninstalled both 10g and 11g databases.
    pretty drastic. Kind of like tearing your house down and rebuilding it just because you can't get the telephone to work.
    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
    But you don't need two. One listener, running from one home, listening on one port, can service multiple databases of multiple versions running from multiple homes. Trying to run multiple listeners just introduces unnecessary complications. Run a single listener, default name of listener, out of your highest version oracle home.
  • 705249
    705249 Member Posts: 149
    I have only one version of oracle (11g)
    I try to start the default listener (port 1521 and name=LISTENER) but it can't start because the service OracleOraDb11g_home1TNSListener doesn't want to start.
    D:\app\EMB\product\11.1.0\db_1\BIN>lsnrctl status
    
    LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 05-AVR. -2010 15:14:14
    
    Copyright (c) 1991, 2008, Oracle.  All rights reserved.
    
    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
    Connexion Ó (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=T0009696.corp.gltrade.com)(PORT=1521)
    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
    
    D:\app\EMB\product\11.1.0\db_1\BIN>lsnrctl start
    
    LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 05-AVR. -2010 15:14:22
    
    Copyright (c) 1991, 2008, Oracle.  All rights reserved.
    
    Lancement de tnslsnr: Veuillez patienter...
    
    Failed to start service, error 0.
  • sb92075
    sb92075 Member Posts: 42,196
    rename listener.ora out of the way then

    lsnrctl start
  • 705249
    705249 Member Posts: 149
    I removed the listener.ora file and the sqlnet.ora file and this is what I get:
    D:\app\EMB\product\11.1.0\db_1\BIN>lsnrctl start
    
    LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 05-AVR. -2010 18:59:40
    
    Copyright (c) 1991, 2008, Oracle.  All rights reserved.
    
    Lancement de tnslsnr: Veuillez patienter...
    
    Failed to start service, error 0.
    TNS-12560: TNS : erreur d'adaptateur de protocole
  • sb92075
    sb92075 Member Posts: 42,196
    OS/Networking mis-configured (outside of Oracle)

    Is any type of Operating System Virtualization installed on this system?

    Has Loopback Adapter been successfully installed?
    12560, 00000, "TNS:protocol adapter error"
    // *Cause: A generic protocol adapter error occurred.
    // *Action: Check addresses used for proper protocol specification. Before
    // reporting this error, look at the error stack and check for lower level
    // transport errors. For further details, turn on tracing and reexecute the
    // operation. Turn off tracing when the operation is complete.
  • 705249
    705249 Member Posts: 149
    No there is no OS virtualization on this system.
    What is Loopback Adapter? Why do you want this to be installed?
  • sb92075
    sb92075 Member Posts: 42,196
    What is Loopback Adapter? Why do you want this to be installed?
    It is documented in the Windows Installation Guide; which you obviously have never read.
    Read The Fine Manual to see steps required to configure OS & be able to start Oracle listener successfully
  • 705249
    705249 Member Posts: 149
    I followed the windows installation guide and I installed loopback adapter but I still can't start the default listener:
    Configuration IP de Windows
    
            Nom de l'hôte . . . . . . . . . . : T0009696
            Suffixe DNS principal . . . . . . : corp.gltrade.com
            Type de noud . . . . . . . . . . : Diffusion
            Routage IP activé . . . . . . . . : Non
            Proxy WINS activé . . . . . . . . : Non
            Liste de recherche du suffixe DNS : corp.gltrade.com
                                                pse.gltrade.com
                                                gltrade.com
                                                gltrade.fr
    
    Carte Ethernet Connexion au réseau local:
    
            Suffixe DNS propre à la connexion : corp.gltrade.com
            Description . . . . . . . . . . . : Broadcom NetXtreme 57xx Gigabit Controller
            Adresse physique . . . . . . . . .: 00-1A-A0-2B-22-42
            DHCP activé. . . . . . . . . . . : Oui
            Configuration automatique activée . . . . : Oui
            Adresse IP. . . . . . . . . . . . : 10.215.18.184
            Masque de sous-réseau . . . . . . : 255.255.255.128
            Passerelle par défaut . . . . . . : 10.215.18.254
            Serveur DHCP. . . . . . . . . . . : 10.215.18.252
            Serveurs DNS . . . . . . . . . .  : 172.28.253.182
                                                172.27.253.128
                                                172.27.253.43
            Bail obtenu . . . . . . . . . . . : vendredi 2 avril 2010 09:26:44
            Bail expirant . . . . . . . . . . : mercredi 12 mai 2010 09:26:44
    
    Carte Ethernet Connexion au réseau local 2:
    
            Suffixe DNS propre à la connexion :
            Description . . . . . . . . . . . : Carte de bouclage Microsoft
            Adresse physique . . . . . . . . .: 02-00-4C-4F-4F-50
            DHCP activé. . . . . . . . . . . : Non
            Adresse IP. . . . . . . . . . . . : 10.10.10.10
            Masque de sous-réseau . . . . . . : 255.255.255.0
            Passerelle par défaut . . . . . . :
    
    D:\app\EMB\product\11.1.0\db_1>lsnrctl start
    
    LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 06-AVR. -2010 00:54:07
    
    Copyright (c) 1991, 2008, Oracle.  All rights reserved.
    
    Lancement de tnslsnr: Veuillez patienter...
    
    TNS-12560: TNS : erreur d'adaptateur de protocole
  • sb92075
    sb92075 Member Posts: 42,196
    http://download.oracle.com/docs/cd/B28359_01/install.111/b32006/reqs.htm#sthref251
  • 705249
    705249 Member Posts: 149
    I restarted my machine and now it works well.
    The listener is running.
    However I can't connect to SYS anymore neither using "sqlplus sys/pwd as sysdba" nor "sqlplus / as sysdba". I get an ORA-01031.
    My user account bleongs to ora_dba group and the database has been configured via DBCA. The ORACLE_SID is set.
    Any idea?
This discussion has been closed.