My Oracle Support Banner

Grid Control Repository: Upgrading 10.2.0.2 to 10.2.0.3 Results In Invalid Objects in the Sysman Schema (Doc ID 435349.1)

Last updated on NOVEMBER 09, 2019

Applies to:

Enterprise Manager Base Platform - Version 10.2.0.2 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.

Symptoms

After upgrading the grid control from 10.2.0.2 to 10.2.0.3 or after running the maintenance procedure:
exec emd_maintenance.analyze_emd_schema('SYSMAN');
several public synonyms became invalid:
MGMT$TXN_PERF_RAW
MGMT$METRIC_DETAILS
MGMT_METRICS_RAW

Also, other public synonyms became invalid from not yet determined reason:
MGMT$TXN_PERF_RAW
MGMT$TXN_PERF_HOUR
MGMT$TXN_PERF_DAY
MGMT$STEP_METRICS_RAW
MGMT$GRP_METRICS_RAW
MGMT$STEP_METRICS_HOURLY
MGMT$GRP_METRICS_HOURLY
MGMT$STEP_METRICS_DAILY
MGMT$GRP_METRICS_DAILY
MGMT_METRICS_1DAY
MGMT_METRICS_1HOUR
MGMT$METRIC_DAILY
MGMT$METRIC_HOURLY

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
References

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