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

Last updated: October 29, 2020 - 2:48 am UTC

Version: 12.1.0.2

Viewed 1000+ 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 Connor 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"

Rating

  (1 rating)

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

Comments

Updated guidelines for 2020

Stephen A, October 28, 2020 - 9:10 pm UTC

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
October 29, 2020 - 2:48 am UTC

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

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

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