File icxr12fi.sql Fails During Upgrade to R12.1 (Doc ID 1082681.1)

Last updated on AUGUST 23, 2017

Applies to:

Oracle iProcurement - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
**Checked for relevance on 13-Dec-2011***


Symptoms

During an upgrade to Release 12.1.x, the upgrade patch driver fails when attempting to process the file icxr12fi.sql.

sqlplus -s APPS/***** @/u01/oracle/dev/apps/apps_st/appl/icx/12.0.0/patch/115/sql/icxr12fi.sql
DECLARE
*
ERROR at line 1:
ORA-20000: icxr12fi.sql(100): ORA-20000: Exception at
ICX_CAT_R12_UPGRADE_PVT.callICXFinalSteps(1400), ORA-20000: Exception at
ICX_CAT_R12_UPGRADE_PVT.createCtxDomainIndex(600), ORA-20000: Exception at
ICX_CAT_INTERMEDIA_INDEX_PVT.create_index(1800): ORA-20000: Exception at
ICX_CAT_INTERMEDIA_INDEX_PVT.create_index(1800): ORA-29855: error occurred in
the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10754: memory size must be between 1024 and 2097152000
ORA-06512: at line 19

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms