Forum Stats

  • 3,855,199 Users
  • 2,264,473 Discussions
  • 7,905,928 Comments

Discussions

Maximum number of PDBs created error on 18c Enterprise Edition

mbohls
mbohls Member Posts: 2
edited Jul 2, 2019 2:18PM in Multitenant

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

Best Answer

Answers