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.
SAP Knowledge Base Article - Preview