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!

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

Timo Hahn

***Moderator note (Timo): Vladimir

Please don't just answer by giving a link. Provide some more information on how you think the link will help to solve the problem. The Oracle Community – General FAQ state:

I have an excellent blog entry that answers a very complex user question. Can I just post a link as the answer?

Unfortunately, a link is not an answer. It’s a location of relevant and correct material to answer the question. And while the link to the blog is probably very useful, it will be flagged for review by the system moderators who are dedicated to ensuring the Community Platform is not susceptible to spam or any forms of promotion.

The best approach is always to “Answer in the Discussion” and in this case, that would mean providing enough content to address the question and answer it completely--if not in absolute detail at least to the extent that it achieves content correctness. Additional resources such as links to relevant and correct material can be offered as “for more information” or further explanation, but the answer should be complete. If an external blog entry is being linked, please provide a substantive quote from the blog entry to add context for users.

***

1 - 2

Post Details

Added on Sep 7 2021
20 comments
2,990 views