APEX Upgrade fails with ORA-01775: looping chain of synonyms (Doc ID 2964624.1)

Last updated on JULY 31, 2023

Applies to:

Symptoms

Trying to upgrade from APEX 21.1.0 to APEX 23.1
Not using the database with Multitenant Architecture

Installation fails as below
ok 5 - Installing Package Specs (Runtime) | 0,97
ok 6 - Installing Package Bodies (Runtime) | 0,65
not ok 7 - Recompiling APEX_230100 | 1,25
# Message: PL/SQL: SQL Statement ignored
# Statement: PACKAGE BODY APEX_230100.WWV_DATA_PKG_INT, Line 482/13
# Message: PL/SQL: ORA-01775: looping chain of synonyms
# Statement: PACKAGE BODY APEX_230100.WWV_DATA_PKG_INT, Line 540/22
# Message: PL/SQL: SQL Statement ignored
# Statement: PACKAGE BODY APEX_230100.WWV_DATA_PKG_INT, Line 543/13
# Message: PL/SQL: ORA-01775: looping chain of synonyms
# Statement: PACKAGE BODY APEX_230100.WWV_DATA_PKG_INT, Line 605/22
ok 8 - Creating Instance Parameter Defaults | 0,00
ok 9 - Loading PDF font data | 0,98
ok 10 - Installing Page Designer Metadata | 0,13
ok 11 - Inherit Privileges | 0,00
not ok 1 - 10 actions passed, 1 actions failed | 4,67
begin
*
ERROR at line 1:
ORA-20001: Install errors found in phase 1, see "not ok" messages above for details.
ORA-06512: at "APEX_230100.WWV_INSTALL_API", line 467
ORA-06512: at line 5

Changes

 Trying to upgrade APEX from lower environment ( APEX 21.1 )

Cause

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