2 Replies Latest reply on Jul 2, 2019 6:17 PM by mbohls

    Maximum number of PDBs created error on 18c Enterprise Edition

    mbohls

      We are trying to create PDBs in a container database on 18c Enterprise Edition.  However, we can only create 3 PDBs.  When trying to create a 4th PDB we get the following error:

      ORA-65010:  maximum number of pluggable databases created.

       

      We checked the MAX_PDBs parameter and found that it had defaulted to 5.  We changed MAX_PDBS to 200, but still encounter the error.  Our understanding is that 18c Enterprise Edition should support 252 PDBs.  Any ideas why we are seeing this limitation?

       

      Our environment is as follows:

       

      SQL> select * from v$version;

      Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

      Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

      Version 18.3.0.0.0

      Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

               0

       

      SQL> show parameter pdbs

       

      NAME TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      autotask_max_active_pdbs integer     2

      enabled_PDBs_on_standby string      *

      max_pdbs integer     200

      target_pdbs integer 200

       

      SQL> show pdbs

       

          CON_ID CON_NAME OPEN MODE  RESTRICTED

      ---------- ------------------------------ ---------- ----------

      2 PDB$SEED READ ONLY  NO

      3 CDHREF1 READ WRITE NO

      4 MMB1 MOUNTED

      5 CDHREF2 READ WRITE NO

      SQL> l

        1* create pluggable database &pdb_name admin user my_admin identified by my_admin_pw

      SQL> /

      Enter value for pdb_name: mmb2

      old   1: create pluggable database &pdb_name admin user my_admin identified by my_admin_pw

      new   1: create pluggable database mmb2 admin user my_admin identified by my_admin_pw

      create pluggable database mmb2 admin user my_admin identified by my_admin_pw

      *

      ERROR at line 1:

      ORA-65010: maximum number of pluggable databases created