I guess I was wrong. I opened a case with Oracle. Here is what they said.
12c Pluggable database
maximum number of consumer group is 8
As per documentation
In a CDB, the following restrictions apply to PDB resource plans:
A PDB resource plan cannot have subplans.
A PDB resource plan can have a maximum of eight consumer groups.
A PDB resource plan cannot have a multiple-level scheduling policy.
12c non-pluggable database :
A maximum limit consumer group is 28 which is mentioned in the documentation
Hence please reduce the number of groups from the plan from the non-CDB and
then re-plug it and run noncdb_to_pdb.sql
On Wed, Mar 25, 2020 at 3:54 PM Maris Elsins <elmaris@xxxxxxxxx> wrote:
I haven't seen this case, but you could look for any trace files from the
DBRM background process (this is the resource manager process) - it could
provide additional hints.
On Thu, Mar 26, 2020 at 12:09 AM Jeff Chirco <backseatdba@xxxxxxxxx>
Hey everyone I am trying to take a non CDB 184.108.40.206 database and plug it
into a 220.127.116.11 CDB.
I've been able to plug in the database but when I run noncdb_to_pdb.sql
it fails with this.
alter pluggable database "dbjeff" open restricted
ERROR at line 1:
ORA-29376: number of consumer groups 11 in plan MY_DEFAULT_PLAN exceeds 8
I can't find much info about this error. From what I can tell the max
groups in a plan is 28 so I don't know why it is saying 8?
Any ideas how I can get past this?