ORDS, SODA & JSON in the Database

Oracle 21.3c

Oracle APEX 24.1.7

ORDS 24.4.0

Java 17.0.12

Tomcat 9.0.37

I had follow this instructions to install ORDS :

ords --config D:\oracle\ords-latest\config install

The second step I had updated the 3 and 6 options :

[1] Connection Type: Basic
[2] Basic Connection: HOST=localhost PORT=1521 SERVICE_NAME=orclpdb
Administrator User: SYS AS SYSDBA
[3] Database password for ORDS runtime user (ORDS_PUBLIC_USER): <specified password>
[4] ORDS runtime user and schema tablespaces: Default: SYSAUX Temporary TEMP
[5] Additional Feature: Database Actions
[6] Configure and start ORDS in Standalone Mode: No
[A] Accept and Continue - Create configuration and Install ORDS in the database
[Q] Quit - Do not proceed. No changes

After that, I have added the ORDS configuration path in Environment Virables :

JAVA_TOOL_OPTIONS = -Dconfig.url=D:\oracle\ords-latest\config

Finally, I had copied the ords.war and APEX images folder to Tomcat webapps folder and when start Tomcat I got this error :

Internal Server Error

HTTP Status Code: 500

I had checked APEX and ORDS users and all of them are OPEN :

select username, account_status
from dba_users
where username like '%APEX%';

APEX_LISTENER OPEN
APEX_PUBLIC_USER OPEN
APEX_REST_PUBLIC_USER OPEN
APEX_PUBLIC_ROUTER OPEN

select username, account_status
from dba_users
where username like '%ORDS%';

ORDS_METADATA OPEN
ORDS_PUBLIC_USER OPEN

Knowing that it works fine in Standalone Mode.

Any help ?

@thatjeffsmith-oracle

Thanks.