OPATCHAUTO-68061: The orchestration engine failed.

[root@racnode1 ~]# /u01/app/12.2.0.1/grid/OPatch/opatchauto apply /media/sf_Software/12201-190115/30501932 ... .. . CRS-4123: Oracle High Availability Services has been started. Oracle Clusterware active version on the cluster is [12.2.0.1.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [1477401644]. CRS-2672: Attempting to start 'ora.drivers.acfs' on 'racnode1' CRS-2676: Start of 'ora.drivers.acfs' on 'racnode1' succeeded SQL Patching tool version 12.2.0.1.0 Production on Sat Mar 7 15:46:51 2020 Copyright (c) 2012, 2019, Oracle. All rights reserved. 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...done Determining current state...done Adding patches to installation queue and performing prereq checks...done Installation queue: For the following PDBs: CDB$ROOT PDB$SEED GIMR_DSCREP_10 The following patches will be rolled back: 29708478 (DATABASE JAN 2019 RELEASE UPDATE REVISION 12.2.0.1.190716) The following patches will be applied: 30593149 (DATABASE JAN 2020 RELEASE UPDATE 12.2.0.1.200114) Installing patches... Patch installation complete. Total patches installed: 6 Validating logfiles... Patch 29708478 rollback (pdb CDB$ROOT): WITH ERRORS logfile: /u01/app/grid/cfgtoollogs/sqlpatch/29708478/22988073/ 29708478_rollback__MGMTDB_CDBROOT_2020Mar07_15_47_52.log (errors) Error at line 25435: Warning: Package Body created with compilation errors. Error at line 25442: 24/12 PLS-00323: subprogram or cursor 'GET_OPTIONAL_PRIVILEGES' is Error at line 25446: 2727/5 PL/SQL: Statement ignored Error at line 25447: 2727/21 PLS-00306: wrong number or types of arguments in call to Error at line 36437: Warning: Package Body created with compilation errors. Error at line 36444: 18788/3 PL/SQL: Statement ignored Error at line 36445: 18788/6 PLS-00201: identifier Error at line 36448: 18792/3 PL/SQL: Statement ignored Error at line 36449: 18792/3 PLS-00201: identifier Patch 29708478 rollback (pdb PDB$SEED): WITH ERRORS logfile: /u01/app/grid/cfgtoollogs/sqlpatch/29708478/22988073/ 29708478_rollback__MGMTDB_PDBSEED_2020Mar07_15_50_23.log (errors) Error at line 36419: Warning: Package Body created with compilation errors. Error at line 36426: 18788/3 PL/SQL: Statement ignored Error at line 36427: 18788/6 PLS-00201: identifier Error at line 36430: 18792/3 PL/SQL: Statement ignored Error at line 36431: 18792/3 PLS-00201: identifier Patch 29708478 rollback (pdb GIMR_DSCREP_10): WITH ERRORS logfile: /u01/app/grid/cfgtoollogs/sqlpatch/29708478/22988073/ 29708478_rollback__MGMTDB_GIMR_DSCREP_10_2020Mar07_15_50_23.log (errors) Error at line 52094: Warning: Package Body created with compilation errors. Error at line 52101: 18788/3 PL/SQL: Statement ignored Error at line 52102: 18788/6 PLS-00201: identifier Error at line 52105: 18792/3 PL/SQL: Statement ignored Error at line 52106: 18792/3 PLS-00201: identifier Please refer to MOS Note 1609718.1 and/or the invocation log /u01/app/grid/cfgtoollogs/sqlpatch/sqlpatch_9475_2020_03_07_15_46_51/sqlpatch_invocation.log for information on how to resolve the above errors. SQL Patching tool complete on Sat Mar 7 15:54:51 2020 2020/03/07 15:54:51 CLSRSC-488: Patching the Grid Infrastructure Management Repository database failed. After fixing the cause of failure Run opatchauto resume ] OPATCHAUTO-68061: The orchestration engine failed. OPATCHAUTO-68061: The orchestration engine failed with return code 1 OPATCHAUTO-68061: Check the log for more details. OPatchAuto failed. OPatchauto session completed at Sat Mar 7 15:54:52 2020 Time taken to complete the session 22 minutes, 24 seconds opatchauto failed with error code 42 [root@racnode1 ~]#

Using “opatchauto” to apply Jan2018 GI PSU onto 12R1 GI HOME, got “Prerequisite check “CheckApplicable” failed errors.

 # /u01/app/12.1.0.2/grid/OPatch/opatchauto apply /tmp/27010872 
   -oh /u01/app/12.1.0.2/grid
...
..
.
Bringing down CRS service on home /u01/app/12.1.0.2/grid
Prepatch operation log file location: /u01/app/12.1.0.2/grid/
 cfgtoollogs/crsconfig/crspatch_racnode1_2018-01-23_03-52-31PM.log
CRS service brought down successfully on home /u01/app/12.1.0.2/grid

Start applying binary patch on home /u01/app/12.1.0.2/grid
Failed while applying binary patches on home /u01/app/12.1.0.2/grid

Execution of [OPatchAutoBinaryAction] patch action failed, check log 
for more details. Failures:
Patch Target : racnode1->/u01/app/12.1.0.2/grid Type[crs]
Details: [
---------------------------Patching Failed--------------------------
Command execution failed during patching in home: /u01/app/12.1.0.2/
grid, host: racnode1.
Command failed: /u01/app/12.1.0.2/grid/OPatch/opatchauto apply 
 /tmp/27010872 -oh /u01/app/12.1.0.2/grid -target_type cluster 
 -binary -invPtrLoc /u01/app/12.1.0.2/grid/oraInst.loc -jre 
/u01/app/12.1.0.2/grid/OPatch/jre -persistresult /u01/app/12.1.0.2/
grid/OPatch/auto/dbsessioninfo/sessionresult_racnode1_crs.ser 
-analyzedresult /u01/app/12.1.0.2/grid/OPatch/auto/dbsessioninfo/
sessionresult_analyze_racnode1_crs.ser

Command failure output:
==Following patches FAILED in apply:

Patch: /tmp/27010872/26925218
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/
opatch2018-01-23_15-53-43PM_1.log
Reason:Failed during Patching: oracle.opatch.opatchsdk.OPatchException:
Prerequisite check "CheckApplicable" failed.

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.

OPatchauto session completed at Tue Jan 23 15:56:55 2018
Time taken to complete the session 6 minutes, 39 seconds

Chech opatch logfile:

[Jan 23, 2018 3:56:55 PM] [INFO] Space Needed : 3191.113MB
[Jan 23, 2018 3:56:55 PM] [INFO] Prereq checkPatchApplicableOnCurrentPlatform 
Passed for patch : 26925218
[Jan 23, 2018 3:56:55 PM] [INFO] Patch 26925218:
 onewaycopyAction : Source File "/tmp/27010872/26925218/files/crs/install
/dropdb.pl" does not exists or is not readable
 'oracle.crs, 12.1.0.2.0': Cannot copy file from 'dropdb.pl' to 
'/u01/app/12.1.0.2/grid/crs/install/dropdb.pl'
[Jan 23, 2018 3:56:55 PM] [INFO] Prerequisite check "CheckApplicable" failed.
 The details are:

Patch 26925218:
 onewaycopyAction : Source File "/tmp/27010872/26925218/files/crs/
install/dropdb.pl" does not exists or is not readable
 'oracle.crs, 12.1.0.2.0': Cannot copy file from 'dropdb.pl' to 
'/u01/app/12.1.0.2/grid/crs/install/dropdb.pl'
[Jan 23, 2018 3:56:55 PM] [SEVERE] OUI-67073:UtilSession failed:
 Prerequisite check "CheckApplicable" failed.
[Jan 23, 2018 3:56:55 PM] [INFO] Finishing UtilSession at Tue Jan 23 15:56:55 AEDT 2018
[Jan 23, 2018 3:56:55 PM] [INFO] Log file location: /u01/app/12.1.0.2
/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-23_15-53-43PM_1.log

Check “dropdb.pl” file from unziped patch. the owner is oracle.

# ls -ltr /tmp/27010872/26925218/files/crs/install/dropdb.pl
-rwx------ 1 oracle oinstall 3541 Jan 6 07:48 /tmp/27010872/26925218/
                                          files/crs/install/dropdb.pl

The patch file was unzipped by RAC user ‘oracle’ instead of GI owner ‘grid’. Change this file owner to grid, and run “opatchauto resume” to continue the patching successfully.

#chown grid /tmp/27010872/26925218/files/crs/install/dropdb.pl
#/u01/app/12.1.0.2/grid/OPatch/opatchauto resume

REFERENCES:

12c opatchauto: Prerequisite check “CheckApplicable” failed (Doc ID 1937982.1)

Tag: OPATCHAUTO-68061: The orchestration engine failed.

CLSRSC-488: Patching the Grid Infrastructure Management Repository database failed

Subscribe to get access

12c opatchauto : Prerequisite check “CheckApplicable” failed