Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help interpreting apex listener log errors and listener response.

Andy_CSCSep 24 2013 — edited Oct 22 2013

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2013
Added on Sep 24 2013
2 comments
2,807 views