1 2 Previous Next 26 Replies Latest reply: May 8, 2013 10:57 AM by jgarry RSS

    Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)

    1007611
      Hi Guys,

      I am using Oracle XE 11g with Apex 4.2 installed. It was working fine till yesterday. Suddenly today morning I received the ORA-12541: TNS:no listener when tried to open Apex url.
      I had gone through many threads in this forum and tried many suggested workaround but unfortunately nothing worked. So I am completely lost now.
      Here is the various o/p of the issues. I am on Windows 7 x64. Its my own laptop so no host named changed from yesterday.

      Listener file
      ----------------------------------
      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = XE)
      (ORACLE_HOME = F:\Apex_Installed\app\oracle\product\11.2.0\server)
      )
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\Apex_Installed\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
      )
      (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = F:\Apex_Installed\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      )
      )

      DEFAULT_SERVICE_LISTENER = (XE)

      -------------------------------------------------------------------

      TNS Ora file


      XE =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
      )
      )

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )

      ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
      )
      )
      ----------------------------------------------------------------------------
      After running LSNRCTL.exe o/p is below:

      C:\Users\Rocks>lsnrctl.exe

      LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 07-MAY-2013 19:53
      :24

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

      Welcome to LSNRCTL, type "help" for information.

      LSNRCTL> services
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
      TNS-12541: TNS:no listener
      TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
      32-bit Windows Error: 2: No such file or directory
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
      TNS-12541: TNS:no listener
      TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
      32-bit Windows Error: 61: Unknown error
      LSNRCTL> start
      Starting tnslsnr: please wait...

      TNS-12560: TNS:protocol adapter error
      TNS-00530: Protocol adapter error

      LSNRCTL> stop
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
      TNS-12541: TNS:no listener
      TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
      32-bit Windows Error: 2: No such file or directory
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
      TNS-12541: TNS:no listener
      TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
      32-bit Windows Error: 61: Unknown error
      LSNRCTL>

      --------------------------------------------------------------------
      I am able to connect SYSTEM user but when trying to connect XE database its throwing error.

      C:\Users\Rocks>sqlplus /nolog

      SQL*Plus: Release 11.2.0.2.0 Production on Tue May 7 19:39:03 2013

      Copyright (c) 1982, 2010, Oracle. All rights reserved.

      SQL> connect system
      Enter password:
      Connected.
      SQL>
      SQL>
      SQL>
      SQL>
      SQL>
      SQL> alter system register;

      System altered.

      SQL> connect suvendu@xe
      Enter password:
      ERROR:
      ORA-12541: TNS:no listener


      Warning: You are no longer connected to ORACLE.
      SQL> connect admin@xe
      Enter password:
      ERROR:
      ORA-12541: TNS:no listener

      SQL> exit
      -----------------------------------------------------------------
      Here is the o/p of different Environment variable.

      C:\Users\Rocks>set|sort
      ALLUSERSPROFILE=C:\ProgramData
      APPDATA=C:\Users\Rocks\AppData\Roaming
      CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
      CommonProgramFiles=C:\Program Files\Common Files
      CommonProgramW6432=C:\Program Files\Common Files
      COMPUTERNAME=ROCKS-LAPI
      ComSpec=C:\Windows\system32\cmd.exe
      FP_NO_HOST_CHECK=NO
      HOMEDRIVE=C:
      HOMEPATH=\Users\Rocks
      LOCALAPPDATA=C:\Users\Rocks\AppData\Local
      LOGONSERVER=\\ROCKS-LAPI
      NUMBER_OF_PROCESSORS=4
      ORACLE_HOME=F:\Apex_Installed\app\oracle\product\11.2.0\server
      ORACLE_SID=XE
      ORACLE_UNQNAME=XE
      OS=Windows_NT
      Path=F:\Apex_Installed\app\oracle\product\11.2.0\server\bin;F:\Apex_Installed\ap
      p\oracle\product\11.2.0\server\bin;F:\Apex_Installed\app\oracle\product\11.2.0\s
      erver\bin;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS
      Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\Syste
      m32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Co
      mponents\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:
      \Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program
      Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x8
      6)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\
      x64;C:\Program Files (x86)\Hewlett-Packard\HP ProtectTools Security Manager\Bin\

      PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
      PROCESSOR_ARCHITECTURE=AMD64
      PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 42 Stepping 7, GenuineIntel
      PROCESSOR_LEVEL=6
      PROCESSOR_REVISION=2a07
      ProgramData=C:\ProgramData
      ProgramFiles(x86)=C:\Program Files (x86)
      ProgramFiles=C:\Program Files
      ProgramW6432=C:\Program Files
      PROMPT=$P$G
      PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
      PTSMInstallPath_X86=C:\Program Files (x86)\Hewlett-Packard\HP ProtectTools Secur
      ity Manager\
      PUBLIC=C:\Users\Public
      SESSIONNAME=Console
      SystemDrive=C:
      SystemRoot=C:\Windows
      TEMP=C:\Users\Rocks\AppData\Local\Temp
      TMP=C:\Users\Rocks\AppData\Local\Temp
      USERDOMAIN=Rocks-Lapi
      USERNAME=Rocks
      USERPROFILE=C:\Users\Rocks
      windir=C:\Windows
      windows_tracing_flags=3
      windows_tracing_logfile=C:\BVTBin\Tests\installpackage\csilogfile.log

      --------------------------------------------------------------------------------------------------------
      In Windows Services Menu I have only two services.

      OracleJobSchedulerXE
      OracleServiceXE

      No Listener Service ---- hopefully this won't be an issue.
      --------------------------------------------------

      Everything looks fine to me but not sure why its not working. I am working on a project in Apex so cant uninstall the data application right now.
      May I request you to help me please?

      Thanks in advance.

      Regards,
      Suvendu
        • 1. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
          1007611
          Few more o/p of the issues which may help to understand the problem..

          I ran tnsping and got this

          C:\Users\Rocks>tnsping xe

          TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 07-MAY-2
          013 20:16:18

          Copyright (c) 1997, 2010, Oracle. All rights reserved.

          Used parameter files:
          F:\Apex_Installed\app\oracle\product\11.2.0\server\network\admin\sqlnet.ora


          Used TNSNAMES adapter to resolve the alias
          Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.
          1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
          TNS-12541: TNS:no listener

          -----------------------------------------------------

          Listener trace file o/p

          Yesterday:

          06-MAY-2013 09:46:52 * service_update * xe * 0
          Mon May 06 09:47:19 2013
          06-MAY-2013 09:47:19 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=62550)) * handoff * http * 0
          Mon May 06 09:48:57 2013
          06-MAY-2013 09:48:57 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=62562)) * handoff * http * 0
          Mon May 06 09:50:31 2013
          06-MAY-2013 09:50:31 * service_update * xe * 0
          Mon May 06 09:51:46 2013
          06-MAY-2013 09:51:46 * service_update * xe * 0
          Mon May 06 09:55:01 2013
          06-MAY-2013 09:55:01 * service_update * xe * 0
          Mon May 06 09:55:31 2013
          06-MAY-2013 09:55:31 * service_update * xe * 0

          Today:

          Tue May 07 00:11:56 2013
          07-MAY-2013 00:11:56 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=65449)) * handoff * http * 0
          07-MAY-2013 00:12:01 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=65451)) * handoff * http * 0
          07-MAY-2013 00:12:01 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=65450)) * handoff * http * 0
          07-MAY-2013 00:12:03 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=65453)) * handoff * http * 0
          07-MAY-2013 14:09:15 * service_update * xe * 0
          Tue May 07 14:10:33 2013
          07-MAY-2013 14:10:33 * service_update * xe * 0
          Tue May 07 14:19:15 2013
          07-MAY-2013 14:19:15 * service_update * xe * 0
          Tue May 07 14:20:33 2013
          07-MAY-2013 14:20:33 * service_update * xe * 0
          07-MAY-2013 14:20:36 * service_update * xe * 0
          Tue May 07 14:29:15 2013
          07-MAY-2013 14:29:15 * service_update * xe * 0
          • 2. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
            994218
            This issue seems to match with below document.

            Windows 7: TNS Listener Fails to Start or Stop Using Command Line LSNRCTL Utility [ID 1390900.1]

            Thanks,

            Edited by: sonyabarry on May 7, 2013 2:25 PM
            • 3. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
              1007611
              Hi ,

              Thanks. Can I have the complete link....Used the thread id in link but seems mistaking something?

              Regards,
              Suvendu
              • 4. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
                994218
                Friend,

                You have to have an support.oracle.com user name and password for this. then you can get this document.

                Thanks,

                Edited by: sonyabarry on May 7, 2013 2:25 PM
                • 5. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
                  994218
                  Use this.

                  You can turn UAC off from control panel, to disable this feature.
                  Please refer to Microsoft support site for how to disable UAC feature.

                  Then try again.

                  Thanks,

                  Edited by: sonyabarry on May 7, 2013 2:26 PM
                  • 6. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
                    1007611
                    Friend ,

                    Unfortunately I don't have that. Can you please guide me here to resolve the issues. Its very important. Otherwise I will lost all my work.
                    Or if you can send me the doc please if you have ?

                    Thanks,
                    Suvendu
                    • 7. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
                      1007611
                      Friend ,

                      Thanks. I have turned off UAC and fired "lsnrctl start" but got the same error o/p. :(
                      Didn't work.

                      Regards,
                      Suvendu
                      • 8. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
                        1007611
                        Here is another update. Set the TNS_ADMIN bu still getting the error

                        C:\Users\Rocks>set TNS_ADMIN=F:\Apex_Installed\app\oracle\product\11.2.0\server\
                        network\ADMIN

                        so no clue till now to fix. Please help.

                        Regards,
                        Suvendu
                        • 9. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
                          cherrydba
                          paste the output of below commands
                          hostname
                          lsnrctl status
                          lsnrctl services
                          • 10. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
                            1007611
                            Here is the o/p:

                            C:\Users\Rocks>hostname
                            Rocks-Lapi

                            C:\Users\Rocks>lsnrctl status

                            LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 07-MAY-2013 21:05
                            :04

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

                            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                            TNS-12541: TNS:no listener
                            TNS-12560: TNS:protocol adapter error
                            TNS-00511: No listener
                            32-bit Windows Error: 2: No such file or directory
                            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
                            TNS-12541: TNS:no listener
                            TNS-12560: TNS:protocol adapter error
                            TNS-00511: No listener
                            32-bit Windows Error: 61: Unknown error

                            C:\Users\Rocks>lsnrctl services

                            LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 07-MAY-2013 21:05
                            :14

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

                            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                            TNS-12541: TNS:no listener
                            TNS-12560: TNS:protocol adapter error
                            TNS-00511: No listener
                            32-bit Windows Error: 2: No such file or directory
                            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
                            TNS-12541: TNS:no listener
                            TNS-12560: TNS:protocol adapter error
                            TNS-00511: No listener
                            32-bit Windows Error: 61: Unknown error

                            C:\Users\Rocks>


                            Regards,
                            Suvendu
                            • 11. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
                              994218
                              Click on the Microsoft Windows Start button and enter 'cmd' in the "Search programs and files" field. Then click: Ctrl+Shift+Enter

                              Click "Yes". on following screen.

                              You should notice the Command Prompt banner is prefaced with the word "Administrator"

                              Now, try your operations.

                              Thanks,

                              Edited by: sonyabarry on May 7, 2013 2:25 PM
                              • 12. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
                                cherrydba
                                set your oracle home
                                set oracle_home= F:\Apex_Installed\app\oracle\product\11.2.0\server(i hope this is your oracle home)

                                then run the following command and past the o/p
                                lsnrctl start listener
                                lsnrctl status
                                • 13. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
                                  1007611
                                  This is what I am getting as Rocks is the username and its the Administrator.
                                  C:\Users\Rocks>
                                  there is no other user I have created to log in Windows.

                                  Regards,
                                  Suvendu
                                  • 14. Re: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
                                    1007611
                                    Here is the o/p:

                                    C:\Users\Rocks>set oracle_home= F:\Apex_Installed\app\oracle\product\11.2.0\server

                                    C:\Users\Rocks>lsnrctl start listener

                                    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 07-MAY-2013 21:13
                                    :02

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

                                    Message 1070 not found; No message file for product=NETWORK, facility=TNSTNS-125
                                    57: Message 12557 not found; No message file for product=NETWORK, facility=TNS
                                    TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
                                    TNS-00527: Message 527 not found; No message file for product=NETWORK, facility=TNS


                                    C:\Users\Rocks>lsnrctl status

                                    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 07-MAY-2013 21:13
                                    :04

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

                                    Message 1053 not found; No message file for product=NETWORK, facility=TNSTNS-125
                                    57: Message 12557 not found; No message file for product=NETWORK, facility=TNS
                                    TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
                                    TNS-00527: Message 527 not found; No message file for product=NETWORK, facility=TNS

                                    Message 1053 not found; No message file for product=NETWORK, facility=TNSTNS-125
                                    57: Message 12557 not found; No message file for product=NETWORK, facility=TNS
                                    TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
                                    TNS-00527: Message 527 not found; No message file for product=NETWORK, facility=TNS


                                    C:\Users\Rocks>
                                    1 2 Previous Next