2 Replies Latest reply on Oct 23, 2013 2:30 AM by Andy_CSC

    Help interpreting apex listener log errors and listener response.

    Andy_CSC

      Maybe someone can help me here, I've found nothing valuable either in this forum or elsewhere on the web.

      We have the following:

       

      2.6.18-238.el5 GNU/Linux

      Java(TM) SE Runtime Environment (build 1.6.0_27-b07).

      Oracle Application Express Listener 2.0.3 221.10.13

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      APEX 4.1.0.00.32 standalone

      Not using restful services

      The database is on it's own server and connectivity has been checked and re-checked.

       

      The business have been encountering "Internet Explorer cannot display the webpage" .Whenever this error pops up , either the listener is down or non-responsive.

      The other issue that they face is intermittent slowness thorough the day.

       

      I can connect to the

       

       

       

      Additionally when I try to connect to the listener from sql developer I get the  "Cannot connect to Connection Http/1.1 503 Service unavailable "

      Restarting the listener allows access only once.

       

       

      listener startup

      Sep 23, 2013 3:03:24 PM oracle.dbtools.standalone.Standalone execute
      INFO: Starting standalone Web Container in:  /apexlistener/apex/apex
      Sep 23, 2013 3:03:24 PM oracle.dbtools.standalone.Deployer deploy
      INFO: Will deploy application path = /apexlistener/apex/apex/apex/WEB-INF/web.xml
      Sep 23, 2013 3:03:24 PM oracle.dbtools.standalone.Deployer deploy
      INFO: Deployed application path = /apexlistener/apex/apex/apex/WEB-INF/web.xml
      Sep 23, 2013 3:03:24 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
      INFO: Using configuration folder: /apexlistener/apex/apex
      Configuration properties for: apex
      cache.caching=false
      cache.directory=/tmp/apex/cache
      cache.duration=days
      cache.expiration=7
      cache.maxEntries=500
      cache.monitorInterval=60
      cache.procedureNameList=
      cache.type=lru
      db.hostname=10.32.33.13
      db.password=******
      db.port=1521
      db.servicename=OASISH1P
      debug.debugger=false
      debug.printDebugToScreen=false
      error.keepErrorMessages=true
      error.maxEntries=50
      jdbc.DriverType=thin
      jdbc.InactivityTimeout=1800
      jdbc.InitialLimit=3
      jdbc.MaxConnectionReuseCount=1000
      jdbc.MaxLimit=10
      jdbc.MaxStatementsLimit=10
      jdbc.MinLimit=1
      jdbc.statementTimeout=900
      log.logging=false
      log.maxEntries=50
      misc.compress=
      misc.defaultPage=apex
      security.disableDefaultExclusionList=false
      security.maxEntries=2000
      db.username=APEX_PUBLIC_USER
      Using JDBC driver: Oracle JDBC driver version: 11.2.0.3.0
      Sep 23, 2013 3:03:26 PM oracle.dbtools.rt.web.SCListener contextInitialized
      INFO: Oracle Application Express Listener initialized
      Application Express Listener version : 2.0.3.221.10.13

      Application Express Listener server info: Grizzly/1.9.49

       

      Sep 23, 2013 3:03:26 PM com.sun.grizzly.Controller logVersion
      INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 9/23/13 3:03 PM
      Sep 23, 2013 3:03:26 PM oracle.dbtools.standalone.Standalone execute
      INFO: http://localhost:8585/apex started.
      Sep 23, 2013 3:03:55 PM oracle.dbtools.common.config.db.DatabaseConfig doesNotExist
      SEVERE: The pool named: apex_al does not exist
      Sep 23, 2013 3:03:55 PM oracle.dbtools.common.config.db.DatabaseConfig doesNotExist
      SEVERE: The pool named: apex_al does not exist
      Sep 23, 2013 3:03:55 PM oracle.dbtools.common.config.db.DatabaseConfig doesNotExist
      SEVERE: The pool named: apex_al does not exist
      Sep 23, 2013 3:03:55 PM oracle.dbtools.common.config.db.DatabaseConfig doesNotExist
      SEVERE: The pool named: apex_al does not exist
      Sep 23, 2013 3:05:27 PM oracle.dbtools.common.config.file.ConfigurationFiles update
      INFO: Updated configurations: defaults, apex, apex_al, apex_rt

       

       

      I'm seeing the following in the listener log:

       

      hundreds of "Sep 24, 2013 1:21:04 PM com.sun.grizzly.http.KeepAliveThreadAttachment timedOut
      WARNING: GRIZZLY0023: Interrupting idle Thread: Grizzly-8585(4)."

       

      Sep 23, 2013 3:05:27 PM oracle.dbtools.rt.web.WebErrorResponse internalError
      SEVERE: IO Error: Socket closed
      java.sql.SQLRecoverableException: IO Error: Socket closed

       

      Sep 23, 2013 3:15:35 PM com.sun.grizzly.http.servlet.ServletAdapter doService
      SEVERE: service exception:
      ClientAbortException:  java.io.IOException: Connection reset by peer

       


      Sep 24, 2013 9:21:07 AM oracle.dbtools.apex.ModApexContext write
      SEVERE: null
      ClientAbortException:  java.io.IOException: Connection reset by peer

       

       

      I would appreciate any insight anyone could provide.

       

      Regards

       

      Andy