3 Replies Latest reply: Apr 26, 2014 8:28 PM by mark.lancaster RSS

    ORDS 2.0.6 - ORDS 2.0.7

    Bob T.

      We have two separate systems that are encountering the same severe errors:

       

      System 1:

       

      Oracle DB 11.2.0.4

      Tomcat 7.0.53

      ORDS 2.0.7

      APEX 4.2.5

       

      System 2:

      Same as above.

       

      Errors on both systems are:

       

       

      Total Accesses:    1000.0<br />

      Total Traffic:    7.27M<br />

      Total Errors:    0<br />

      Total File Downloads:    39<br />

      Total Processing Time:    0 Days 00:17:33.258<br />

      No Requests Yet<br />

      Security:<br />    Total Entries: 0   Maximum Entries Allowed: 2000<br />

      Caching Files:<br />    Caching file is disabled.<br />

       

      Apr 13, 2014 12:00:39 PM oracle.dbtools.apex.statistics.Statistics print

      INFO: Current Time:    Sun Apr 13 12:00:39 CDT 2014<br />

      Server Uptime:    0 Days 04:10:56.865<br />

      Total Accesses:    2000.0<br />

      Total Traffic:    13.28M<br />

      Total Errors:    0<br />

      Total File Downloads:    68<br />

      Total Processing Time:    0 Days 00:19:34.128<br />

      No Requests Yet<br />

      Security:<br />    Total Entries: 0   Maximum Entries Allowed: 2000<br />

      Caching Files:<br />    Caching file is disabled.<br />

       

      Apr 13, 2014 12:09:35 PM oracle.dbtools.apex.ModApexContext write

      SEVERE: null

      ClientAbortException:  java.io.IOException

          at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:413)

          at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:342)

          at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:438)

          at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:426)

          at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:91)

          at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:84)

          at oracle.dbtools.rt.web.WebErrorResponse$DeferErrorOuput.write(WebErrorResponse.java:255)

          at oracle.dbtools.apex.ModApexContext.write(ModApexContext.java:240)

          at oracle.dbtools.apex.ModApexContext.write(ModApexContext.java:198)

          at oracle.dbtools.apex.ModApex.handleRequest(ModApex.java:231)

          at oracle.dbtools.apex.ModApex.doGet(ModApex.java:96)

          at oracle.dbtools.apex.ModApex.service(ModApex.java:300)

          at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:350)

          at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

          at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

          at com.googlecode.psiprobe.Tomcat70AgentValve.invoke(Tomcat70AgentValve.java:38)

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

          at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

          at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)

          at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

          at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2441)

          at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2430)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

          at java.lang.Thread.run(Thread.java:744)

      Caused by: java.io.IOException

          at org.apache.coyote.http11.InternalAprOutputBuffer.flushBuffer(InternalAprOutputBuffer.java:205)

          at org.apache.coyote.http11.InternalAprOutputBuffer.access$100(InternalAprOutputBuffer.java:37)

          at org.apache.coyote.http11.InternalAprOutputBuffer$SocketOutputBuffer.doWrite(InternalAprOutputBuffer.java:235)

          at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:119)

          at org.apache.coyote.http11.AbstractOutputBuffer.doWrite(AbstractOutputBuffer.java:192)

          at org.apache.coyote.Response.doWrite(Response.java:520)

          at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:408)

          ... 35 more

       

      Apr 13, 2014 12:57:10 PM oracle.dbtools.apex.ModApexContext write

      SEVERE: null

      ClientAbortException:  java.io.IOException

          at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:413)

          at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:342)

          at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:438)

          at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:426)

          at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:91)

          at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:84)

          at oracle.dbtools.rt.web.WebErrorResponse$DeferErrorOuput.write(WebErrorResponse.java:255)

          at oracle.dbtools.apex.ModApexContext.write(ModApexContext.java:240)

          at oracle.dbtools.apex.ModApexContext.write(ModApexContext.java:198)

          at oracle.dbtools.apex.ModApex.handleRequest(ModApex.java:231)

          at oracle.dbtools.apex.ModApex.doGet(ModApex.java:96)

          at oracle.dbtools.apex.ModApex.service(ModApex.java:300)

          at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:350)

          at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

          at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

          at com.googlecode.psiprobe.Tomcat70AgentValve.invoke(Tomcat70AgentValve.java:38)

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

          at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

          at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)

          at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

          at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2441)

          at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2430)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

          at java.lang.Thread.run(Thread.java:744)

      Caused by: java.io.IOException

          at org.apache.coyote.http11.InternalAprOutputBuffer.flushBuffer(InternalAprOutputBuffer.java:205)

          at org.apache.coyote.http11.InternalAprOutputBuffer.access$100(InternalAprOutputBuffer.java:37)

          at org.apache.coyote.http11.InternalAprOutputBuffer$SocketOutputBuffer.doWrite(InternalAprOutputBuffer.java:235)

          at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:119)

          at org.apache.coyote.http11.AbstractOutputBuffer.doWrite(AbstractOutputBuffer.java:192)

          at org.apache.coyote.Response.doWrite(Response.java:520)

          at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:408)

          ... 35 more

       

      Apr 13, 2014 12:57:10 PM oracle.dbtools.apex.ModApexContext write

      SEVERE: null

      ClientAbortException:  java.io.IOException

          at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:413)

          at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:342)

          at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:438)

          at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:426)

          at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:91)

          at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:84)

          at oracle.dbtools.rt.web.WebErrorResponse$DeferErrorOuput.write(WebErrorResponse.java:255)

          at oracle.dbtools.apex.ModApexContext.write(ModApexContext.java:240)

          at oracle.dbtools.apex.ModApexContext.write(ModApexContext.java:198)

          at oracle.dbtools.apex.ModApex.handleRequest(ModApex.java:231)

          at oracle.dbtools.apex.ModApex.doGet(ModApex.java:96)

          at oracle.dbtools.apex.ModApex.service(ModApex.java:300)

          at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:350)

          at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

          at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

          at com.googlecode.psiprobe.Tomcat70AgentValve.invoke(Tomcat70AgentValve.java:38)

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

          at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

          at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)

          at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

          at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2441)

          at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2430)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

          at java.lang.Thread.run(Thread.java:744)

      Caused by: java.io.IOException

          at org.apache.coyote.http11.InternalAprOutputBuffer.flushBuffer(InternalAprOutputBuffer.java:205)

          at org.apache.coyote.http11.InternalAprOutputBuffer.access$100(InternalAprOutputBuffer.java:37)

          at org.apache.coyote.http11.InternalAprOutputBuffer$SocketOutputBuffer.doWrite(InternalAprOutputBuffer.java:235)

          at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:119)

          at org.apache.coyote.http11.AbstractOutputBuffer.doWrite(AbstractOutputBuffer.java:192)

          at org.apache.coyote.Response.doWrite(Response.java:520)

          at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:408)

          ... 35 more

        • 1. Re: ORDS 2.0.6 - ORDS 2.0.7
          Bob T.

          There is something to be said for enjoying a relaxing evening with nothing to interrupt the evening except for the sound of chirping crickets in the background.........

           

          Bob

          • 2. Re: ORDS 2.0.6 - ORDS 2.0.7
            teedub

            Especially with a good scotch in hand.

             

            As far as your problem goes, I have no idea. Detangling java is not all that user friendly.

             

            However, have you fired up the stand-alone listener using the same config and images etc to find out whether the issue lies with ORDS or with apache?

             

            My usual issue with apache is file permissions, but this can be identified from the tomcat logs.

             

            If your post implies that you have some working installations then comparing them (or cloning listener & tomcat one at a time) may narrow your focus.

             

            I like your approach Bob.

             

            ~t

            • 3. Re: ORDS 2.0.6 - ORDS 2.0.7
              mark.lancaster

              Hi Bob

               

              Tomcat needs write permissions on the directory holding the configuration files.

              Assuming Tomcat user is tomcat:

               

              $ java -jar ords.war configdir /u01/ords

              $ su root

              Password:

              # chown -R tomcat:dba /u01/ords

              # chmod -R 774 /u01/ords

               

              Hope this helps

               

              Mark