My Oracle Support Banner

Datapatch fails with "CDB$ROOT is not open" although CDB/PDB are open (Doc ID 3030922.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

The post-installation step fails while executing datapatch with following error:

> ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Mon Jun 24 11:20:41 2024
Copyright (c) 2012, 2017, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_8781880_2024_06_24_11_20_41/sqlpatch_invocation.log

Connecting to database...OK
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)

catconInit failed, exiting

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

SQL Patching tool complete on Mon Jun 24 11:20:43 2024

 

> cd  /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_8781880_2024_06_24_11_20_41

> cat sqlpatch_invocation.log
SQL Patching tool version 12.1.0.2.0 Production on Mon Jun 24 11:20:41 2024
Copyright (c) 2012, 2017, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_8781880_2024_06_24_11_20_41/sqlpatch_invocation.log

SQL Patching arguments:
 verbose: 1
 force: 0
 use_rollback_files 0
 prereq: 0
 upgrade_mode_only:
 oh:
 bundle_series:
 ignorable_errors:
 bootstrap:
 skip_upgrade_check:
 userid:
 pdbs:
 noqi:

Connecting to database...OK
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)
catcon: ALL catcon-related output will be written to /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_8781880_2024_06_24_11_20_41/sqlpatch_catcon__catcon_8781880.lst
catcon: See /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_8781880_2024_06_24_11_20_41/sqlpatch_catcon_*.log files for output generated by scripts
catcon: See /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_8781880_2024_06_24_11_20_41/sqlpatch_catcon__*.lst files for spool files, if any
validate_con_names: CDB$ROOT is not open
catconInit: Unexpected error returned by validate_con_names for inclusive Container list

catconInit failed, exiting

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

SQL Patching tool complete on Mon Jun 24 11:20:43 2024

Changes

 Applied Database Bundle Patch : 12.1.0.2.221018 (34386250)

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
Changes
Cause
Solution


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