ADDM report is not supported at PDB level until 19c
(Doc ID 2805871.1)
Last updated on JULY 20, 2024
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 |