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!

Oracle APEX 22.1 installer - @apexins.sql error inside core/tab.sql

Andrzej Pauli-OracleMay 8 2022 — edited May 8 2022

When running @apexins.sql on freshly created PDB I see error:

Timing command is obsolete.

# Inherit Privileges

Timing command is obsolete.
...apxsqler_exit.sql
Errors found. Drop APEX_220100 before re-starting the installation.

# Actions in Phase 1:

ok 1 - BEGIN | 0.00
ok 2 - Creating APEX_GRANTS_FOR_NEW_USERS_ROLE | 0.00
ok 3 - Creating SYS Objects | 0.02
not ok 4 - Creating APEX Tables | 0.22

Message: ORA-01735: invalid ALTER TABLE option

Statement: alter table wwv_flow_task_def_actions add constraint wwv_task_def_act_uk unique (task_def_id, name) using index compress 2

alter table wwv_flow_task_def_actions add constraint wwv_task_def_act_ws_mod_ck

check ( web_src_module_id is null or web_src_operation_id is null )

ok 5 - Installing Package Specs (Runtime) | 0.42

ok 6 - Installing Package Bodies (Runtime) | 0.27
ok 7 - Dev Grants | 0.00

This is stopping the whole installation for me (on DB 19c)
Looks like it is caused by core/tab.sql alter table (line 16512):
alter table wwv_flow_task_def_actions add constraint wwv_task_def_act_uk unique (task_def_id, name) using index compress 2
This is the fix IMVHO (but might wrong) in formof diff patch:

--- core/tab.sql 2022-05-08 14:01:26.894854550 +0000
+++ core/tab.sql 2022-05-08 14:01:47.637864851 +0000
@@ -16509,8 +16509,8 @@
)
lob (action_clob) store as (cache reads enable storage in row)
/
-alter table wwv_flow_task_def_actions add constraint wwv_task_def_act_uk unique (task_def_id, name) using index compress 2
-
+alter table wwv_flow_task_def_actions add constraint wwv_task_def_act_uk unique (task_def_id, name) using index compress
+/
alter table wwv_flow_task_def_actions add constraint wwv_task_def_act_ws_mod_ck
check ( web_src_module_id is null or web_src_operation_id is null )
/

Comments

EdStevens
cayenne wrote:
Hi Folks,
I just cannot seem to find anything readily in MOS at Oracle...

I understand that these days, the patches they put out are no longer just fixes to pieces of the database, but for some reason, they are now full blown installs.

So, rather than download from OTN and install and then have to patch...I'd rather go to MOS and download the patch and install that as my fresh database install.

My trouble is, I can't find the darned thing looking through the patch area, without knowing the patch number..etc.
I feel your pain and really can't offer any advice on that. Searching for patches has been a continual source of frustration for me.
What do ya'll do when wanting to find the latest version for a fresh install?

A further question..how are ya'll treating this new patch paradigm where they seem to expect you to do fresh installs just to patch up a level? Do you all have the resources to do a new install and migrate over...or do you migrate in place which the documentation seems to warn your off from doing?
Once you download the patch/full install and unzip it, look for the 'readme' files. The installer should detect or ask if you are doing a patch and handle the 'upgrade' conversion for you. At least it does when upgrading Grid Infrastructure. I'll find out about databases next week. ;-)

>
Thanks in advance,

cayenne
Srini Chavali-Oracle
Pl see these MOS Docs

Quick Reference to RDBMS Database Patchset Patch Numbers [ID 753736.1]
Quick Reference To Patch Numbers For Database PSU, SPU(CPU) And Bundle Patches [ID 1454618.1]

There are advantages to an out-of-place upgrade - you can install the software while the instance is up and running, thus limiting your downtime. It also allows for a quick downgrade if that should ever be needed.

Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1]

HTH
Srini
Helios-GunesEROL
Hi;

Please also refer:
Oracle Recommended Patches -- Oracle Database [ID 756671.1]
NOTE:430449.1 - How to find DB Patches for the Microsoft Windows platforms My Oracle Support

Regard
Helios
1 - 3

Post Details

Added on May 8 2022
7 comments
467 views