datapatch failed with "catconExec failed during bootstrap, Prereq check failed" on 12.2 RAC+PDB

(Doc ID 2357098.1)

Last updated on FEBRUARY 18, 2018

Applies to:

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

Symptoms

datapatch fails the following messeges

Bootstrapping registry and package to current versions...
catconExec failed during bootstrap
Prereq check failed, exiting without installing any patches.

 
This problem occurs when PDB's open_mode are different between a datapatch execution instance and other instance.

SQL> SELECT inst_id, con_id, name, open_mode FROM gv$containers order by inst_id, con_id;

INST_ID CON_ID NAME OPEN_MODE
---------- ---------- -------------------- ------------------------------
1 1 CDB$ROOT READ WRITE
1 2 PDB$SEED READ ONLY
1 3 PDB1 READ WRITE
1 4 PDB2 READ WRITE
2 1 CDB$ROOT READ WRITE
2 2 PDB$SEED READ ONLY
2 3 PDB1 MOUNTED
2 4 PDB2 MOUNTED

 
datapatch is executed on INST_ID=1. All PDBs were READ WRITE on INST_ID=1.
But on other instance, PDBs were MOUNTED.

datapatch output on terminal:

$ cd $ORACLE_HOME/OPatch
$ ./datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Tue Jan 30 10:12:33 2018
Copyright (c) 2012, 2017, Oracle. All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_11732_2018_01_30_10_12_33/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)
Bootstrapping registry and package to current versions...
catconExec failed during bootstrap <--
Prereq check failed, exiting without installing any patches. <--
...
...
...
kill_sqlplus_sessions: output produced in exec_DB_script [

SQL*Plus: Release 12.2.0.1.0 Production on Tue Jan 30 10:12:44 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

SQL> Connected.
SQL> SQL> SQL>
SQL> ALTER SYSTEM KILL SESSION '55,45222' force timeout 0 -- process 11777
2 /

System altered.

SQL>
SQL>
SQL> ALTER SYSTEM KILL SESSION '297,62845' force timeout 0 -- process 11778
2 /

System altered.

SQL>
SQL>
SQL> ALTER SYSTEM KILL SESSION '296,60290' force timeout 0 -- process 11779
2 /

System altered.

SQL>
SQL>
SQL> ALTER SYSTEM KILL SESSION '50,36541' force timeout 0 -- process 11782
2 /

System altered.

SQL>
SQL> SQL>
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
] end of output produced in exec_DB_script
$

When this problem occurrs, you can find ORA-65019 occurs in sqlpatch log:
$ORACLE_BASE/cfgtoollogs/sqlpatch/sqlpatch_XXXXX_XXXX_XX_XX_XX_XX_XX/sqlpatch_catcon__catcon_XXXXX.lst

catcon: See [/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_11732_2018_01_30_10_12_33/sqlpatch_catcon_*.log] files for output generated by scripts
catcon: See [/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_11732_2018_01_30_10_12_33/sqlpatch_catcon__*.lst] files for spool files, if any
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

0.01
catconInit: start logging catcon output at 2018-01-30 10:12:34

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

exec_reset_pdb_mode_stmts: error reported while attempting to reset PDB modes:
output produced by ALTER PDB statements:

SQL*Plus: Release 12.2.0.1.0 Production on Tue Jan 30 10:12:44 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

SQL> Connected.

SQL> 2

Pluggable database altered.

SQL> 2

Pluggable database altered.

SQL> 2 alter pluggable database PDB1 open READ WRITE

*

ERROR at line 1:

ORA-65019: pluggable database PDB1 already open

SQL> 2 alter pluggable database PDB2 open READ WRITE

*

ERROR at line 1:

ORA-65019: pluggable database PDB2 already open

SQL> SQL>

SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

 

Changes

 From 12.2

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms