How to Automatically Ignore Failed Prerequisite Checks when Upgrading a Database using Fleet Maintenance

(Doc ID 2382857.1)

Last updated on APRIL 05, 2018

Applies to:

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

Goal

There are cases when the Prerequisite check step from a Database Upgrade procedure using Fleet maintenance may fail due to known reasons. An example:

RDBMS Pre-Upgrade Tool Checks
Warning: Invalid objects exist
There are INVALID objects in the database.
The list of invalid SYS/SYSTEM objects was written to registry$sys_inv_objs. The list of non-SYS/SYSTEM objects was written to registry$nonsys_inv_objs.
Use utluiobj.sql after the upgrade to identify any new invalid objects due to the upgrade.
Warning: Sync Standby Database
Sync standby database prior to upgrade.
Warning: Recycle bin not empty

Sometimes, these warning can be safely ignores, however, the Deployment procedure for the upgrade will stop and manual intervention is required to continue with it. So how to automatically ignore these?

Solution

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