Can you share the log for that failed upgrade?
and, the validate command in version 20.2 WILL provide coverage for all the ROLEs
That is the output from java -jar ords.war setup. It simply exited with "Error the ORDS_VERSION does not exist."
No other error.
But it told us something was wrong with the privileges of ords_public_user.
i.e. This database was recently migrated to a container and the ords is setup in PDB only.
there should have been a log file created from when you originally did the install that failed
That's more what APEX update does.
There is no trace of a logfile anywhere under the Tomcat user.
$ ls -slrt
4 drwxrwxrwx 2 tomcat tomcat 4096 2020-05-21 16:46 params
4 drwxrwxrwx 2 tomcat tomcat 4096 2020-05-21 18:12 installer
36 -rw-rw-rw- 1 tomcat tomcat 32893 2020-05-21 18:59 index.html
4 drwxrwxrwx 6 tomcat tomcat 4096 2020-05-21 18:59 examples
4 drwxr-xr-x 3 tomcat tomcat 4096 2020-05-21 19:11 docs
66020 -rw-r--r-- 1 tomcat tomcat 67597876 2020-06-02 10:35 ords.war
did a find also, nothing but the Tomcat logs.
Nothing in /tmp either.