Unable To Gather Statistics, Receive "ORA-20000: Resource Manager Plan Is Not Active or is not managing CPU usage" Error Following Upgrade to 12c
(Doc ID 2049013.1)
Last updated on APRIL 14, 2021
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
- While attempting to gathering statistics on Oracle 12c, receive ORA-20000 error as follows:
- Statistics Gathering worked fine on the earlier version
Database was upgraded to 12c
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
|Enable Resource Manager:|
|Disable concurrent statistics gathering by setting the CONCURRENT preference to OFF:|