My Oracle Support Banner

Database Upgrade using OEM Fleet Maintenance FAQ (Doc ID 2388381.1)

Last updated on JULY 18, 2022

Applies to:

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


This Document contains Frequently Asked Questions for upgrading databases from 11g to 12.1/12.2 and 12.1 to 12.2 versions using Fleet Maintenance.

Questions and Answers

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
Questions and Answers
 1. Will Fleet Maintenance execute pre-upgrade sqls before the actual DB upgrade ?
 2. Is it possible to Execute only Pre-upgrade Check without actual upgrade ?
 3. Will Fleet Maintenance execute purge Recycle bin and gather stats ? if so , will it execute stats before and after DB upgrade ?
 4. At the end of the DB upgrade will Fleet Maintenance handle upgrade summary script to verify the upgrade ?
 5. Timezone upgrade will be executed during DB upgrade using Fleet Maintenance ?
 6. Will Fleet Maintenance check invalid objects / components before and after executing the DB upgrade and provide information on them ?
 7. Will DB upgrade using Fleet Maintenance work in case of Primary and Standby DB setup ? If not, is it possible to ignore Standby DB and upgrade Primary DB alone ?
 8. Is it mandatory to give SYS DB user credentials during DB upgrade to 12c version by using Fleet Maintenance ?
 9. Is 'Check Applicability' of Gold Image step applicable for DB upgrade using Fleet Maintenance command 'emcli db_software_maintenance -checkApplicability' ?


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