This discussion is archived
1 2 3 Previous Next 34 Replies Latest reply: Dec 5, 2012 3:05 PM by 978257 RSS

503 Service Temporarily Unavailable

623269 Newbie
Currently Being Moderated
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
    jkallman Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    jkallman Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    jkallman Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    jkallman Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    jkallman Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Just making sure my last post wasn't taken as a "problem solved" post.
    :-)
  • 14. Re: 503 Service Temporarily Unavailable
    jkallman Employee ACE
    Currently Being Moderated
    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