During APEX Upgrade Getting Error: ORA-01403: no data found ORA-06512: at "SYS.DBMS_REGISTRY"
(Doc ID 2887868.1)
Last updated on FEBRUARY 22, 2024
Applies to:
Oracle Application Express (APEX) - Version 21.2 and laterInformation in this document applies to any platform.
Symptoms
When attempting to upgrade APEX from 18.2 to 21.2, the following error occurs.
# Actions in Phase 3:
not ok 79 - Set Loaded/Upgraded in Registry
# Message: ORA-01403: no data found ORA-06512: at "SYS.DBMS_REGISTRY", line 815
# ORA-06512: at "APEX_210200.WWV_INSTALL_API", line 165
# ORA-06512: at line 2
# Statement: begin
# APEX_210200.wwv_install_api.set_upgraded_in_registry;
# if APEX_210200.wwv_install_api.is_upgrade then
# APEX_210200.wwv_flow_upgrade.set_patch_applied (
# p_from => APEX_210200.wwv_install_api.old_schema );
# end if;
# commit;
# end;
# Message: ORA-06512: at "SYS.DBMS_REGISTRY", line 815 ORA-06512: at "APEX_210200.WWV_INSTALL_API", line 165
# ORA-06512: at line 2
# Statement: as above
# Message: ORA-06512: at "APEX_210200.WWV_INSTALL_API", line 165 ORA-06512: at line 2
# Statement: as above
# Message: ORA-06512: at line 2
# Statement: as above
81 actions passed, 1 actions failed
This is the only error logged. APEX upgrade completed successully, it only failed to update the DBA_REGISTRY,
which can be validated by running the apex_verify script, which still shows APEX is on the old version.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |