3 Replies Latest reply: Aug 27, 2012 2:29 PM by Udo RSS

    Oracle GlassFish Server 3.1.2 HTTP Status 500 - System Unavailable.

    Sudhir_Meru
      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
          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
            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
              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