PerlEngine.execute:354 status is = 2-CSDN博客

本文链接：https://blog.csdn.net/u010663554/article/details/89532037

环境: 12.1 pdb
今天在dbca建库时，最后一步完成创建时就会接收到报错：
Error in Process: /oracle/app/oracle/12.1.0/perl/bin/perl

创建cdb环境时，12.1版本组件不可选，创建一次要1个多小时，折腾了几次都是在最后一步报错

使用网上找的帖子使用系统perl对oracle程序里的perl进行软链接
$ ln -s /usr/bin/perl $ORACLE_HOME/perl/bin
结果依然报错
dbca日志/oracle/app/oracle/cfgtoollogs/dbca/ORCLDB/trace.log:


[Thread-625] [ 2019-04-24 21:45:45.767 CST ] [PerlEngine.execute:354]   status is  = 2
java.io.IOException: Error while executing "/oracle/app/oracle/12.1.0/rdbms/admin/catalog.sql". Refer to "/oracle/app/oracle/cfgtoollogs/dbca/ORCLDB/catalog0.log" for more details. Error in Process: /oracle/app/oracle/12.1.0/perl/bin/
perl
        at oracle.sysman.assistants.util.step.BasicStep.executeScriptUsingPerlEngine(BasicStep.java:791)
        at oracle.sysman.assistants.util.step.BasicStep.executeScriptUsingPerlEngine(BasicStep.java:630)
        at oracle.sysman.assistants.dbca.backend.DBCatalogStep.executeScripts(DBCatalogStep.java:348)
        at oracle.sysman.assistants.dbca.backend.DBCatalogStep.executeImpl(DBCatalogStep.java:213)
        at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:259)
        at oracle.sysman.assistants.util.step.Step.execute(Step.java:135)
        at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2883)
        at java.lang.Thread.run(Thread.java:761)
[Thread-625] [ 2019-04-24 21:45:45.768 CST ] [BasicStep.configureSettings:353]  messageHandler being set=oracle.sysman.assistants.util.InteractiveMessageHandler@4e024e02

期间一直怀疑是os环境的事，抱着试一试的态度找了找mos，结果。。。。
当时的心情过于复杂

根据2046531.1的描述，创建时使用了默认的processes参数

When creating a container database (CDB) on a server with many CPU cores or with many PDBs with default parameters, we are likely to hit ORA-20. This can be see in the alert log file that is created:

Completed: alter pluggable database pdb$seed open
Thu Aug 20 10:55:02 2015
ORA-00020: maximum number of processes (300) exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20

按我的习惯我都是默认配置，然后统一再优化参数

解决方案：
processes调整至600以上
or
不设置processes参数，由系统按照cpu数量（80 * number of CPU cores）计算

关于此Bug 18073696 - LNX64-12.1-DBCA: DBCA CREATE CDB WITH 50 PDBS HIT ORA-12516 AT PROGRESS 91% ,已在12.2中fixed