I installed Oracle XE18 in a VPS, installed ORDS, wildcard SSL cert and everything works as expected.
I am able to access my test app using my domain.
I then added a new database which is my database (ADB) in the oracle cloud.
Before that i checked to make sure that the version of ORDS that I installed is the same as the one use in oracle cloud.
command used to setup the new database below
java -jar ords.war setup --database <mydatabase>
java -jar ords.war map-url --type base-path /mydb <mydatabase>
When i try to access a test app that i have in my oracle ADB i got the error message below:
***
There is a problem with your environment because the Application Express files have not been loaded. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide. In addition, please verify that your image prefix path is correct. Your current path is /i/20.2.0.00.20/ (it should contain both starting and ending forward slashes, such as the default /i/). Use the SQL script reset_image_prefix.sql if you need to change it.
***
The ORDS is running in standalone mode. In standalone.properties file, I already have these 2 lines below:
standalone.static.context.path=/i
standalone.static.path=/opt/oracle/ords/apex_images/images
It works fine for the local XE database.
Where do I specify it for the ADB? When I setup ORDS for the ADB database, I found that it created an XML file <mydatabase>.xml. But I dont know where to specifiy the static path for this new database.
Has anyone done something like this?