SAP Knowledge Base Article - Preview

3067592 - Invalid objects during upgrade to oracle 19c

Symptom

In preparation for the oracle upgrade oracle to version 19c, the utlrp.sql script was executed according to SAP note 2800001 and it found many objects which are not recompiled:

OWNER OBJECT_NAME OBJECT_TYPE
PUBLIC X$KGLCLUSTER SYNONYM
SYS S$KSLECLASS VIEW
PUBLIC X$KSLECLASS SYNONYM
SYS S$KSUPR VIEW
PUBLIC X$KSUPR SYNONYM
SYS S$KSQEQ VIEW
PUBLIC X$KSQEQ SYNONYM
SYS S$TRACE VIEW
PUBLIC X$TRACE SYNONYM
SYS S$KSFDSTCG VIEW
PUBLIC X$KSFDSTCG SYNONYM
SYS S$KSFDSTCMP VIEW
SYS S$KSFDSTFILE VIEW
PUBLIC X$KSFDSTFILE SYNONYM
SYS S$KSFDSTBLK VIEW
PUBLIC X$KSFDSTBLK SYNONYM
SYS S$DNFS_CHANNELS VIEW
SYS S$KGSKCFT VIEW
SYS S$KGSKSCS VIEW
PUBLIC X$KGSKSCS SYNONYM
SYS S$KJBR VIEW
PUBLIC X$KJBR SYNONYM
SYS S$KJBL VIEW
SYS S$KJDRMAFNSTATS VIEW
PUBLIC X$KJDRMAFNSTATS SYNONYM
SYS S$KJDRMHVSTATS VIEW
PUBLIC X$KJDRMHVSTATS SYNONYM
SYS S$KJDRMREQ VIEW
PUBLIC X$KJDRMREQ SYNONYM
SYS S$DRM_HISTORY VIEW
SYS S$DRM_HISTORY_STATS VIEW
PUBLIC X$DRM_HISTORY_STATS SYNONYM
SYS S$KJZSIWTEVT VIEW
PUBLIC X$KJZSIWTEVT SYNONYM
SYS S$KRSTDEST VIEW
PUBLIC X$KRSTDEST SYNONYM
SYS S$KCRRASTATS VIEW
SYS S$KCLQN VIEW
PUBLIC X$KCLQN SYNONYM
SYS S$KCLCURST VIEW
PUBLIC X$KCLCURST SYNONYM
SYS S$KCLRCVST VIEW
PUBLIC X$KCLRCVST SYNONYM
SYS S$KCLDELTAST VIEW
PUBLIC X$KCLDELTAST SYNONYM
SYS S$LOGMNR_LOGS VIEW
PUBLIC X$LOGMNR_LOGS SYNONYM
SYS S$LOGMNR_PARAMETERS VIEW
PUBLIC X$LOGMNR_PARAMETERS SYNONYM
SYS S$LOGMNR_CONTENTS VIEW
PUBLIC X$LOGMNR_CONTENTS SYNONYM
SYS S$KRVXDTA VIEW
PUBLIC X$KRVXDTA SYNONYM
SYS S$LOGMNR_REGION VIEW
PUBLIC X$LOGMNR_REGION SYNONYM
SYS S$KCBVBL VIEW
PUBLIC X$KCBVBL SYNONYM
SYS S$KRCFH VIEW
PUBLIC X$KRCFH SYNONYM
SYS S$KRASGA VIEW
PUBLIC X$KRASGA SYNONYM
SYS S$KTSTSSD VIEW
PUBLIC X$KTSTSSD SYNONYM
SYS S$KTSSO VIEW
PUBLIC X$KTSSO SYNONYM
SYS S$KTSKSTAT VIEW
PUBLIC X$KTSKSTAT SYNONYM
SYS S$KGLOB VIEW
PUBLIC X$KGLOB SYNONYM
SYS S$KMMDP VIEW
SYS S$KMPCSO VIEW
PUBLIC X$KMPCSO SYNONYM
SYS S$KMPCMON VIEW
SYS S$KMPSRV VIEW
PUBLIC X$KMPSRV SYNONYM
SYS S$KXFPINSTLOAD VIEW
PUBLIC X$KXFPINSTLOAD SYNONYM
SYS S$RFMP VIEW
PUBLIC X$RFMP SYNONYM
SYS S$VINST VIEW
PUBLIC X$VINST SYNONYM
SYS S$RFAHIST VIEW
PUBLIC X$RFAHIST SYNONYM
SYS S$KEWMRMGMV VIEW
PUBLIC X$KEWMRMGMV SYNONYM
SYS S$KESWXMON VIEW
PUBLIC X$KESWXMON SYNONYM
SYS S$KESWXMON_PLAN VIEW
SYS S$KGLTABLE VIEW
SYS S$KGLBODY VIEW
PUBLIC X$KGLBODY SYNONYM
SYS S$KGLTRIGGER VIEW
PUBLIC X$KGLTRIGGER SYNONYM
SYS S$KGLINDEX VIEW
PUBLIC X$KGLINDEX SYNONYM
SYS S$KGLCLUSTER VIEW
SYS S$KGLCURSOR VIEW
PUBLIC X$KGLCURSOR SYNONYM
SYS S$KGLCURSOR_CHILD_SQLID VIEW
PUBLIC X$KGLCURSOR_CHILD_SQLID SYNONYM
SYS S$KGLCURSOR_CHILD_SQLIDPH VIEW
PUBLIC X$KGLCURSOR_CHILD_SQLIDPH SYNONYM
SYS S$KGLCURSOR_CHILD VIEW
PUBLIC X$KGLCURSOR_CHILD SYNONYM
PUBLIC X$DRM_HISTORY SYNONYM
PUBLIC X$KCRRASTATS SYNONYM
PUBLIC X$KSFDSTCMP SYNONYM
PUBLIC X$DNFS_CHANNELS SYNONYM
PUBLIC X$KGSKCFT SYNONYM
PUBLIC X$KJBL SYNONYM
PUBLIC X$KMMDP SYNONYM
PUBLIC X$KMPCMON SYNONYM
PUBLIC X$KGLTABLE SYNONYM
PUBLIC X$KESWXMON_PLAN SYNONYM


Read more...

Environment

upgrade to oracle 19

Keywords

KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.