Hi,
We successfully completed the upgrade from APEX 23.2 to 24.1 on a 19c.22 container database , but the following error appeared in the catpatch.log for patch 36695709 (APEX 24.1.6) :
...Validating APEX
...(15:52:10) Starting validate_apex for APEX_240100
...(15:52:10) Checking missing privileges for APEX_240100
...(15:52:14) Checking missing privileges for APEX_GRANTS_FOR_NEW_USERS_ROLE
...(15:52:14) Re-generating APEX_240100.wwv_flow_db_version
... wwv_flow_db_version is up to date
...(15:52:14) Checking for sys.wwv_flow_cu_constraints
... sys.wwv_flow_cu_constraints is still referenced by APEX_230100
...(15:52:14) Checking invalid public synonyms
...(15:52:14) Key object existence check
...(15:52:16) Post-ORDS updates
...(15:52:16) Calling wwv_flow_upgrade.post_ords_upgrade
Unexpected error trying to REST enable APEX_PUBLIC_ROUTER
ORA-00942: table or view does not exist
...(15:52:16) Setting DBMS Registry for APEX to valid
...(15:52:16) Exiting validate_apex
PL/SQL procedure successfully completed.
...Recompiling invalid public synonyms
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
timing for: Complete Patch 36695709
Elapsed: 00:00:11.87
Apparently, the patch was installed successfully and everything seems to be working fine: (using ORDS 24.2.3)
SQL> select version from sys.dba_registry where comp_id = 'APEX';
VERSION
------------------------------
24.1.6
SQL> select patch_version, installed_on
from apex_patches 2 ;
PATCH_VERSION INSTALLED_ON
------------------------------ -------------------
6 2024-11-28 15:45:03
The error also appears every time we run utlrp.sql in sqlplus ..
Anyone else encounter this issue?