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.