This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jun 5, 2013 5:30 AM by jkallman RSS

Apex 4.2.2 via Apex Listener 2 - returns blank screen

Anthony W Newbie
Currently Being Moderated
Hi,

When trying to access Apex using the Listener I just get a blank screen. (http://localhost:8080/apex)

http://localhost:8080/i/apex_version.txt - displays "Application Express Version: 4.2.2" - so images setup seems to be OK.

The debug say the "GET /apex/" request "Got results length: NULL"

If I access it via Oracle Application Server (mod_plsql) - it works fine.

Is there something I missing during setup?

Any help would be most appreciated.

Thanks

Anthony


Using Apex 4.2.2 on 11gR2 SE database and Apex Listener 2.0.1.64.14.25 on Linux 64 2.6.32-358.6.1.el6.x86_64.

SQL> select version_no from apex_release;
VERSION_NO
--------------------------------------------------------------------------------
4.2.2.00.11

Using java version "1.6.0_37"


Debug below.

java -jar apex.war
May 1, 2013 4:51:39 PM oracle.dbtools.standalone.Standalone execute
INFO: NOTE:

Standalone mode is designed for use in development and test environments. It is not supported for use in production environments.

May 1, 2013 4:51:39 PM oracle.dbtools.standalone.Standalone execute
INFO: Starting standalone Web Container in: /u/app/oracle/product/apex_listener/apex
May 1, 2013 4:51:39 PM oracle.dbtools.standalone.Deployer deploy
INFO: Will deploy application path = /u/app/oracle/product/apex_listener/apex/apex/WEB-INF/web.xml
May 1, 2013 4:51:39 PM oracle.dbtools.standalone.Deployer deploy
INFO: Deployed application path = /u/app/oracle/product/apex_listener/apex/apex/WEB-INF/web.xml
May 1, 2013 4:51:39 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
INFO: Using configuration folder: /u/app/oracle/product/apex_listener/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=localhost
db.password=******
db.port=1521
db.servicename=DEV01.ABC
debug.debugger=true
debug.printDebugToScreen=true
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
May 1, 2013 4:51:49 PM oracle.dbtools.rt.web.SCListener contextInitialized
INFO: Oracle Application Express Listener initialized
Application Express Listener version : 2.0.1.64.14.26
Application Express Listener server info: Grizzly/1.9.49

May 1, 2013 4:51:49 PM com.sun.grizzly.Controller logVersion
INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 5/1/13 4:51 PM
May 1, 2013 4:51:49 PM oracle.dbtools.standalone.Standalone execute
INFO: http://localhost:8080/apex started.
Request Path passes syntax validation
Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
Applied database connection info
Attempting to process with PL/SQL Gateway
==== Processing Request: ====
GET /apex/
==== Headers in Request ====
host: wmsdev64.aboxford:8080
user-agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0
accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
accept-language: en-gb,en;q=0.5
accept-encoding: gzip, deflate
connection: keep-alive
==== Cookies in Request ====
Using default page: apex
isValidRequest(), procedure name: <apex>
Validating: apex
*** Total number of arguments: 1
SID: 22
Parse: 0 ms
-----
begin
apex;
commit;
end;
*** Total number of arguments: 1
Exec: 5 ms
Got results length: NULL
==== Request Processed ====
Processed PL/SQL Gateway request
1 2 Previous Next

Legend

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