This discussion is archived
3 Replies Latest reply: Aug 27, 2012 12:29 PM by Udo RSS

Oracle GlassFish Server 3.1.2 HTTP Status 500 - System Unavailable.

Sudhir_Meru Newbie
Currently Being Moderated
Hi,

Few days back, I installed Oracle Apex 3.2 with Oracle 1Og Enterprise Edition Along with Oracle GlassFish Server 3.1.2 as listener. It was working fine till some days back. I didn't do any changes system was running.

After some long time when i tried opening apex login page am getting the below error message

HTTP Status 500 - System Unavailable. Please try again later.

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

type Status report

messageSystem Unavailable. Please try again later.

descriptionThe server encountered an internal error (System Unavailable. Please try again later.) that prevented it from fulfilling this request.

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

Oracle GlassFish Server 3.1.2



Please suggest me how to make the instance up and running. Am new to listener concept. Please need apex experts advice.

Thanks
Sudhir

Edited by: Sudhir_Meru on Aug 25, 2012 1:09 AM
  • 1. Re: Oracle GlassFish Server 3.1.2 HTTP Status 500 - System Unavailable.
    Udo Guru
    Currently Being Moderated
    Hi Sudhir,

    a common mistake is not to configure the location for APEX Listener's configuration file. Did you set config.dir in the web.xml of your APEX Listener deployment? If not, APEX Listener will use a temporary location as a default, and this is often purged automatically...

    If you are sure this is not the reason, please provide the log output created by APEX Listener on your GlassFish. It'll be in the server.log if you didn't configure your GlassFish to create application specific log files...

    -Udo
  • 2. Re: Oracle GlassFish Server 3.1.2 HTTP Status 500 - System Unavailable.
    Sudhir_Meru Newbie
    Currently Being Moderated
    Hi Udo,

    Thanks for you reply, Please find the server.log file details, Please suggest me what is the next step.

    [#|2012-08-25T23:10:30.329+0530|SEVERE|oracle-glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=141;_ThreadName=Thread-2;|ORA-04031: unable to allocate 4092 bytes of shared memory ("shared pool","HTPSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer")
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at line 5
    |#]

    [#|2012-08-25T23:10:57.376+0530|SEVERE|oracle-glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=140;_ThreadName=Thread-2;|_init_: # headers=44
    declare nm owa.vc_arr := ?;
         vl owa.vc_arr := ?;
    begin
    owa.init_cgi_env( ?, nm, vl );
    htp.init; htp.HTBUF_LEN := 63;
    ? := sys_context('USERENV','SID');
    end;
    INIT FAILED:ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select obj#,type#,ctime,mtim...","Typecheck heap","kgghteInit")
    |#]

    [#|2012-08-25T23:10:57.376+0530|SEVERE|oracle-glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=140;_ThreadName=Thread-2;|nm(1) := 'accept';
    vl(1) := 'image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*';
    nm(2) := 'accept-language';
    vl(2) := 'en-us';
    nm(3) := 'ua-cpu';
    vl(3) := 'x86';
    nm(4) := 'accept-encoding';
    vl(4) := 'gzip, deflate';
    nm(5) := 'user-agent';
    vl(5) := 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET CLR 1.1.4322)';
    nm(6) := 'host';
    vl(6) := 'localhost:9090';
    nm(7) := 'connection';
    vl(7) := 'Keep-Alive';
    nm(8) := 'cookie';
    vl(8) := 'ORA_WWV_REMEMBER_UN=SUDHIR:DEVELOPMENT';
    nm(9) := 'APEX_LISTENER_VERSION';
    vl(9) := '1.1.2.131.15.23';
    nm(10) := 'DAD_NAME';
    vl(10) := '';
    nm(11) := 'DOC_ACCESS_PATH';
    vl(11) := '';
    nm(12) := 'DOCUMENT_TABLE';
    vl(12) := '';
    nm(13) := 'GATEWAY_IVERSION';
    vl(13) := '3';
    nm(14) := 'GATEWAY_INTERFACE';
    vl(14) := 'CGI/1.1';
    nm(15) := 'HTTP_ACCEPT';
    vl(15) := 'image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*';
    nm(16) := 'HTTP_ACCEPT_ENCODING';
    vl(16) := 'gzip, deflate';
    nm(17) := 'HTTP_ACCEPT_LANGUAGE';
    vl(17) := 'en-us';
    nm(18) := 'HTTP_ACCEPT_CHARSET';
    vl(18) := 'null';
    nm(19) := 'HTTP_COOKIE';
    vl(19) := 'ORA_WWV_REMEMBER_UN=SUDHIR:DEVELOPMENT';
    nm(20) := 'HTTP_IF_MODIFIED_SINCE';
    vl(20) := 'null';
    nm(21) := 'HTTP_IF_NONE_MATCH';
    vl(21) := 'null';
    nm(22) := 'HTTP_HOST';
    vl(22) := 'localhost:9090';
    nm(23) := 'HTTP_ORACLE_ECID';
    vl(23) := '';
    nm(24) := 'HTTP_PORT';
    vl(24) := '9090';
    nm(25) := 'HTTP_REFERER';
    vl(25) := 'null';
    nm(26) := 'HTTP_USER_AGENT';
    vl(26) := 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET CLR 1.1.4322)';
    nm(27) := 'PATH_ALIAS';
    vl(27) := ' ';
    nm(28) := 'PATH_INFO';
    vl(28) := '/f';
    nm(29) := 'PLSQL_GATEWAY';
    vl(29) := 'WebDb';
    nm(30) := 'QUERY_STRING';
    vl(30) := 'p=4550:8:13313968712507625055';
    nm(31) := 'REMOTE_ADDR';
    vl(31) := '127.0.0.1';
    nm(32) := 'REMOTE_USER';
    vl(32) := 'APEX_PUBLIC_USER';
    nm(33) := 'REQUEST_CHARSET';
    vl(33) := 'AL32UTF8';
    nm(34) := 'REQUEST_IANA_CHARSET';
    vl(34) := 'UTF-8';
    nm(35) := 'REQUEST_METHOD';
    vl(35) := 'GET';
    nm(36) := 'REQUEST_PROTOCOL';
    vl(36) := 'http';
    nm(37) := 'REQUEST_SCHEME';
    vl(37) := 'http';
    nm(38) := 'SCRIPT_NAME';
    vl(38) := '/apex';
    nm(39) := 'SCRIPT_PREFIX';
    vl(39) := '';
    nm(40) := 'SERVER_NAME';
    vl(40) := 'localhost';
    nm(41) := 'SERVER_PORT';
    vl(41) := '9090';
    nm(42) := 'SERVER_PROTOCOL';
    vl(42) := 'HTTP/1.1';
    nm(43) := 'SERVER_SOFTWARE';
    vl(43) := 'Mod-Apex';
    nm(44) := 'WEB_AUTHENT_PREFIX';
    vl(44) := ' ';
    |#]

    [#|2012-08-25T23:10:57.376+0530|SEVERE|oracle-glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=140;_ThreadName=Thread-2;|ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select obj#,type#,ctime,mtim...","Typecheck heap","kgghteInit")
    |#]
  • 3. Re: Oracle GlassFish Server 3.1.2 HTTP Status 500 - System Unavailable.
    Udo Guru
    Currently Being Moderated
    Hi Sudhir,

    it seems you have the root cause in your log:
    ORA-04031: unable to allocate 4092 bytes of shared memory
    This is a database related issue that can have various reasons. Fix it and your APEX Listener will work again.
    You could search for this or post with some more information on your database and operating system settings here: {forum:id=61}

    -Udo

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points