My Oracle Support Banner

Error 404 Testing ORDS REST Service with APEX (Doc ID 2333232.1)

Last updated on JULY 14, 2022

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

ORDS and APEX have been configured, and APEX is running successfully. However, an HTTP 404 error is thrown when making an APEX based REST request: 
http://<IP ADDRESS>:8080/ords/rrhh/hr/empinfo/

The error appearing in the Tomcat log (catalina.out) shows the following:

Nov 27, 2017 5:15:58 PM
WARNING: *** jdbc.MaxLimit in configuration |apex|al| is using a value of 10, this setting may not be sized adequately for a production environment ***
Nov 27, 2017 5:15:58 PM
WARNING: *** jdbc.InitialLimit in configuration |apex|al| is using a value of 3, this setting may not be sized adequately for a production environment ***
Nov 27, 2017 5:15:58 PM oracle.ucp.common.UniversalConnectionPoolBase initInactiveConnectionTimeoutTimer
INFO: inactive connection timeout timer scheduled
Nov 27, 2017 5:15:58 PM oracle.ucp.common.UniversalConnectionPoolBase initInactiveConnectionTimeoutTimer
INFO: inactive connection timeout timer scheduled
Nov 27, 2017 5:15:58 PM
SEVERE: *** The pool named: |apex|pu| is reporting no APEX workspaces are enabled for RESTful Services,
but the pool named: |apex|al| is reporting 4 workspaces are enabled.
This implies APEX was installed after Oracle REST Data Services. Please run the following command and restart Oracle REST Data Services:
java -jar ords.war validate --database apex
APEX based RESTful Services, including those used to serve static resources will not function until this has been done.
***

What is causing this failure?

Changes

 Using APEX based REST services with ORDS.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.