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 APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation 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 |