invalid objects when upgrading the database from 12c to 19c on Oracle ERP 12.2.11

Mar 21, 2023 6:44PM

Hi experts,

I am running an upgrade from my ebs system Oracle EBS 12.2.11 from a 12c (12.1.0.2) into 19c (19.17.0.0)

I am using the documentation 2552181.1. I am on section 2.4 - After the database upgrade. On subsession 3 - Compile invalid objects, I ran the:

$ export ORACLE_SID=<source SID>

$ sqlplus "/ as sysdba" @$ORACLE_HOME/rdbms/admin/utlrp.sql

The result is:

OBJECTS WITH ERRORS

62

ERRORS DURING THE RECOMPILATION

0

SQL> select count(*) from dba_objects where status='INVALID';

COUNT(*)

----------

62

Should I resolve these invalid objects before move on further into the documentation ?

If so, how should I do it, once the utlrp.sql couldn't/didn't solve this ?

Database Install/Upgrade/Opatch (MOSC)