We upgraded from APEX 21.1 to 21.2 and there was one error in the install log.
ok 76 - Installing APEX$SESSION Context | 0.00
not ok 77 - Recompiling APEX_210200 | 0.18
# Message: ORA-00054: resource busy and acquire with NOWAIT specified or tim
eout expired ORA-06512: at "SYS.UTL_RECOMP", line 875
# ORA-06512: at line 4
This seems to be the cause for a related error running a scheduler job. This job no longer exists so I guess it is a temporary job just for the duration of the upgrade?
dba_scheduler_job_run_details show status=FAILED with
ORA-12012: error on auto execute of job "APEX_210200"."ORACLE_APEX_COPY_POST_METADATA"
ORA-20001: Install errors found in phase , see "not ok" messages above for details.
ORA-06512: at "APEX_210200.WWV_INSTALL_API", line 467
ORA-06512: at "APEX_210200.WWV_FLOW_UPGRADE", line 9009
BINARY_OUTPUT BLOB shows the same install log with the not ok 77 message above.
Is this cause for concern or is it a harmless error? Do any corrective actions need to be taken?
Thanks