SAP Knowledge Base Article - Preview

2783937 - Invalid Oracle objects for *HIVE* views after 18c upgrade

Symptom

After completing the 18c upgrade and when applying SBP, catsbp script can not finish successfully due to invalid object as follow.
They cannot be recompiled using the utlrp.sql.

SQL> select owner,object_type,object_name from dba_objects where status != 'VALID';

OWNER OBJECT_TYPE OBJECT_NAME
-------------------- ----------------------- ------------------------------
SYS VIEW DBA_HIVE_TABLES
SYS VIEW USER_HIVE_TABLES
SYS VIEW ALL_HIVE_TABLES
SYS VIEW DBA_HIVE_COLUMNS
SYS VIEW USER_HIVE_COLUMNS
SYS VIEW ALL_HIVE_COLUMNS
SYS VIEW DBA_HIVE_DATABASES
SYS VIEW USER_HIVE_DATABASES
SYS VIEW ALL_HIVE_DATABASES
PUBLIC SYNONYM DBA_HIVE_TABLES
PUBLIC SYNONYM USER_HIVE_TABLES
PUBLIC SYNONYM ALL_HIVE_TABLES
PUBLIC SYNONYM DBA_HIVE_COLUMNS
PUBLIC SYNONYM USER_HIVE_COLUMNS
PUBLIC SYNONYM ALL_HIVE_COLUMNS
PUBLIC SYNONYM DBA_HIVE_DATABASES
PUBLIC SYNONYM USER_HIVE_DATABASES
PUBLIC SYNONYM ALL_HIVE_DATABASES


Read more...

Environment

  • Oracle 18c
  • HPUX, AIX

Product

SAP ERP 6.0

Keywords

18c, Invalid Objects, DBA_HIVE_TABLES, USER_HIVE_TABLES, ALL_HIVE_TABLES, DBA_HIVE_COLUMNS, USER_HIVE_COLUMNS, ALL_HIVE_COLUMNS, DBA_HIVE_DATABASES, USER_HIVE_DATABASES, ALL_HIVE_DATABASES , 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.