oracle database manual upgrade failed with below error

Issue:
oracle database manual upgrade failed with below error 

when I tried to upgrade oracle database to 11.2.0.4  had issues during the upgrade.

catupgrade ran almost  70% and come out from the SQL prompt and trowed the below error.



catupgrad failed with below error.


RROR at line 1:
ORA-04063: package body "SYS.DBMS_STATS_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_STATS_INTERNAL"
ORA-06512: at "SYS.DBMS_STATS", line 385
ORA-06512: at line 2



Solution:

when I check with oracle and they suggested us to validate these packages and re-run the catupgrade again.



drop table sys.WRI$_OPTSTAT_SYNOPSIS$;

create table wri$_optstat_synopsis$
( bo# number not null,
group# number not null,
intcol# number not null,
hashvalue number not null
) partition by range(bo#)
subpartition by hash(group#)
subpartitions 32
(
partition p0 values less than (0)
)
tablespace sysaux
pctfree 1
enable row movement;
descr sys.WRI$_OPTSTAT_SYNOPSIS$

--- check if the desc command shows:
Name Null? Type
----------------------------------------- -------- ----------------------------
BO# NOT NULL NUMBER
GROUP# NOT NULL NUMBER
INTCOL# NOT NULL NUMBER
HASHVALUE NOT NULL NUMBER

catalog
catproc
@?/rdbms/admin/prvtstas.plb
@?/rdbms/admin/prvtstat.plb