E-ORA SYS.DBMS_STATS has errors ORA-06508: PL/SQL: could not find program unit being called: SYS.DBMS_STATS

While doing PeopleTools upgrade via Change Assistant, you may encounter this error: E-ORA SYS.DBMS_STATS has errors ORA-06508: PL/SQL: could not find program unit being called: SYS.DBMS_STATS

The error message is indicative enough to suggest that there are invalid dba_objects. To make sure, run the below command:

SQL> select owner, object_name, object_type, status from dba_objects where object_name = 'DBMS_STATS';

The output message is indicative enough

Now you have two options here to resolve the issue ORA-06508: PL/SQL: could not find program unit being called: SYS.DBMS_STATS:

1. Go to the dms MSGTLSUPG and add the below line this line at the beginning of the dms:

SET STATISTICS OFF;

2. Execute the following steps to resolve the issue:

cd $OH/rdbms/admin

sqlplus /nolog

SQL> connect / as sysdba
SQL> set pages 0
SQL> spool x
SQL> @prvtstas.plb
SQL> desc sys.dbms_stats_internal
SQL> @prvtstat.plb
SQL> select * from dba_errors;
SQL> exit