My Oracle Support Banner

AWR Snapshots Not Generating ORA-13516 (Doc ID 2756259.1)

Last updated on MARCH 31, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 18.7.0.0.0 to 20.3.0.0.0 Preview [Release 18 to 20.0]
Information in this document applies to any platform.

Symptoms

1. Automatic awr snapshots have stopped

2. exec dbms_workload_repository.create_snapshot generates ORA-13516

 

3. Problem is seen after a startup restrict.  MMON process is not being spawned

 

 

 

 

 

Changes

 Problem seen after startup restrict.

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
References


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