My Oracle Support Banner

Upgrade To Apex 22.2 On A 4k Block_size 19c Database Fails With Sql Errors (Doc ID 3026308.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Goal

On : 19.14.2.0.0 version, RDBMS

Upgrade to Apex 22.2 on a 4k block_size 19c database fails with sql errors

When upgrading Apex to version 22.2 on a 4k block_size 19c database the installation fails with sql errors.

Doc ID 2808568.1, he nls_length_semantics is set to byte. Is there another fix/workaround without recreating the database in 8k or higher block size?


ORA-20001: Install errors found in phase 1, see "not ok" messages above for details.
ORA-06512: at "APEX_220200.WWV_INSTALL_API", line 467
ORA-06512: at line 5
# Message: ORA-01450: maximum key length (3117) exceeded
# Statement: create index wwv_task_def_due_ix on wwv_flow_task_defs(due_on_interval, expiration_policy) compress
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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