Re: Non CDB to PDB

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

http://docs.oracle.com/cd/E16655_01/server.121/e17636/cdb_dbrm.htm#ADMIN13774

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

http://docs.oracle.com/cd/E16655_01/server.121/e17636/dbrm.htm#ADMIN027

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_at_gmail.com> 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 <backseatdba_at_gmail.com>
> wrote:
>
>> Hey everyone I am trying to take a non CDB 12.2.0.1 database and plug it
>> into a 12.2.0.1 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
>>
>>

--
http://www.freelists.org/webpage/oracle-l