暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Oracle 12.2 ORA-65010: maximum number of pluggable databases created

原创 章芋文 2016-12-01
2203
在创建PDB时报错:
[code]SQL> create pluggable database pdb4 admin user pdbadmin identified by oracle;
create pluggable database pdb4 admin user pdbadmin identified by oracle
*
ERROR at line 1:
ORA-65010: maximum number of pluggable databases created[/code]
在12.2引入max_pdbs参数,控制最大pdb数量,最大值4098:
[code]SQL> show parameter max_pd

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_pdbs integer 3
SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 READ WRITE NO
5 PDB3 READ WRITE NO
SQL> alter system set max_pdbs=10;

System altered.

SQL> create pluggable database pdb4 admin user pdbadmin identified by oracle;

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 READ WRITE NO
5 PDB3 READ WRITE NO
6 PDB4 MOUNTED
SQL>[/code]
官方文档:
http://docs.oracle.com/database/122/REFRN/MAX_PDBS.htm#GUID-55526BAC-DCB2-4C76-9ACF-1E3D2047E267
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论