Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error During Installation of APEX 21.3, ORA-06512: at "APEX_210100.WWV_INSTALL_API", line 465

User_LELD2Sep 7 2021

My database is:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
(Recently patched with the latest update)
Dear all,
I am getting the following error during my installation of APEX 21.3

Errors found. Drop APEX_210100 before re-starting the installation.

# Actions in Phase 1:

ok 1 - BEGIN | 0.00
ok 2 - Creating APEX_GRANTS_FOR_NEW_USERS_ROLE | 0.02
ok 3 - Creating SYS Objects | 0.00
ok 4 - Creating APEX Tables | 0.22
ok 5 - Installing Package Specs (Runtime) | 0.33
ok 6 - Installing Package Bodies (Runtime) | 0.37
ok 7 - Dev Grants | 0.00
ok 8 - Creating Dev-Only Tables and Triggers | 0.00
ok 9 - Installing Package Specs (Dev) | 0.08
ok 10 - Installing Views (Dev) | 0.03
ok 11 - Installing Package Bodies (Dev) | 0.08
not ok 12 - Recompiling APEX_210100 | 0.52

Message: PL/SQL: Statement ignored

Statement: PACKAGE BODY APEX_210100.WWV_FLOW_MAP_REGION, Line 2036/21

Message: PLS-00201: identifier 'MDSYS.SDO_CS' must be declared

Statement: PACKAGE BODY APEX_210100.WWV_FLOW_MAP_REGION, Line 2037/44

Message: PL/SQL: Statement ignored

Statement: PACKAGE BODY APEX_210100.WWV_FLOW_MAP_REGION, Line 2051/25

Message: PLS-00201: identifier 'MDSYS.SDO_GEOM' must be declared

Statement: PACKAGE BODY APEX_210100.WWV_FLOW_MAP_REGION, Line 2051/43

Message: PL/SQL: Statement ignored

Statement: PACKAGE BODY APEX_210100.WWV_FLOW_MAP_REGION, Line 2619/29

Message: PLS-00201: identifier 'MDSYS.SDO_CS' must be declared

Statement: PACKAGE BODY APEX_210100.WWV_FLOW_MAP_REGION, Line 2620/52

ok 13 - Creating APEX$ objects in APEX_210100 | 0.02
ok 14 - Creating Instance Parameter Defaults | 0.00
ok 15 - Loading PDF font data | 0.60
ok 16 - Installing Page Designer Metadata | 0.07
ok 17 - Inherit Privileges | 0.00
not ok 1 - 16 actions passed, 1 actions failed | 2.33
begin
*
ERROR at line 1:
ORA-20001: Install errors found in phase 1, see "not ok" messages above for
details.
ORA-06512: at "APEX_210100.WWV_INSTALL_API", line 465
ORA-06512: at line 5

Would love some help.

This post has been answered by Carsten Czarski-Oracle on Sep 8 2021
Jump to Answer

Comments

Processing

Post Details

Added on Sep 7 2021
20 comments
2,967 views