3 Replies Latest reply on Dec 12, 2013 5:35 AM by Krishna Vashistha

    How to configure Apex Listener 2.0.5

    Krishna Vashistha

      Hello Everyone!

       

      My apex environment is already set with apex listener version apex_listener.1.1.3.243.11.40 deployed on Oracle Weblogic Server, perfectly running good. Now as new release is out apex_listener.2.0.5.287.04.27, I tried to configure it by executing command

      java -jar apex.war
      

      Here is the output for above command execution:

      D:\app\[USER]\product\11.1.0\db_1\bin\apex_listener.2.0.5.287.04.27>java -Dapex.erase=true -jar apex.war
      Migrating existing configuration in C:\DOCUME~1\[USER]\LOCALS~1\Temp\apex\apex-config.xml to the latest Listener configuration format, storing in: C:\DOCUME~1\[USER]\LOCALS~1\Temp\apex
      Enter 1 to enter passwords for the RESTful Services database users (APEX_LISTENER,APEX_REST_PUBLIC_USER), 2 to use the same password as used for APEX_PUBLIC_USER or, 3 to skip this step [1]:1
      Enter the database password for APEX_LISTENER:
      Confirm password:
      Enter the database password for APEX_REST_PUBLIC_USER:
      Confirm password:
      Dec 10, 2013 3:59:34 PM oracle.dbtools.common.config.file.ConfigurationFiles update
      INFO: Updated configurations: defaults, apex, apex_al, apex_rt
      Enter 1 to migrate existing Resource Templates to APEX RESTful Services or 2 to skip this step:2
      Enter 1 if you wish to start in standalone mode or 2 to exit [1]:1
      Enter the HTTP port [8080]:8080
      Dec 10, 2013 4:10:02 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.
      Dec 10, 2013 4:10:02 PM oracle.dbtools.standalone.Standalone execute
      INFO: Starting standalone Web Container in:  C:\DOCUME~1\[USER]\LOCALS~1\Temp\apex
      Dec 10, 2013 4:10:02 PM oracle.dbtools.standalone.Deployer deploy
      INFO: Will deploy application path = C:\DOCUME~1\[USER]\LOCALS~1\Temp\apex\apex\WEB-INF\web.xml
      Dec 10, 2013 4:10:02 PM oracle.dbtools.standalone.Deployer deploy
      INFO: Deployed application path = C:\DOCUME~1\[USER]\LOCALS~1\Temp\apex\apex\WEB-INF\web.xml
      Dec 10, 2013 4:10:09 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
      INFO: Using configuration folder: C:\Documents and Settings\[USER]\Local Settings\Temp\apex
      Configuration properties for: apex
      cache.caching=false
      cache.directory=C:\DOCUME~1\[USER]\LOCALS~1\Temp\apex\cache
      cache.duration=days
      cache.expiration=7
      cache.maxEntries=500
      cache.monitorInterval=60
      cache.procedureNameList=
      cache.type=lru
      db.connectionType=basic
      db.customURL=
      db.hostname=localhost
      db.password=******
      db.port=1521
      db.servicename=
      db.sid=orcl
      db.tnsAliasName=
      db.tnsDirectory=D:\app\[USER]\product\11.1.0\db_1\bin\NETWORK\ADMIN
      debug.debugger=false
      debug.printDebugToScreen=false
      error.keepErrorMessages=true
      error.maxEntries=50
      jdbc.AbandonedConnectionTimeout=900
      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
      procedure.postProcess=
      procedure.preProcess=
      security.disableDefaultExclusionList=false
      security.exclusionList=
      security.inclusionList=
      security.maxEntries=2000
      security.requestValidationFunction=
      security.trustedProxies=
      db.username=APEX_PUBLIC_USER
      Using JDBC driver: Oracle JDBC driver version: 11.2.0.3.0
      Dec 10, 2013 4:10:11 PM oracle.dbtools.rt.web.SCListener contextInitialized
      INFO: Oracle Application Express Listener initialized
      Application Express Listener version : 2.0.5.287.04.27
      Application Express Listener server info: Grizzly/1.9.49
      Dec 10, 2013 4:10:11 PM com.sun.grizzly.Controller logVersion
      INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 12/10/13 4:10 PM
      Dec 10, 2013 4:10:11 PM oracle.dbtools.standalone.Standalone execute
      INFO: http://localhost:8080/apex started.
      

       

      Though the command prompted me for password for APEX_LISTENER & APEX_REST_PUBLIC_USER, also the PORT to expose, but got stuck as it didn't prompt / pop a new browser window, to configure apex listener at http://localhost:8080/apex/listenerconfigure, as it is supposed to when I configured apex_listener.1.1.3.243.11.40.

       

      Also when I exclusively access http://localhost:8080/apex/listenerconfigure at the browser, so that I could provide password on APEX_PUBLIC_USER and host server name, the browser return back with error:

      404 - Not Found 
      

       

      So, kindly does anyone know how shall I proceed further to configure apex listener?