ORA-65010: maximum number of pluggable databases created

ORA-65010: maximum number of pluggable databases created

Error:
ORA-65010: maximum number of pluggable databases created

Error getting when i tried to create the PDB database:

SQL> CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb_adm IDENTIFIED BY Password1
2 FILE_NAME_CONVERT=('D:\ORACLE\18.0.0\ORADATA\XE\PDBSEED\','D:\ORACLE\18.0.0\ORADATA\XE\PDB1\');
CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb_adm IDENTIFIED BY Password1
*
ERROR at line 1:
ORA-65010: maximum number of pluggable databases created

Cause
PDB database reached its limit. A CDB is container (CON_ID=0). CDB$ROOT (CON_ID=1), PDB$SEED(CON_ID=2), PDB1(CON_ID=3)…so on.
In 12.1 EE you have 252 limit but in 12.2 EE you have limit of 4096 PDB databases.

Solution
You should increase the value of this parameters


SQL>show parameter max_pdbs

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

--reboot the container database

Note: 12.2 you can create more than one PDB in Standard Edition, and you should set MAX_PDBS to prevent that.
If you are in Standard Edition, don’t forget to set MAX_PDBS to 1:
alter system set max_pdbs=1 scope=spfile;
In 12.1 Standard Edition, when you try to create more than one PDB (i.e with CON>ID > 3) you get an error:
ORA-65010: maximum number of pluggable databases created.
But in 12cR2 it seems that this has been lost in 12.2.

Check the multitenant feature usage

select name feature_name,version,detected_usages,aux_count
from dba_feature_usage_statistics
where name like '%Pluggable%' or name like '%Multitenant%';

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.