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 AUGUST 23, 2016

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 ORCL 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 ORCL instance fail after its upgrade from 11.2.0.3 to 11.2.0.4.
Removing and re-adding the ORCL 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.

 

 

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms