My Oracle Support Banner

AWR Report Not Generating In Non-CDB Database. Failing Wiith ORA-20200: Database/Instance ..../. does not exist in AWR_PDB_DATABASE_INSTANCE (Doc ID 2814549.1)

Last updated on OCTOBER 26, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.11.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Receiving below error when trying to generate an AWR report.

ERROR at line 1:
ORA-20200: Database/Instance 123456789/1 does not exist in
AWR_PDB_DATABASE_INSTANCE
ORA-06512: at line 27

Changes

 The Database was recently upgraded to 19c from 12c. Before the upgrade AWR reporting was working fine.

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.