Skip to Main Content
  • Questions
  • AWR warehouse set up using pluggable databases

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Cory.

Asked: May 04, 2017 - 5:58 pm UTC

Answered by: Connor McDonald - Last updated: October 29, 2020 - 2:48 am UTC

Category: Database Administration - Version: 12.1.0.2

Viewed 100+ times

You Asked

Is it not possible to use a pluggable or container database as the AWR warehouse database? The documentation doesn't state anything about it but when i go to configure the awr warehouse, there is no option to select those types of databases.

and we said...

It is on the list of enhancements

From MOS Note 1907335.1

"The following database versions are supported for the AWR repository:

11.2.0.4 or later (Linux x86-64) and 11.2.0.4.4 (Exadata) with required Patch 18547891 or later
11.2.0.4 (AIX) PSU 4 (11.2.0.4.4) must be applied as a minimum requirement for AIX
12.1.0.2, 12.2, 18c, 19c or later (configured as a non PDB database)
Pluggable databases (PDBs) 12.2, 18c, 19c or later when used with Enterprise Manager 13.4 BP2 and above"

and you rated our response

  (1 rating)

Is this answer out of date? If it is, please let us know via a Review

Reviews

Updated guidelines for 2020

October 28, 2020 - 9:10 pm UTC

Reviewer: Stephen A from Auckland, NZ

The MOS note was updated recently to include PDB's when you are on the newer versions of EM13.4
The following database versions are supported for the AWR repository:

11.2.0.4 or later (Linux x86-64) and 11.2.0.4.4 (Exadata) with required Patch 18547891 or later
11.2.0.4 (AIX) PSU 4 (11.2.0.4.4) must be applied as a minimum requirement for AIX
12.1.0.2, 12.2, 18c, 19c or later (configured as a non PDB database)
Pluggable databases (PDBs) 12.2, 18c, 19c or later when used with Enterprise Manager 13.4 BP2 and above
Connor McDonald

Followup  

October 29, 2020 - 2:48 am UTC

thanks for letting us know - we'll update the answer

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database