Hi,
I installed ORDS 22.2.1.r2021302 as standalone on port 8080. On the same Linux VM I installed Apache webserver to handle the domain/ssl to have access via port 80.
All is working fine. I can request access via "https://my_domain/ords" and have access to the APEX environment. I created a workspace and enabled RESTful Access with schema alias "pda".
If I try to access sdw/DB Actions via "https://my_domain/ords/pda/_sdw/" I get an "500 Internal Server Error":
Here are the ORDS config files:
cat pool.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Wed Sep 28 12:42:35 UTC 2022</comment>
<entry key="db.connectionType">basic</entry>
<entry key="db.hostname">hostname</entry>
<entry key="db.port">1521</entry>
<entry key="db.servicename">servicename</entry>
<entry key="db.username">ORDS_PUBLIC_USER</entry>
<entry key="feature.sdw">true</entry>
<entry key="plsql.gateway.mode">proxied</entry>
<entry key="restEnabledSql.active">true</entry>
<entry key="security.requestValidationFunction">wwv_flow_epg_include_modules.authorize</entry>
</properties>
cat settings.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Wed Sep 28 13:52:13 UTC 2022</comment>
<entry key="database.api.enabled">true</entry>
<entry key="standalone.context.path">/ords</entry>
<entry key="standalone.doc.root">/opt/apex/config/ords/global/doc_root</entry>
<entry key="standalone.http.port">8080</entry>
<entry key="standalone.static.context.path">/i</entry>
<entry key="standalone.static.path">/opt/apex/latest/i/</entry>
<entry key="jdbc.InitialLimit">10</entry>
<entry key="jdbc.MaxLimit">50</entry>
</properties>
Any idea what's wrong?