ORA-65010: maximum number of pluggable databases created

<<Back to DB Administration Main Page


ORA-65010: maximum number of pluggable databases created

Solution: Increase the max_pdbs parameter 

alter session set container=cdb$root;
Session altered.
SQL> create pluggable database PDB02 admin user syspdb identified by password roles=(DBA) file_name_convert = ('pdbseed','PDB02');

create pluggable database PDB02 admin user syspdb identified by password roles=(DBA) file_name_convert = ('pdbseed','PDB02')
*
ERROR at line 1:
ORA-65010: maximum number of pluggable databases created

SQL> show parameter max_pdbs
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_pdbs                             integer     1

SQL> alter system set max_pdbs=3;
System altered.
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_pdbs                             integer     3

SQL>alter session set container=cdb$root;
Session altered.
SQL> create pluggable database PDB02 admin user syspdb identified by password roles=(DBA) file_name_convert = ('pdbseed','PDB02');
Pluggable database created.