Re: 19c upgrade with EBS 12.1.3 environment

Posted by ErmanArslansOracleBlog on Feb 04, 2022; 7:34am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/19c-upgrade-with-EBS-12-1-3-environment-tp10619p10620.html

Yes you have 1 error and some warning there.
The documents to follow for getting rid of those errors are already written in the trace, so you should follow those documents.

for instance;

FAIL
HCKE-0003: SOURCE$ for OBJ# not in OBJ$ (Doc ID 1360233.1)
SOURCE$ has 283 rows for 22 OBJ# values not in OBJ$

Doc 1360233.1 says the following;

The dictionary SYS.SOURCE$ table has orphaned rows in it.
        The message tells displays how many orphan rows for how many
        distinct object ids do not exist in SYS.OBJ$.

--> The only real impact is wasted space in the SYSTEM tablespace
        for those SOURCE$ rows.

We don't expect to see it in 11.2.0.4.. Probably there are some recrods still in SOURCE$ but they are not in OBJ$.. This seems related with a database bug.

I think that's ignorable, but you are about upgrade your database, so you can't take that risk.

In these types of situation, you should create a SR and upload the trace and tell them "I see 1 error and some warnings in the trace, I think they are ignorable, please approve if that's the case.. but if you don't think I should ignore these error and warnings, please send me an action plan asap"