Init job: cannot purge recycle bin for Oracle catalogue
The current init job fails to purge the recycle of the Oracle DBL:
ERROR: ORACLE SQLPLUS client is not present, cannot purge recycle bin: /usr/bin/sqlplus64
/opt/run/bin/init.sh: line 110: /usr/bin/sqlplus64: No such file or directory
/opt/run/bin/init.sh: line 111: /usr/bin/sqlplus64: No such file or directory
This is related to the following lines in the init.sh script:
test -f ${ORACLE_SQLPLUS} || echo "ERROR: ORACLE SQLPLUS client is not present, cannot purge recycle bin: ${ORACLE_SQLPLUS}"
LD_LIBRARY_PATH=$(readlink ${ORACLE_SQLPLUS} | sed -e 's;/bin/[^/]\+;/lib;') ${ORACLE_SQLPLUS} $(echo $DATABASEURL | sed -e 's/oracle://') @/opt/ci/init/purge_database.ext
LD_LIBRARY_PATH=$(readlink ${ORACLE_SQLPLUS} | sed -e 's;/bin/[^/]\+;/lib;') ${ORACLE_SQLPLUS} $(echo $DATABASEURL | sed -e 's/oracle://') @/opt/ci/init/purge_recyclebin.ext
Is this something we should fix or can we safely remove it? I can't tell exactly how long this has been going on as previous job artefacts have been deleted by now, but this part of the script has not been touched in ages.