Symptom
You upgrade your database to 12c and during the post steps you see several invalid objects, in a list similar to the one bellow:
SYS VIEWS
S$DNFS_CHANNELS
S$DRM_HISTORY
S$DRM_HISTORY_STATS
S$KCLDELTAST
S$KESWXMON
S$KESWXMON_PLAN
S$KEWMRMGMV
S$KFGBRS
S$KFGMG
S$KGSKCFT
S$KGSKSCS
S$KJBL
S$KJDRMAFNSTATS
S$KJDRMHVSTATS
S$KJDRMREQ
S$KMMDP
S$KMPCMON
S$KMPCSO
S$KMPSRV
S$KRASGA
S$KRCFH
S$KRSTDEST
S$KRVXDTA
S$KSFDSTBLK
S$KSQEQ
S$KSUPR
S$KTSSO
S$KTSTSSD
S$RFMP
PUBLIC SYNONYMS
X$DNFS_CHANNELS
X$DRM_HISTORY
X$DRM_HISTORY_STATS
X$KCLDELTAST
X$KESWXMON
X$KESWXMON_PLAN
X$KEWMRMGMV
X$KFGBRS
X$KFGMG
X$KGSKCFT
X$KGSKSCS
X$KJBL
X$KJDRMAFNSTATS
X$KJDRMHVSTATS
X$KJDRMREQ
X$KMMDP
X$KMPCMON
X$KMPCSO
X$KMPSRV
X$KRASGA
X$KRCFH
X$KRSTDEST
X$KRVXDTA
X$KSFDSTBLK
X$KSQEQ
X$KSUPR
X$KTSSO
X$KTSTSSD
X$RFMP
For 12.2 the below objects might as well be affected:
SYS VIEWS
S$KCLQN
S$KXFPINSTLOAD
S$KCBVBL
PUBLIC SYNONYM
X$KCLQN
X$KXFPINSTLOAD
X$KCBVBL
Read more...
Environment
- Any SAP system
- Oracle 12c
Product
Keywords
upgrade 12c 12.1.0.2 upgradation update object incomplete , 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.