1 2 3 Previous Next 30 Replies Latest reply on Nov 29, 2010 10:08 AM by nadhem Go to original post
      • 15. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
        sb92075
        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?
        • 16. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
          EdStevens
          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.
          • 17. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
            705249
            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.
            • 18. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
              sb92075
              rename listener.ora out of the way then

              lsnrctl start
              • 19. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
                705249
                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
                • 20. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
                  sb92075
                  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.
                  • 21. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
                    705249
                    No there is no OS virtualization on this system.
                    What is Loopback Adapter? Why do you want this to be installed?
                    • 22. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
                      sb92075
                      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
                      • 23. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
                        705249
                        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
                        • 24. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
                          sb92075
                          http://download.oracle.com/docs/cd/B28359_01/install.111/b32006/reqs.htm#sthref251
                          • 25. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
                            705249
                            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?
                            • 26. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
                              MsJ
                              Check remote_login_passwordfile init.ora parameter.
                              If it is "exclusive", then u need to create a password file.
                              use the orapwd utility to create it
                              $orapwd file=orapwwtest password=pwd entries=5 force=Y
                              sqlplus /nolog
                              SQL>connect sys as sysdba
                              Enter password: -- enter the pwd
                              Connected.
                              • 27. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12560
                                705249
                                it does not work:
                                SQL> sho parameter remote
                                
                                NAME                                 TYPE        VALUE
                                ------------------------------------ ----------- ------------------------------
                                remote_dependencies_mode             string      TIMESTAMP
                                remote_listener                      string
                                remote_login_passwordfile            string      EXCLUSIVE
                                remote_os_authent                    boolean     FALSE
                                remote_os_roles                      boolean     FALSE
                                result_cache_remote_expiration       integer     0
                                SQL> exit
                                DÚconnectÚ de Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
                                With the Partitioning, OLAP, Data Mining and Real Application Testing options
                                
                                D:\app\EMB\product\11.1.0\db_1\database>orapwd file=orapwubix11 entries=5 force=y password=ubix
                                
                                D:\app\EMB\product\11.1.0\db_1\database>ls
                                SPFILEUBIX11.ORA  hc_orcl.dat       oradba.exe        orapwubix11
                                archive           hc_ubix11.dat     oradim.log
                                
                                D:\app\EMB\product\11.1.0\db_1\database>sqlplus /nolog
                                
                                SQL*Plus: Release 11.1.0.7.0 - Production on Mar. Avr. 6 12:49:47 2010
                                
                                Copyright (c) 1982, 2008, Oracle.  All rights reserved.
                                
                                SQL> conn sys as sysdba
                                Entrez le mot de passe :
                                ERROR:
                                ORA-01031: privilÞges insuffisants
                                • 28. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12
                                  MsJ
                                  solve by using metalink note:ID 435947.1
                                  • 29. Re: Impossible to start a listener: Failed to start service, error 3 TNS-12
                                    705249
                                    I found the cause of the issue.
                                    Actually i had removed the sqlnet.ora file.
                                    Now I created it and I can connecting AS SYSDBA.

                                    Many thanks everybody for your help