My Oracle Support Banner

EM13C: Executing ConfugreGC.sh failed with Invalid Object SYSMAN.EM_ECM_TARGET_CSIS (Doc ID 2915980.1)

Last updated on DECEMBER 19, 2022

Applies to:

Enterprise Manager Base Platform - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

OEM Upgrade from 13.4 to 13.5 RU11. Executing ConfigureGC.sh failed at Database prerequisite checks step with Invalid Objects.

SQL> select object_name, object_type from user_objects where status = 'INVALID';

OBJECT_NAME                      OBJECT_TYPE

-----------------------             -----------------------

EM_ECM_TARGET_CSIS         VIEW

CCR_TARGET                        PACKAGE BODY

Compiling view 'EM_ECM_TARGET_CSIS' failed because of the missing table EM_ECM_TARGET_CSIS_E. Below is the output.

select owner, object_name, object_type from dba_objects where object_name like 'EM_ECM_TARGET_CSIS%';

OWNER                OBJECT_NAME                    OBJECT_TYPE
-------------------- ------------------------------  ------------------------------
SYSMAN               EM_ECM_TARGET_CSIS       VIEW
SYSMAN_RO         EM_ECM_TARGET_CSIS       SYNONYM

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.