Hey guys,

Regarding https://blogs.oracle.com/database/oracle-database-19c-up-to-3-pdbs-per-cdb-without-licensing-multitenant-v2

And the documentation it refers to.

I’m wondering if you can clarify how the 3 PDB limit (before additional licensing ) works with application containers. I’ve tried setting max_pdbs=3, then creating an application container and when I create the PDBs within that application container if I try to create 3 PDBs I get an error on creating the 3rd (max PDBs exceeded).

The documentation isn’t clear on what a user created PDB is (in my opinion at least) when dealing with this type of set up so I’m not sure if the error is a bug or it’s enforcing things appropriately.

Thanks !

alter system set max_pdbs=3 scope=both sid='*';

ALTER SESSION SET container = CDB$ROOT;
 
CREATE PLUGGABLE DATABASE App_Con AS APPLICATION CONTAINER ADMIN USER app_admin IDENTIFIED BY <pass>;
ALTER PLUGGABLE DATABASE App_Con OPEN instances=all;

ALTER SESSION SET container = App_Con;


CREATE PLUGGABLE DATABASE PDB1 ADMIN USER pdb_admin IDENTIFIED BY <pass>;

ALTER PLUGGABLE DATABASE PDB1 OPEN instances=all;

CREATE PLUGGABLE DATABASE PDB2 ADMIN USER pdb_admin IDENTIFIED BY <pass>;

ALTER PLUGGABLE DATABASE PDB2 OPEN instances=all;

--below fails

CREATE PLUGGABLE DATABASE PDB3 ADMIN USER pdb_admin IDENTIFIED BY <pass>;

ALTER PLUGGABLE DATABASE PDB3 OPEN instances=all;