Error 'ORA-13509: error encountered during updates to a AWR table' When Trying to Create an AWR Snapshot (Doc ID 2399826.1)

Last updated on AUGUST 04, 2018

Applies to:

Symptoms

• On a new RAC database, following error is generated when trying to create snapshot manually:
  
  SQL> @cr_snapshot.sql
  BEGIN
  *
  ERROR at line 1:
  ORA-13509: error encountered during updates to a AWR table
  ORA-00942: table or view does not exist
  ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 99
  ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 137
  ORA-06512: at line 2
  
  select count(*) from dba_hist_snapshot --> 0
• AWR Info report shows following message:
  
  Warning: CATPROC Not Valid! >>>>>>
  --------------------------------------------------------------------------------
  Status: 0 (1 => VALID)
  Version: 12.1.0.2.0
  Flags: 0
  Schema#/Invoker#: 0/0
  Last Modified: 11:02:11 (11/29)
  Loading/Loaded: 15:45:17 (03/30)/15:54:56 (03/30)
  Upgrading/Upgraded: /

Cause