1 2 Previous Next 18 Replies Latest reply: Jun 5, 2013 7:30 AM by joelkallman-Oracle RSS

    Apex 4.2.2 via Apex Listener 2 - returns blank screen

    Anthony W
      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