1 2 3 Previous Next 34 Replies Latest reply: Dec 5, 2012 5:05 PM by user12839427 RSS

    503 Service Temporarily Unavailable

    623269
      Hi,
      For some reason, I get the following message when trying to connect to APEX:
      "Service Temporarily Unavailable
      The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later."

      I'm working on local with Windows XP and 10gR2 Database and connecting through http://localhost:7777/pls/apex

      I can enter http://localhost:7777/ because de HTTP_Server is up and status Alive in OPMNCTL

      I've been working on it for some time now without problems. I think my IP changed since last time I connected, apart from that I can't think of anything else that is different. I also think it's this because when I took my PC some place else and connected it, this also happened.

      I've tryed to find where that IP might be hard-coded but No way. Windows Hosts has my loopback IP (10.10.10.10) as localhost, the DADS file contains the right connection string and logs say there's no listener, but it is up and running, DB works ok.

      I really don't know what else to try, hope to find some help. Thank you.
        • 1. Re: 503 Service Temporarily Unavailable
          joelkallman-Oracle
          Marc,

          Look in the Oracle HTTP Server error log, in directory $ORACLE_HOME/Apache/Apache/logs. That will tell us what is failing.

          Joel
          • 2. Re: 503 Service Temporarily Unavailable
            623269
            This is what I find in the error log

            [Mon Feb 25 13:07:32 2008] [error] [client 127.0.0.1] [ecid: 1203973651:10.10.10.10:1024:3092:4,0] mod_plsql: /pls/apex/apex HTTP-503 ORA-12541

            This error is supposedly because of the listener, but my listener is up and running. I haven't changed configuration since last time it worked. Just thought I'd let you know.
            • 3. Re: 503 Service Temporarily Unavailable
              joelkallman-Oracle
              Marc,

              1) Please post the Database Access Descriptor for 'apex' from dads.conf (feel free to blank out any password).

              2) Please show the output of "lsnrctl status" from your database server.

              Joel
              • 4. Re: 503 Service Temporarily Unavailable
                623269
                Sorry I couldn't post sooner.
                In the dads file:

                <Location /pls/apex>
                Order deny,allow
                PlsqlDocumentPath docs
                AllowOverride None
                PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
                PlsqlDatabaseConnectString     localhost:1521:orcl SIDFormat
                PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
                PlsqlAuthenticationMode Basic
                SetHandler pls_handler
                PlsqlDocumentTablename wwv_flow_file_objects$
                PlsqlDatabaseUsername APEX_PUBLIC_USER
                PlsqlDefaultPage apex
                PlsqlDatabasePassword      "pass"
                Allow from all
                </Location>


                Thel lsnrctl status returned (in spanish):

                LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 26-FEB-2008 09:35
                :23

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

                Conectßndose a (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                ESTADO del LISTENER
                ------------------------
                Alias LISTENER
                Versi¾n TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
                ction
                Fecha de Inicio 25-FEB-2008 12:47:20
                Tiempo Actividad 0 dÝas 20 hr. 48 min. 3 seg.
                Nivel de Rastreo off
                Seguridad ON: Local OS Authentication
                SNMP OFF
                Parßmetros del Listener D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
                Log del Listener D:\oracle\product\10.2.0\db_1\network\log\listener.log

                Recibiendo Resumen de Puntos Finales...
                (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.10)(PORT=1521)))
                Resumen de Servicios...
                El servicio "Oracle8" tiene 1 instancia(s).
                La instancia "ORCL", con estado UNKNOWN, tiene 1 manejador(es) para este servicio...
                El servicio "PLSExtProc" tiene 1 instancia(s).
                La instancia "PLSExtProc", con estado UNKNOWN, tiene 1 manejador(es) para este
                servicio...
                El servicio "orcl" tiene 1 instancia(s).
                La instancia "orcl", con estado READY, tiene 1 manejador(es) para este servicio...
                El servicio "orclXDB" tiene 1 instancia(s).
                La instancia "orcl", con estado READY, tiene 1 manejador(es) para este servicio...
                El servicio "orcl_XPT" tiene 1 instancia(s).
                La instancia "orcl", con estado READY, tiene 1 manejador(es) para este servicio...
                El servicio "s1" tiene 1 instancia(s).
                La instancia "orcl", con estado READY, tiene 1 manejador(es) para este servicio...
                El comando ha terminado correctamente


                *10.10.10.10 is defined as localhost in Windows Hosts file.
                *10.10.10.10 is the local ip from my loopback adapter
                • 5. Re: 503 Service Temporarily Unavailable
                  joelkallman-Oracle
                  Marc,

                  Why are you using SIDFormat?

                  Can you please change this line to:
                  PlsqlDatabaseConnectString localhost:1521:orcl ServiceNameFormat
                  bounce the Web server, and try again.

                  Joel
                  • 6. Re: 503 Service Temporarily Unavailable
                    369783
                    Also, this part looks strange:

                    [Mon Feb 25 13:07:32 2008] [error] [client 127.0.0.1] [ecid: 1203973651:10.10.10.10:1024:3092:4,0] mod_plsql: /pls/apex/apex HTTP-503 ORA-12541

                    The error log says you are calling /pls/apex/apex, yet your DAD only has /pls/apex. It appears that somehow, somewhere, you are getting an extra /apex tossed in there (or it's a posting typo).

                    Bill Ferguson
                    • 7. Re: 503 Service Temporarily Unavailable
                      joelkallman-Oracle
                      Bill,

                      I actually think that part is acceptable. Because the DAD definition has a value of 'apex' for PlsqlDefaultPage, if you attempt to go to /pls/apex, it ultimately will go to /pls/apex/apex - the procedure named 'apex.

                      Joel
                      • 8. Re: 503 Service Temporarily Unavailable
                        369783
                        Ah, I missed that part.

                        I haven't ever specified a specific page/procedure, I just let the users specify which app they want, though I would prefer if they hit my main menu of apps, I don't force them to.

                        Thanks for the explanation Joel.

                        Bill Ferguson
                        • 9. Re: 503 Service Temporarily Unavailable
                          623269
                          I changed the DADS file like you said and still nothing. Now the log says :

                          127.0.0.1 - APEX_PUBLIC_USER [27/Feb/2008:13:20:30 -0800] "GET /pls/apex/apex HTTP/1.1" 503 442
                          • 10. Re: 503 Service Temporarily Unavailable
                            joelkallman-Oracle
                            Marc,

                            You're showing an entry from the access log. What are the most recent entries in the error log?

                            Joel
                            • 11. Re: 503 Service Temporarily Unavailable
                              623269
                              sorry, the last one is:

                              [Wed Feb 27 13:20:30 2008] [error] [client 127.0.0.1] [ecid: 1204147229:10.10.10.10:2248:2476:5,0] mod_plsql: /pls/apex/apex HTTP-503 ORA-12541


                              but as you saw I accessed it later and I guess there was no error, although the same happened, the temporarily page appeared.
                              • 12. Re: 503 Service Temporarily Unavailable
                                623269
                                my bad, it was actually created at my last attempt. Error log file had earlier modify time, thats why I got the wrong impression.
                                • 13. Re: 503 Service Temporarily Unavailable
                                  623269
                                  Just making sure my last post wasn't taken as a "problem solved" post.
                                  :-)
                                  • 14. Re: 503 Service Temporarily Unavailable
                                    joelkallman-Oracle
                                    Marc,

                                    ORA-12541 means "no database listener". Either it's not running or the server that you're trying to connect to cannot be located.

                                    You have specified "localhost" in your Database Access Descriptor. Is Oracle HTTP Server/mod_plsql running on the same physical machine as your database?

                                    From the server where you have Oracle HTTP Server running, can you connect via SQL*Plus using:
                                    sqlplus apex_public_user/pass@localhost:1521/orcl
                                    Obviously, replace "pass" with the password specified in your Database Access Descriptor configuration.

                                    Joel
                                    1 2 3 Previous Next