14 Replies Latest reply: Nov 15, 2012 8:23 AM by joelkallman-Oracle RSS

    Application Express Stopped working.

    Krunal
      Hi,
      I recently installed apex 4.2 (Fresh installation) . It was working fine for few days. but suddently it stopped working, and I am getting Unable to connect error.

      OS : win 7
      Oracle : 11g (64 bit)

      Listener : started.

      users and account status
      APEX_PUBLIC_USER OPEN
      ANONYMOUS OPEN
      XDB OPEN
      FLOWS_FILES EXPIRED
      APEX_040200 EXPIRED
      APEX_030200 EXPIRED & LOCKED

      when it was working. at that time also the status was same.
      Can anyone guide me what could be the problem.
        • 1. Re: Application Express Stopped working.
          Mehabub Sheikh
          Please provide the information about the web tier details - OHS, EPG or APEX Listner?

          Thanks,
          Mehabub
          • 2. Re: Application Express Stopped working.
            Krunal
            Thanks for your reply.
            Its EPG.
            • 3. Re: Application Express Stopped working.
              Mehabub Sheikh
              Are able to connect to your database from SQL*Plus?
              Do you have any other applications running on 8080 port?

              Thanks,
              Mehabub
              • 4. Re: Application Express Stopped working.
                Krunal
                Yes i am able to connect to my DB using scott/tiger@local.
                No there is no application on 7777(I chaged the port to 7777 at the time of installation).
                • 5. Re: Application Express Stopped working.
                  joelkallman-Oracle
                  Hi Krunal,

                  1) When you say "unable to connect error", what does this mean? Does your browser return an HTTP 404?

                  2) What is the URL you're using to access APEX?

                  3) What is the output of the following command from your OS: lsnrctl status

                  Joel
                  • 6. Re: Application Express Stopped working.
                    Krunal
                    hi,
                    1. I am not getting HTTP 404 Error. its Unable to connect message from browser (As if the site is not available/ internet not working)
                    2. my link is http://localhot:7777/apex
                    3. Result of LSNRCTL STATUS
                    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 09-NOV-2012 22:41:31

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

                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
                    STATUS of the LISTENER
                    ------------------------
                    Alias LISTENER
                    Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
                    Start Date 09-NOV-2012 22:25:42
                    Uptime 0 days 0 hr. 15 min. 51 sec
                    Trace Level off
                    Security ON: Local OS Authentication
                    SNMP OFF
                    Listener Parameter File C:\app\Bhatt\product\11.2.0\dbhome_1\network\admin\listener.ora
                    Listener Log File c:\app\bhatt\diag\tnslsnr\Bhatt-PC\listener\alert\log.xml
                    Listening Endpoints Summary...
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                    Services Summary...
                    Service "CLRExtProc" has 1 instance(s).
                    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                    Service "krunal" has 1 instance(s).
                    Instance "krunal", status UNKNOWN, has 1 handler(s) for this service...
                    The command completed successfully
                    • 7. Re: Application Express Stopped working.
                      Mehabub Sheikh
                      I could see some spelling mistakes
                      it should be http://localhost:7777/apex not http://localhot:7777/apex
                      Also try with http://<actualip>:7777/apex

                      Thanks,
                      Mehabub

                      Edited by: Mehabub Sheikh on Nov 9, 2012 10:10 AM
                      • 8. Re: Application Express Stopped working.
                        Krunal
                        Oh that was actually a spelling mistake.
                        And i also used the actual IP of my system

                        i.e. http://my_ip:7777/apex

                        But still the result is same.
                        • 9. Re: Application Express Stopped working.
                          Mehabub Sheikh
                          It seems to be problem with your listener.
                          The listener output shows that the instance status is UNKNOWN.
                          Could you please delete the listener and recreate and try?

                          Thanks,
                          Mehabub
                          • 10. Re: Application Express Stopped working.
                            joelkallman-Oracle
                            Krunal,

                            If you're using the default database listener (and you haven't crafted your own listener.ora file, which I suspect you have not), do the following:

                            1) Connect as sys
                            2) Run: exec dbms_xdb.sethttpport( 7778 );
                            3) Run: alter system register
                            4) Exit SQL*Plus and then run your 'lsnrctl status' command again. See if the listener is now listening on port 7778.
                            5) If it is, try your URL again, but try on port 7778.

                            Joel
                            • 11. Re: Application Express Stopped working.
                              928468
                              Hi Krunal,

                              did the solution suggested by Joel work for your environment?

                              We have experienced a similar behavior with two customers, one running APEX 4.0.2.00.07, one 4.1.1.00.23 but both on 11gR2.
                              Restarting the listener only did not work - restarting the whole database instance finally did the trick.

                              Joel, thanks for the suggestion.
                              Do you have an explanation for this?

                              Many thanks and kind regards
                              Sandro
                              • 12. Re: Application Express Stopped working.
                                joelkallman-Oracle
                                Sandro,

                                Have you tried my instructions above? If the customer's database has a local listener defined (DB initialization parameter local_listener), you should be able to register the db with this listener using "alter system register".

                                I've seen this on my own personal DB - where the HTTP protocol doesn't seem to have registered with the listener. I've found that I have to do both - set the HTTP port and then re-register the listener. Do I have an explanation for this? No - it's beyond my domain of expertise.

                                Joel
                                • 13. Re: Application Express Stopped working.
                                  928468
                                  Thanks Joel,

                                  no, we haven't tried your instructions yet, as the problem was solved by recycling the instance.
                                  But we will certainly give it a try the next time this comes up.

                                  We are currently investigating if there have been any changes prior to the outage.
                                  At least it seems that the listener has been restarted and - like you mentioned - HTTP failed to register.
                                  I will let you know if it works.

                                  Just a small question though: Is it possible to set and register the original port (like 8080) again or is a different port required to fix this?

                                  Thanks again and have a nice day,
                                  Sandro
                                  • 14. Re: Application Express Stopped working.
                                    joelkallman-Oracle
                                    Hi Sandro,

                                    +>> Is it possible to set and register the original port (like 8080) again or is a different port required to fix this?+

                                    Yes, definitely. If it's already set to 8080, there should not be a problem to set it to 8080 again via dbms_xdb.sethttpport.

                                    Joel