Skip to Main Content
  • Questions
  • “User created” PDB max before licensing multi tenant

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Tyler.

Asked: June 03, 2021 - 3:36 am UTC

Last updated: June 10, 2021 - 6:02 am UTC

Version: 19.7

Viewed 100+ times

You Asked

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;

and we said...

max_pdbs is the "last word" here.

Anything you *can* do with max_pdbs = 3 is fine.

Anything you *cannot* do with max_pdbs = 3 would require a multitenant license.

The term "user created" is because for certain operations, the database may temporarily create a pdb of its own accord to complete an operation (during things like cloning etc). We don't count those, but anything else pretty much does.

But as long as you set max_pdbs, you'll always be OK licensing wise.

Rating

  (1 rating)

Comments

why error on pdb3 ?

Rajeshwaran Jeyabal, June 08, 2021 - 10:59 am UTC

Team,

So why it got errored on PDB3 creation ?
is that application container is treated as count 1
and PDB1 and PDB2 are treated as count 2 and 3
and upon creating PDB3 - since we exceeded max_pdb limit, we got error ? is that correct?
Connor McDonald
June 10, 2021 - 6:02 am UTC

Correct. An application container is still a pluggable

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database