Re: hcheck error 19c upgrade

Posted by raiq1 on Mar 22, 2022; 11:16am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/hcheck-error-19c-upgrade-tp10755p10791.html

Hi Erman sir,

i have raised a SR to validate spatial , they have found the synonyms on standard MDSYS objects.

As per support those synonyms should not be there. total 226 synonyms are there and most of them are
APPSRO schema.

Below are the action plan given to oracle.



Drop all the objects returned by the select below:

SELECT OBJECT_NAME,OBJECT_TYPE,OWNER FROM DBA_OBJECTS WHERE OBJECT_NAME in
(Select OBJECT_NAME from DBA_OBJECTS where owner='MDSYS') and owner not in('MDSYS','PUBLIC');

After they are dropped run:

connect / as sysdba
spool spatial_installation.lst
@?/md/admin/mdinst.sql
spool off

After followed the action plan and dropped all 226 synonyms and ran mdinst.sql script, spatial became valid.

after that completed dbugrade manually through command line.

dbugrade -R

it has started the dbugrade from where it has stopped but issue is still lot of invalid objects.

sending the log file to you.

please check and advice.

Regards,
raiqdb_upg_diag_TEST_22_Mar_2022_0909.log