Hello,

-MDSYS.SDO_GEOM and MDSYS.SDO_CS packages are not present in the database
-MDSYS.SDO_GEOMETRY data type was present, that's why the check was positive
I dropped the MDSYS.SDO_GEOMETRY data type and the installation finished without problems.

Thank you very much for your help.

Hi,
great that things are working now.
Just one remark. Oracle Spatial no longer requires a separate license; so from a licensing point of view there is no need any more to remove Oracle Spatial from the database.
Best regards
-Carsten

Hello
i got the same issue but we are using oracle spatial MDSYS.SDO_GEOM .
Any workaround ?

Hi,
when you're using the MDSYS.SDO_GEOM package, then you should also have the SDO_GEOMETRY data type available, as SDO_GEOM uses that data type in its signatures. And then, you should also have the SDO_CS package, as this is part of Oracle Locator (SDO_CS was always part of Locator, even when Oracle Spatial required a license).
Are you having the same errors as described above - is the SDO_CS package missing in your database?
SDO_CS is normally installed together with SDO_GEOMETRY and SDO_GEOM. So why is it missing in your database? Has it intentionally been dropped? If yes, why?
The workaround would be to rectify the Locator / Spatial installation in your database.
Best regards
-Carsten

here the message :
not ok 2 - 312 actions passed, 1 actions failed | 19.97
begin
*
ERROR at line 1:
ORA-20001: Install errors found in phase 2, see "not ok" messages above for
details.
ORA-06512: at "APEX_210100.WWV_INSTALL_API", line 465
ORA-06512: at line 8

I got the datatype , and package of oracle spatial mentionned in your answer.

Hi,
this log snippet is insufficient - it only tells us that there have been errors. Can you either look up the section with the detailed message or share the complete log here?
regards
-Carsten

first thank you for helping.
The log is big here the error
not ok 281 - Upgrade Before Enabling Constraints | 0.50

Message: ORA-01422: exact fetch returns more than requested number of rows

Statement:

ok 282 - Enabling Constraints/Triggers | 0.32
ok 283 - Upgrade Metadata (2) | 0.00
ok 284 - Upgrade with enabled constraints | 2.23

Message: PERF: Statement took 2.03 min

Statement:

declare

c_old_import_in_progress constant boolean := wwv_flow.g_im

port_in_progress;

begin

wwv_flow_api.set_security_group_id(11);

wwv_flow.g_import_in_progress := true;

-- Remove Database Applications

for c1 in (select id

from wwv_flows

where security_group_id = 11

and id >= 7000 and id < 8000

or id in (8950,8951) ) loop

--

wwv_flow_api.remove_application( c1.id );

end loop;

-- Remove Templates

for c1 in (select id

from wwv_flows

where security_group_id = 11

and id >= 8801 and id < 8900 ) loop

--

wwv_flow_api.remove_application( c1.id );

end loop;

-- Remove Websheet Applications

for c2 in (select id

from wwv_flow_ws_applications

where security_group_id = 11

and id in (1097894920371103914,1097895031667

104017. ) loop

--

wwv_flow_api.remove_ws_app( c2.id );

wwv_flow_ws_import_api.remove_ws_components( c2.id );

end loop;

commit;

wwv_flow.g_import_in_progress := c_old_import_in_progress;

end;

ok 285 - Recompiling APEX_210100 schema | 0.70
ok 286 - Configuring Restricted Schemas | 0.00
ok 287 - Upgrading ACL | 0.02
ok 288 - Installing 4411 | 0.92
ok 289 - Installing 4155 | 0.05
ok 290 - Installing Internal Themes | 0.77
ok 291 - Installing 4000 | 6.17
ok 292 - Installing 4020 | 0.45
ok 293 - Installing 4350 | 0.62
ok 294 - Installing 4050 | 0.87
ok 295 - Installing 4550 | 0.05
ok 296 - Installing 4600 | 0.28
ok 297 - Installing 4650 | 0.15
ok 298 - Installing 4700 | 0.08
ok 299 - Installing 4750 | 0.07
ok 300 - Installing 4500 | 1.35
ok 301 - Installing 4300 | 0.12
ok 302 - Installing 4900 | 0.48
ok 303 - Installing 4850 | 0.27
ok 304 - Resetting Internal Authentication | 0.00
ok 305 - Installing Dictionary View Metadata | 0.00
ok 306 - Installing Advisor Metadata | 0.02
ok 307 - Updating App Owner/Version | 0.00
ok 308 - Updating Plug-in settings of Applications | 0.00
ok 309 - Update Plug-In Settings of Applications | 0.00
ok 310 - Copying Instance settings | 0.00
ok 311 - Copying Instance Settings | 0.03
ok 312 - Enabling WS Constraints | 0.25
ok 313 - Dropping Upgrade Triggers in APEX_040200 | 0.07
not ok 2 - 312 actions passed, 1 actions failed | 19.97
begin
*
ERROR at line 1:
ORA-20001: Install errors found in phase 2, see "not ok" messages above for
details.
ORA-06512: at "APEX_210100.WWV_INSTALL_API", line 465
ORA-06512: at line 8

Hi,
OK - this looks like a completely different issue and not related to Spatial or SDO_GEOMETRY.
Can you send the full log privately to me ...? Either as a PM in the forum, or by email: {firstname}.{lastname}<at>oracle.com.
Best regards
-Carsten

Hi,
When I try to install Apex version 21.2 in my database, I got this error:
I try to install 22.1 or 22.2, and it returns de same error.
The database version is:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0

Thanks

This is a different error; it looks like JSON functionality is not available in your database, although it's a 19c one. How is the COMPATIBLE parameter set?

Thanks for the quick reply Carsten,
Does this tell you something or you need anything else?
Regards

Hi,
that actually looks good. Based on the installation error, there is a problem with the JSON_OBJECT function in your database.
Do you have the PL/JSON open source package installed in your database, by chance?
Can you run the following query and see whether it works?

SQL> select json_object( 'dt' value sysdate) from dual;

JSON_OBJECT('DT'VALUESYSDATE)
--------------------------------------------------------------------------------
{"dt":"2022-11-22T14:36:29"}

1 row selected.

How can I know if it is installed?
It returns the following:

Thanks

hmmm ... also looks good.
let's check on the synonyms, as the original error was about synonyms: What does this query return?

select owner, synonym_name, table_owner, table_name from dba_synonyms where synonym_name ='JSON_OBJECT';

regards
-Carsten

Returns the following:
"No row selected"

Thanks

hmmm ... I have to say that I'm running out of ideas now.
I never have seen that error before. I suspect something's not right with your database, whatever it is. Based on the error positions from the Installation Screen you have posted before, there is an issue with the JSON_OBJECT function which one of the APEX packages uses.
The only recommendation I have would be to look whether the database contains a non-Oracle object named JSON_OBJECT, which would collide with the built-in one.

select owner, object_name, object_type from dba_objects where object_name = 'JSON_OBJECT'

If that all does not help, I'm afraid I have no idea - the only remaining option then is to file a ticket with Oracle support and to investigate the issue from there.
regards
-Carsten

Perfect Carsten, thanks for your help.
Let`s see if we can solve it.
Best Regards

Iosu

Hi I got the exact same error while installation can you please tell me how did you resolve this thank you in advance

hi Carsten,

I got this error during installation:

not ok 281 - Upgrade Before Enabling Constraints | 0.12

Message: ORA-01422: exact fetch returns more than requested number of rows

Statement:

Message: ORA-01422: exact fetch returns more than requested number of rows

Statement:

Message: ORA-01422: exact fetch returns more than requested number of rows

Statement:

Message: ORA-01422: exact fetch returns more than requested number of rows

Statement:

not ok 2 - 312 actions passed, 1 actions failed | 6.30
begin
*
ERROR at line 1:
ORA-20001: Install errors found in phase 2, see "not ok" messages above for
details.
ORA-06512: at "APEX_210100.WWV_INSTALL_API", line 465
ORA-06512: at line 8

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics

can you please help.