Re: Non CDB to PDB

From: Jeff Chirco <>
Date: Wed, 25 Mar 2020 17:03:37 -0700
Message-ID: <>

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 <> wrote:

> Hi,
> 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.
> ---
> Maris Elsins
> On Thu, Mar 26, 2020 at 12:09 AM Jeff Chirco <>
> wrote:
>> Hey everyone I am trying to take a non CDB database and plug it
>> into a 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?
>> Thank you,
>> Jeff

Received on Thu Mar 26 2020 - 01:03:37 CET

Original text of this message