Hi,
I'm just starting out with ORDS and ran into this little curiosity.
I have a dbms_job scheduled to export schemas overnight. When this runs, ords gets killed.
Firstly: is there value in taking data pump exports of the ORDS% schemas? I can just exclude them from the job.
Secondly: where's the log file to find out why it dies?
Currently, I've been running ‘ords serve’ from the command line while I experiment to see if I can get it to work. I've got some basic proofs of concept to operate, but it would be handy to be able to find the logs once it's running in the background to see what's happening.
It outputs, for example:
2023-02-13T19:54:07.034Z INFO Oracle REST Data Services initialized
Oracle REST Data Services version : 22.4.0.r3401044
Oracle REST Data Services server info: jetty/10.0.12
Oracle REST Data Services java info: OpenJDK 64-Bit Server VM 11.0.8+10-LTS
/appdata/oracle/ords/bin/ords: line 221: 101668 Killed ${JAVA} "${APP_VM_OPTS[@]}" ${ORDS_DEBUG} -jar "${ORDS_HOME}"/${ORDS_WAR} ${ORDS_VERBOSE} "$@"
Mon Feb 13 20:36:11 GMT 2023
oracle:/appdata/oracle/ords_config$
(The date at the end is because I ran ‘ords serve; date’ so that I could see what time it got killed)
I'm running Oracle 21c XE on RedHat 7. (7.9 to be more precise).
Thank you,
Tim