My Oracle Support Banner

ADDM report is not supported at PDB level until 19c (Doc ID 2805871.1)

Last updated on OCTOBER 19, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 18.14.0.0.0 [Release 12.1 to 18]
Information in this document applies to any platform.
When below ADDM report is run and picked for PDB database, below error is produced

SQL> @?/rdbms/admin/addmrpt.sql
.
Specify the location of AWR Data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
AWR_ROOT - Use AWR data from root (default)
AWR_PDB - Use AWR data from PDB
Enter value for awr_location: AWR_PDB

Location of AWR Data Specified: AWR_PDB


Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Using 3538548980 for database Id
Using 1 for instance number
declare
*
ERROR at line 1:
ORA-20200: Database/Instance 3281342511/1 does not exist in
AWR_PDB_DATABASE_INSTANCE
ORA-06512: at line 27

Symptoms

ADDM report at PDB level fails with below error

Problem Description
---------------------------------------------------
Using 3281342511 for database Id
Using 1 for instance number
declare
*
ERROR at line 1:
ORA-20200: Database/Instance 3281342511/1 does not exist in
AWR_PDB_DATABASE_INSTANCE
ORA-06512: at line 27

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.