APEX does not start - Version 2020 (10.0) - Hexagon

Check the Catalina.log file in <apache_home>\logs folder:

ORDS Configuration folder contains the apex.xml file.

• Check the XML file. All the XML files contain the connection information for all the user accounts.

• Check the defaults.xml file, if it fits the example below.

  <?xml version="1.0" encoding="UTF-8" standalone="no"?>

  <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">

  <properties>

  <comment>Saved on Tue Jun 26 08:31:49 CEST 2018</comment>

  <entry key="cache.caching">false</entry>

  <entry key="cache.directory">/tmp/apex/cache</entry>

  <entry key="cache.duration">days</entry>

  <entry key="cache.expiration">7</entry>

  <entry key="cache.maxEntries">500</entry>

  <entry key="cache.monitorInterval">60</entry>

  <entry key="cache.procedureNameList"/>

  <entry key="cache.type">lru</entry>

  <entry key="db.hostname">YOUR-SERVER-NAME</entry>

  <entry key="db.port">1521</entry>

  <entry key="db.servicename">YOUR-DATABASE-SERVICE-NAME</entry>

  <entry key="debug.debugger">false</entry>

  <entry key="debug.printDebugToScreen">false</entry>

  <entry key="error.keepErrorMessages">true</entry>

  <entry key="error.maxEntries">50</entry>

  <entry key="jdbc.DriverType">thin</entry>

  <entry key="jdbc.InactivityTimeout">1800</entry>

  <entry key="jdbc.InitialLimit">10</entry>

  <entry key="jdbc.MaxConnectionReuseCount">1000</entry>

  <entry key="jdbc.MaxLimit">50</entry>

  <entry key="jdbc.MaxStatementsLimit">10</entry>

  <entry key="jdbc.MinLimit">1</entry>

  <entry key="jdbc.statementTimeout">900</entry>

  <entry key="log.logging">false</entry>

  <entry key="log.maxEntries">50</entry>

  <entry key="misc.compress"/>

  <entry key="misc.defaultPage">apex</entry>

  <entry key="security.disableDefaultExclusionList">false</entry>

  <entry key="security.maxEntries">2000</entry>

  <entry key="security.requestValidationFunction">wwv_flow_epg_include_modules.authorize</entry>

  <entry key="security.validationFunctionType">plsql</entry>

  </properties>

• Verify whether you can connect with all the accounts.

• Check the user mentioned in the XML file.

  

As a SYSDBA,

Change the password that was configured during the APEX/ORDS installation:

Check if you can login as the user (e.g. APEX_PUBLIC_USER)

Navigate to the Apache Application Manager and reload APEX.

Check the Catalina.log file again. The following log indicates correct configuration:

<Date> <Time> INFO [http-nio-9090-exec-17] . Validating pool: |apex||

<Date> <Time> INFO [http-nio-9090-exec-17] . Pool: |apex|| is correctly configured

<Date> <Time> INFO [http-nio-9090-exec-17] . Validating pool: |apex|al|

<Date> <Time> INFO [http-nio-9090-exec-17] . Pool: |apex|al| is correctly configured

<Date> <Time> INFO [http-nio-9090-exec-17] . Validating pool: |apex|pu|

<Date> <Time> INFO [http-nio-9090-exec-17] . Pool: |apex|pu| is correctly configured

<Date> <Time> INFO [http-nio-9090-exec-17] . Validating pool: |apex|rt|

<Date> <Time> INFO [http-nio-9090-exec-17] . Pool: |apex|rt| is correctly configured

<Date> <Time> INFO [http-nio-9090-exec-17] . Using configuration folder: C:\apache\Ords_Config\apex

<Date> <Time> INFO [http-nio-9090-exec-17] . Oracle REST Data Services initialized

Oracle REST Data Services version : 17.4.1.353.06.48

Oracle REST Data Services server info: Apache Tomcat/8.5.24

<Date> <Time> INFO [http-nio-9090-exec-17] org.apache.catalina.core.StandardContext.reload Reloading Context with name [/apex] is completed.