During APEX Upgrade Getting Error: ORA-01403: no data found ORA-06512: at "SYS.DBMS_REGISTRY" (Doc ID 2887868.1)

Last updated on AUGUST 15, 2022

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.