SAP Knowledge Base Article - Preview

2199300 - Invalid objects after upgrade to 12c/18c/19c

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

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

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.