This was first published on https://blog.dbi-services.com/max-pdbs-in-standard-edition (2017-10-26)
Republishing here for new followers. The content is related to the the versions available at the publication date
Here is a small warning. In Standard Edition, you may expect that the features that are not available for your edition are blocked, but in 12.2 you can create more than one PDB in Standard Edition, and you should set MAX_PDBS to prevent that.
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 it seems that this has been lost in 12.2:
oracle@SE122 ~$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Thu Oct 10 11:41:56 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO SQL> create pluggable database PDB2 admin user admin identified by me; Pluggable database created. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 PDB2 MOUNTED SQL> alter pluggable database PDB2 open; Pluggable database altered.
So, if you are in Standard Edition, don’t forget to set MAX_PDBS to 1:
SQL> alter pluggable database PDB2 close immediate; Pluggable database altered. SQL> drop pluggable database PDB2 including datafiles; Pluggable database dropped. SQL> alter system set max_pdbs=1; System altered. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 12:18:28 SQL> create pluggable database PDB2 admin user pdbadmin identified by oracle; create pluggable database PDB2 admin user pdbadmin identified by oracle * ERROR at line 1: ORA-65010: maximum number of pluggable databases created
Franck, that’s because of the new licensing model brought by the Multitenant new capabilities in 12.2: Proxy PDB and Application Root Container. Hence you can refer to this link to get the possibilities in a “Single” tenant model: https://docs.oracle.com/database/122/DBLIC/Licensing-Information.htm#GUID-54E5D57D-DF9B-43EB-8B17-D712A231C6E5__ORACLEMULTITENANTORACLEMULTITENANT-C8173FED
BR Loic
ps: there is a type in first point: 12cR1 In 12.2 Standard Ed… <- should be In 12.1…
Hi Loic, Thanks for your comment. Yes, being allowed from one PDB of each kind doesn’t make it easy for limitation and for detection (aux_count in dba_feature_usage_statistics). I fixed the typo. Regards, Franck.