My Oracle Support Banner

Upgrade : 19c Upgrade fails during execution of utlmmig.sql with "ORA-14501: object is not partitioned ORA-06512: at "SYS.DBMS_STATS"" (Doc ID 2885990.1)

Last updated on OCTOBER 29, 2022

Applies to:

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

Symptoms

Upgrade to 19c fails with the below errors reported in catupgrd_timestamp_instance_0.log log file.

13:28:29 SQL> EXECUTE sys.dbms_stats.gather_table_stats('SYS', 'AW$')
BEGIN sys.dbms_stats.gather_table_stats('SYS', 'AW$'); END;

*
ERROR at line 1:
ORA-14501: object is not partitioned
ORA-06512: at "SYS.DBMS_STATS", line 40799
ORA-06512: at "SYS.DBMS_STATS", line 40083

...

13:28:30 SQL> EXECUTE sys.dbms_stats.gather_table_stats('SYS', 'AW_OBJ$')
BEGIN sys.dbms_stats.gather_table_stats('SYS', 'AW_OBJ$'); END;

*
ERROR at line 1:
ORA-14501: object is not partitioned
ORA-06512: at "SYS.DBMS_STATS", line 40799
ORA-06512: at "SYS.DBMS_STATS", line 40083

...

13:44:13 264 --
13:44:13 265 -- Delete any previous entry that may have been stored in
13:44:13 266 -- sys.props$ table.
13:44:13 267 --
13:44:13 268 b_Props := sys.dbms_registry_sys.delete_props_data(c_POSTUPGRADE);
13:44:13 269 IF (b_Props) THEN
13:44:13 270 sys.dbms_output.put_line('catrequtlmg: delete_props_data: Success');
13:44:13 271 ELSE
13:44:13 272 sys.dbms_output.put_line('catrequtlmg: delete_props_data: No Props Data');
13:44:13 273 END IF;
13:44:13 274
13:44:13 275 end;
13:44:13 276 /
sPrvVersion = 12.1.0.2.0 nPrevMajorVer = 12
sRetFunc = ?/rdbms/admin/utlmmig.sql
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 40799
ORA-06512: at "SYS.DBMS_STATS", line 40083

...

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

Start of Trace Message
------------------------------------------------------

Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at <19c ORACLE HOME>/rdbms/admin/catctl.pl line 9252.
at <19c ORACLE HOME>/rdbms/admin/catctl.pl line 9252.



Changes

The way upgrade works with many Base Tables especially AWR related is by Creating an intermediate Temporary Table with newer modifications(Columns,Data Types or other Changes etc) , Then making use of the Temporary Table to hold all data from original table and renaming the Temporary Table to be the new Base Table.
The original table is then dropped , Once the changes in the new Base Table is finalized.

This can be verified via c1102000.sql
 

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!


In this Document
Symptoms
Changes
Cause
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.