DBCA Fails with ora-00020 When Creating Container Database (CDB) on Exadata

Asset ID:	1-72-2023070.1
Update Date:	2015-07-05
Keywords:

Solution Type Problem Resolution Sure

Solution 2023070.1 : DBCA Fails with ora-00020 When Creating Container Database (CDB) on Exadata

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Exadata X5-2 Hardware - Version All Versions and later
Information in this document applies to any platform.

Symptoms

When creating a Container Database (CDB) using DBCA Template, database creation fails with ora-00020.

While this is reported on Exadata Systems, it can be seen on any system with a large number of cores and / or a high value for the init parameter "parallel_max_servers".

Cause

Default setting for init parameter "processes = 300" is insufficient.

Two defects were filed on this issue.

Solution

There are two Workarounds:

1: Set processes parameter to greater than 600.

2: Unset processes parameter and system will default to 80 * number of CPU cores detected.

Enhancement request created for 12.2.

References

<BUG:21293032> - DBCA TEMPLATE FOR CDB ON EXADATA USES INVALID PROCESS PARAMETER
<BUG:18073696> - LNX64-12.1-DBCA: DBCA CREATE CDB WITH 50 PDBS HIT ORA-12516 AT PROGRESS 91%

Attachments

This solution has no attachment