Re: hcheck error 19c upgrade

Posted by ErmanArslansOracleBlog on Mar 24, 2022; 8:01am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/hcheck-error-19c-upgrade-tp10755p10795.html

Okay. So your registry components seem VALID now. Good.

You should review the names and errors of those invalid object one by one Raiq..
You sent me the upgrade log but what I can see there is just the counts of the invalid objects..

So now you upgraded your database successfully but you have some concerns because you have some invalids in the standard schemas, right?

As I said above, you should review the errors preventing those objects to be compiled properly.. According to your findings, a patch may be needed, or an action may be required.. In some cases, taking one action fixes multiple invalids..

Count of Invalids by Schema
======================================================


OWNER        OBJECT_TYPE                                COUNT(*)
------------ ---------------------------------------- ----------
APPS         FUNCTION                                          2
APPS         MATERIALIZED VIEW                                 1
APPS         PACKAGE                                          18
APPS         PACKAGE BODY                                    356
APPS         PROCEDURE                                         2
APPS         VIEW                                            243
APPSRO       SYNONYM                                         221
XXBLABLA     MATERIALIZED VIEW                                 3
XXBLABLA     PROCEDURE                                         4