Oracle 19c 是CDB 架构，支持多个PDB，但PDB 的数量是受授权控制的。

在没有Multitenant license 授权的情况下，最多只能创建3个PDB，当创建的PDB超过4个时，会报如下错误：

SQL> create pluggable database ADMIN USER pdbadmin identified by *** DEFAULT TABLESPACE USERS;
Enter value for p: TEST
old 1: create pluggable database &p ADMIN USER pdbadmin identified by *** DEFAULT TABLESPACE USERS
new 1: create pluggable database TEST ADMIN USER pdbadmin identified by *** DEFAULT TABLESPACE USERS
create pluggable database TEST ADMIN USER pdbadmin identified by *** DEFAULT TABLESPACE USERS
*
ERROR at line 1:
ORA-65010: maximum number of pluggable databases created

虽然此时max_pdbs参数还是4098， 但是依旧是无法创建的：http://www.cndba.cn/dave/article/107747http://www.cndba.cn/dave/article/107747

SQL> sho parameter max_pdbs
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
max_pdbs integer 4098
====>We are also unable to reduce the max_pdbs values
SQL> alter system set max_pdbs=25;
alter system set max_pdbs=25
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-65334: invalid number of PDBs specified

所以如果要创建超过3个PDB时，需要申请到Multitenant license授权。

19C - ORA-65010: maximum number of pluggable databases created (Doc ID 2676737.1)

http://www.cndba.cn/dave/article/107747

http://www.cndba.cn/dave/article/107747

http://www.cndba.cn/dave/article/107747http://www.cndba.cn/dave/article/107747

版权声明：本文为博主原创文章，未经博主允许不得转载。