Symptom
You upgrade your database to 18c or 19c and during the post steps you see several invalid objects, in a list similar to the one bellow:
SYS VIEWS
SYS.S$KDMUSEGDICT (VIEW)
SYS.S$KDMUSEGDICTPMAP (VIEW)
SYS.S$KDMUSEGDICTSO (VIEW)
SYS.S$KDMUSEGDICTVER (VIEW)
SYS.S$KEWCATPDBINSNAP (VIEW)
SYS.S$KEWPDBIX (VIEW)
SYS.S$KEWRCACHE (VIEW)
SYS.S$KFCSTAT (VIEW)
SYS.S$KJZSIWTEVT (VIEW)
SYS.S$KSLECLASS (VIEW)
SYS.S$KSLSESOUT (VIEW)
SYS.S$KSWSJPTAB (VIEW)
SYS.S$MESSAGE_CACHE (VIEW)
PUBLIC SYNONYMS
PUBLIC.X$KDMUSEGDICT (SYNONYM)
PUBLIC.X$KDMUSEGDICTPMAP (SYNONYM)
PUBLIC.X$KDMUSEGDICTSO (SYNONYM)
PUBLIC.X$KDMUSEGDICTVER (SYNONYM)
PUBLIC.X$KEWCATPDBINSNAP (SYNONYM)
PUBLIC.X$KEWPDBIX (SYNONYM)
PUBLIC.X$KEWRCACHE (SYNONYM)
PUBLIC.X$KFCSTAT (SYNONYM)
PUBLIC.X$KJZSIWTEVT (SYNONYM)
PUBLIC.X$KSLECLASS (SYNONYM)
PUBLIC.X$KSLSESOUT (SYNONYM)
PUBLIC.X$KSWSJPTAB (SYNONYM)
PUBLIC.X$MESSAGE_CACHE (SYNONYM)
Read more...
Environment
- Any SAP system
- Oracle as of 18c
Product
Keywords
upgrade 18C upgradation update object incomplete invalid object , KBA , BC-DB-ORA , Oracle , BC-CCM-MON-ORA , Database Monitors for Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview