Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

there are issues with configuration of static files ORDS 19.1 + Tomcat 8.5 + Apex 19.1 (CDB) + DB 12

iTech SolutionsAug 3 2019 — edited Aug 3 2019

Deployment Environment:

OS: windows server 2012 R1

Database : Oracle 12xr2 (12.2.0.1) CDB + pdb1 + pdb2

APEX 19.1 installation on CDB level

  1. @apexins.sql SYSAUX SYSAUX TEMP /i/
  2. @apxchpwd.sql
  3. ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
  4. @apex_rest_config.sql
    1. this didn't asked me to put any password

ORDS 19.1 Deployed on Apache Tomcat 8.5. (ORDS Multitenant utilization as http://ip:port/ords/[pdb1,pdb2...] via <entry key="db.serviceNameSuffix"></entry> entry in default.xml file)

ORDS + Tomcat are deployed on separate machine

  • ORDS install advanced
  • provided service name of my cdb
  • provided passwords for rest users

https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.1/aelig/configuring-REST-data-services.html#GUID-37A5B6CB-A68D-4D7B-BE99-CCCF940A235C

Everything works, as it should, but just a popup appears

There are issues with the configuration of the Static Files in your environment. Please consult the "Configuring Static File Support" section in the Application Express Installation Guide.

i can access

http://ip:port/  tomcat page

http://ip:port/ords/  Apex login page with popup as above

http://ip:port/ords/pdb1/  Apex login page with popup as above

http://ip:port/ords/pdb2/  Apex login page with popup as above

i am unable to fix above.

Comments
Post Details
Added on Aug 3 2019
1 comment
1,144 views