My Oracle Support Banner

EM 12c: Uploads to the AWR Warehouse in Enterprise Manager 12c Cloud Control Fail after Target Database Upgrade from 11.2.0.3 to 11.2.0.4 (Doc ID 2173227.1)

Last updated on FEBRUARY 05, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Enterprise Manager (EM) 12.1.0.4 Cloud Control

Database <DB_TARGET_NAME> version 11.2.0.3 is a member of the Automatic Workload Repository (AWR) Warehouse configuration and uploads successfully to the AWR Repository.
AWR snapshot uploads for the <DB_TARGET_NAME> instance fail after its upgrade from 11.2.0.3 to 11.2.0.4.
Removing and re-adding the <DB_TARGET_NAME> instance to the AWR Warehouse fails during the execution of themgmt_caw_extract.run_job_now job with this error:

ORA-01034 Oracle Not Available.

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.