My Oracle Support Banner

datapatch execution for PDB results in Error- CDB$ROOT is not in the PDBs to be processed but needs to be bootstrapped (Doc ID 2538591.1)

Last updated on NOVEMBER 06, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 19.1 BETA and later
Information in this document applies to any platform.

Symptoms

When executing datapatch only against the PDB OR upgrading the PDB inside a CDB,datapatch can fail with the below error-

Connecting to database...OK
Gathering database info...done

Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)

Bootstrapping registry and package to current versions...
Error: prereq checks failed!
CDB$ROOT is not in the PDBs to be processed but needs to be bootstrapped
Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log
/opt/oracle/cfgtoollogs/sqlpatch/sqlpatch_12004_2018_11_30_13_34_22/sqlpatch_invocation.log
for information on how to resolve the above errors.

SQL Patching tool complete on Fri Nov 30 13:34:26 2018

In case of the PDB Upgrade,the error would be right at the very end-

Component Current Full Elapsed Time
Name Status Version HH:MM:SS

Oracle Server UPGRADED 19.1.0.0.0 00:24:51
JServer JAVA Virtual Machine UPGRADED 19.1.0.0.0 00:01:13
Oracle XDK UPGRADED 19.1.0.0.0 00:01:04
Oracle Database Java Packages UPGRADED 19.1.0.0.0 00:00:09
Oracle Real Application Clusters OPTION OFF 19.1.0.0.0 00:00:00
Oracle XML Database UPGRADED 19.1.0.0.0 00:01:44
Oracle Multimedia UPGRADED 19.1.0.0.0 00:02:32
Datapatch
Error: prereq checks failed!

Datapatch 00:00:05
Final Actions 00:00:15
Post Upgrade 00:00:14

Checking QI Log-

Log file opened at 11/27/18 16:34:47.

KUP-05007: Warning: intrabron concurrency deactivated because the preprocessor option is used.

KUP-03037: Links may occur in the object path of the Oracle directory.
Incorrect file: qopatch_bad.bad

Field definitions for table OPATCH_XML_INV.
Record format DELIMITED BY NEWLINE
Data in file have the same endianness as the platform.
Reject rows with only NULL fields

Fields in data source:

XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL".
Cut off white space such as SQL Loader.
KUP-04095: At preprocessor-command /opt/oracle/product/19.0.0/QOpatch/qopiprep.bat the following error was found:
KUP-04017: OS message: No child processes
KUP-04118: Operation "wait", location "skudmi: prp: 6"



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.