Receive "Issues with the configuration of the Static Files" error after ORDS 18 install and configur

Hello,

I have my Oracle components in the following folders:

C:\app\product\18.0.0

C:\app\product\apex

C:\app\product\ords

C:\app\product\sqldeveloper

Is there anything inherently wrong with this folder structure?

I installed the components in this order

XE 18C

Apex 18.2 (using SQLPLUS> @apexins SYSAUX SYSAUX TEMP /i/ 

Once installed, using SQLPlus I executed:

• @apxchpwd
• alter session set "_ORACLE_SCRIPT"=true;
• ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
• ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password;
• @apex_rest_config.sql
• @apex_epg_config.sql C:/app/product (This accesses the subordinate APEX/IMAGES directory)
• Alter User Anonymous Account Unlock;

From File Explorer I used Extract All on ords.3.0.7.253.09.40.zip to the folder C:\app\product\ords

From and elevated command prompt I ran java -jar ords.war install advanced

• When prompted for Configuration Data I supplied C:\app\product\ords
• The install program responded with:
• Your database connection is to a CDB.  ORDS common user ORDS_PUBLIC_USER will be created in the CDB.  ORDS schema will be installed in the PDBs.
• Root CDB$ROOT - create ORDS common user
• PDB PDB$SEED - install ORDS 18.4.0.r3541002 (mode is READ ONLY, open for READ/WRITE)
• PDB XEPDB1 - install ORDS 18.4.0.r3541002
• I started in standalone mode, changed the port to 9090
• When prompted for the Apex Static Resources Location I responded with C:\app\product\apex\images

It seems that ORDS_PUBLIC_USER is created in the CDB and the ORDS schema is created in the PDB.  I don't seem to have much control over that choice.  Would you change any of the installation steps I used?

Thanks again for looking at this.

Thanks very much Thompson.  It's now working perfectly.  I had not set the container to XEPDB1 prior to installing APEX.  That made all the difference.  It seems that the users associated with APEX and ORDS must be in the same PDB container (e,g, XEPDB1).  The install documentation for Apex 18.2 doesn't show the statement alter session set container=XEPDB1 as an example or option.  I got an error with @apex_rest_config when I had the APEX and other installs set to the default container (CDB$ROOT).

Just like you suggested, after installing Apex 18.2 from the same SQLPlus (set to container=XEPDB1) I ran:

@apex_rest_config.sql

@apex_epg_config.sql C:\app\product

When I installed ORDS I used

Configuration Data = C:\app\product

Database Service Name = XEPDB1

Apex Static Resource Location = C:\ app\product\ apex\images

I should mention that after installing XE 18C I adjusted the TNSNAMES.ORA file:

XEPDB1 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = xepdb1)

    )

  )

Thanks again for all your help!