My Oracle Support Banner

12.2 Upgrade fails with Error: "DBMS_STATS_INTERNAL ERRORS" AT CATDPB.SQL (Doc ID 2529919.1)

Last updated on OCTOBER 09, 2019

Applies to:

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

Symptoms

When upgrading database from 12.1 to 12.2, it fails at phase 109 with following error

Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at catctl.pl line 7822.
at catctl.pl line 7822.
main::catctlDie("\x{a}Unexpected error encountered in catconExec;
exiting\x{a} No such"...) called at catctl.pl line 4556
main::catctlExecutePhaseFiles(109, 1, undef, undef, undef) called at
catctl.pl line 1862

====Start of the ERROR in catupgrd0.log======

08:28:00 SQL> -- from catdpb.sql
08:28:00 SQL>
08:28:00 SQL> --
08:28:00 SQL> -- The global temp. table used by datapump import to store
statistics
08:28:00 SQL> -- information that will be used with dbms_stats.import... The
worker will load
08:28:00 SQL> -- statistics information into this table and then call the
dbms_stats package
08:28:00 SQL> -- to take the data in this table and create statistics.
08:28:00 SQL> --
08:28:00 SQL> BEGIN
08:28:00 2 DBMS_STATS.DROP_STAT_TABLE('SYS', 'IMPDP_STATS');
08:28:00 3 EXCEPTION
08:28:00 4 WHEN OTHERS THEN
08:28:00 5 IF SQLCODE = -20002 THEN
08:28:00 6 NULL;
08:28:00 7 ELSE
08:28:00 8 RAISE;
08:28:00 9 END IF;
08:28:00 10 END;
08:28:00 11 /
BEGIN
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_STATS_INTERNAL" has errors
ORA-06512: at line 8
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_STATS_INTERNAL"
ORA-06512: at "SYS.DBMS_STATS", line 627
ORA-06512: at line 2

================================

This is followed by other errors in upgrade log.

 

Changes

 Upgrading to 12.2.0.1

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.