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