ORA-20200

Error

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

Cause

An awrrpt.sql was run and no snapshots exist in the AWR for the database instance specified.

Resolution

Create a snapshot using EM Cloud Control or DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT and re-run the awrrpt.sql

Also ensure that the AWR parameters are set.

SYS@XE>show parameter awr

NAME                          ,TYPE      ,VALUE
------------------------------,----------,--------------------------
awr_pdb_autoflush_enabled     ,boolean   ,TRUE
awr_pdb_max_parallel_slaves   ,integer   ,10
awr_snapshot_time_offset      ,integer   ,1000000


EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT;

@?/rdbms/admin/awrrpt.sql

..

..

..