My Oracle Support Banner

Upgrade to 12.2 fails with ORA-14501: object is not partitioned,ORA-06512: at “SYS.DBMS_STATS” & ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions (Doc ID 2433233.1)

Last updated on AUGUST 15, 2018

Applies to:

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

Symptoms

Upgrade from 12.1.0.1 SE to 12.2.0.1 SE fails with the below errors,while running catrequtlmg Script in Gather Stats(Post Upgrade Phase) –

catrequtlmg: b_StatEvt = TRUE
catrequtlmg: b_SelProps = FALSE
catrequtlmg: b_UpgradeMode = TRUE
catrequtlmg: b_InUtlMig = TRUE
catrequtlmg: Deleting table stats
catrequtlmg: Gathering Table Stats OBJ$MIG
declare
*
ERROR at line 1:
ORA-14501: object is not partitioned
ORA-06512: at “SYS.DBMS_STATS”, line 36873
ORA-06512: at “SYS.DBMS_STATS”, line 36507
ORA-06512: at “SYS.DBMS_STATS”, line 35428
ORA-06512: at “SYS.DBMS_STATS”, line 14814
ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 22757
ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 22749
ORA-06512: at “SYS.DBMS_STATS”, line 14478
ORA-06512: at “SYS.DBMS_STATS”, line 14615
ORA-06512: at “SYS.DBMS_STATS”, line 35378
ORA-06512: at “SYS.DBMS_STATS”, line 36230
ORA-06512: at “SYS.DBMS_STATS”, line 36716
ORA-06512: at line 145

It might also fail with the below error,causing XDB Component to go INVALID-
10:09:28 SQL> begin
10:09:28 2 DBMS_STATS.GATHER_TABLE_STATS (ownname => ‘XDB’, tabname => ‘XDB$RESOURCE’);
10:09:28 3 end;
10:09:28 4 /
begin
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06512: at “SYS.DBMS_STATS”, line 36873
ORA-06512: at “SYS.DBMS_STATS”, line 36507
ORA-06512: at “SYS.DBMS_STATS”, line 35428
ORA-06512: at “SYS.DBMS_STATS”, line 14814
ORA-14300: partitioning key maps to a partition outside maximum permitted
number of partitions
ORA-06512: at “SYS.DBMS_STATS”, line 1704
ORA-06512: at “SYS.DBMS_STATS”, line 14485
ORA-06512: at “SYS.DBMS_STATS”, line 14615
ORA-06512: at “SYS.DBMS_STATS”, line 35378
ORA-06512: at “SYS.DBMS_STATS”, line 36230
ORA-06512: at “SYS.DBMS_STATS”, line 36716
ORA-06512: at line 2

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.