My Oracle Support Banner

EM 13c: Patch Rollback with Enterprise Manager 13c Cloud Control Fleet Maintenance Fails with Datapatch: Error at line 88: Warning: Package Body created with compilation errors (Doc ID 2539228.1)

Last updated on JANUARY 23, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and later
Information in this document applies to any platform.

Symptoms

Rolling back a patch using Enterprise Manager 13.2.2 Cloud Control Fleet Maintenance gives the following error when the datapatch commands are executed:

Mon Apr 1 09:39:49 2019 - setupOSD : OS =>linux , onWindows =>

Version IS 12.1.0.2.0
major version is 12
Moving sqlpatch directory from source to destination home - Datapatch issue
mv <database ORACLE_HOME 1>/sqlpatch <database ORACLE_HOME 1>/sqlpatch_bkp
cp -r <database ORACLE_HOME 2>/sqlpatch <database ORACLE_HOME 1>/
Mon Apr 1 09:39:51 2019 - Command - <database ORACLE_HOME 2>/OPatch/datapatch -oh <database ORACLE_HOME 2>
SQL Patching tool version 12.1.0.2.0 Production on Mon Apr 1 09:39:51 2019
Copyright (c) 2012, 2017, Oracle. All rights reserved.

Connecting to database...OK
Bootstrapping registry and package to current versions...done
Error in bootstrap log <database ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_31736_2019_04_01_09_39_51/bootstrap1_FLEET.log:
Error at line 88: Warning: Package Body created with compilation errors.

Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log
<database ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_31736_2019_04_01_09_39_51/sqlpatch_invocation.log
for information on how to resolve the above errors.

Changes

 

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
References


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