Apex_PU not properly configured about docker-oracle-apex-ords

[araczkowski]

Hi @lmfmsilva

it's because the Oracle REST Data Service in the apex_pu.xml is not configured correctly.

I will check this deeper but as a workaround you can:

1. in console

ssh root@localhost -p 49160
vim /u01/ords/conf/apex_pu.xml

change the password to your password and the username to APEX_REST_PUBLIC_USER

service tomcat restart
tail -f /tomcat/logs/catalina.out

2. in browser go to http://localhost:8080/ords

now should be OK

[lmfmsilva]

Hi Andrzej ,

Even though the workaround clears the error, the fundamental issue is that ords doesn't seem able to serve workspace static files (I suspect that static application files as well).

I tried to validate the ords.war:
java -jar /tomcat/webapps/ords.war validate
(used the localhost, sys/secret params)
But the connection fails:
WARNING: Failed to connect to user SYS AS SYSDBA jdbc:oracle:thin:@localhost:1521:xe
IO Error: Connection reset

Any ideas?

[araczkowski]

now I noticed that you have a problem with the serving static APEX files via ORDS, strange
(previously I thought the your problem is with Oracle REST)

OK, tell me more:

1. Which option?
   Own image
   or
   Prebuild image from docker hub

2. Which version?
   the newest APEX 5.1 and ORDS 3.0.9
   or
   older version

3. Are you able to connect to the container via ssh?
   (https://github.com/araczkowski/docker-oracle-apex-ords#connect-via-ssh-to-server-with-following-setting)

4. send me a print screen from your browser console, what can you see on this link: http://localhost:8080/ords/apex
   

[lmfmsilva]

Hi,

1. Prebuilt image from hub.docker.com
2. The newest version (apex 5.1) - but the problem also occured in the previous version
3. Yes I am
4. See atached image:
   

I was able to solve this problems by repeating the ords.war setup command (and restarting tomcat):
root@8845bb4fb5e9:/tomcat/webapps# java -jar ords.war setup