EM 13.2: Using Fleet Maintenance and CheckApplicability of Gold Image step is Failing For DB Major Upgrade

(Doc ID 2399240.1)

Last updated on MAY 23, 2018

Applies to:

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

Symptoms

While trying to upgrade GI (Oracle Restart) target from 12.1 to 12.2 version using Enterprise Manager's Fleet Maintenance, CheckApplicability of 12.2 Gold Image step is failing with the below error:

 

$ emcli db_software_maintenance -checkApplicability -image_id=62C9F587648020E0E053A3C5F0A59D13 -target_type=has -target_list='has_xyz' > dbsf.GI.180116.checkApplicability

Checking applicability for target [has_xyz]...

Image is NOT applicable
More Information: Image requires 2463 additional bugs fixes for it to become applicable for the given target.

Following are the bugs list:

================================================================================================================================================================================================================================================
# BUG# PATCH# PATCH UPI BUG DESCRIPTION
================================================================================================================================================================================================================================================
1 19215966 21949015 19576071 THE PGA SIZE OF SHARED SERVERS BECOME LARGE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2 19215968 20243804 18468778 WRONG VALUE IN USER_IND_PARTITIONS AFTER ONLINE REDEFINITION
......................
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2462 19578247 20594149 18687526 ADD AVX2 DETECTION CAPABILITY TO LARCH
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2463 19181525 20243804 18468778 GSIAP M6 ORA-7445 [KGLBRK()+44]
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total Rows: 2463

Following are the patches:

================================================================================================================================================================================================================================================
PATCH# PATCH DESCRIPTION
================================================================================================================================================================================================================================================
21949015 DATABASE BUNDLE PATCH: 12.1.0.2.160119 (21949015)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
20243804 DATABASE BUNDLE PATCH: 12.1.0.2.5 (20243804)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
21359749 DATABASE BUNDLE PATCH: 12.1.0.2.11 (21359749)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
20594149 DATABASE BUNDLE PATCH: 12.1.0.2.7 (20594149)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
21694919 DATABASE BUNDLE PATCH: 12.1.0.2.13 (21694919)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
26392164 ACFS Patch Set Update : 12.1.0.2.171017 (26392164)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
24340679 DATABASE BUNDLE PATCH: 12.1.0.2.161018 (24340679)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
23144544 DATABASE BUNDLE PATCH: 12.1.0.2.160719 (23144544)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25397136 DATABASE BUNDLE PATCH: 12.1.0.2.170418 (25397136)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
24846605 OCW Interim patch for 24846605
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
24732088 DATABASE BUNDLE PATCH: 12.1.0.2.170117 (24732088)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
26925218 OCW Patch Set Update : 12.1.0.2.180116 (26925218)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
20415006 DATABASE BUNDLE PATCH: 12.1.0.2.6 (20415006)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
26392192 OCW Patch Set Update : 12.1.0.2.171017 (26392192)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25869760 DATABASE BUNDLE PATCH: 12.1.0.2.170718 (25869760)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
26910974 ACFS Patch Set Update : 12.1.0.2.180116 (26910974)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
24828643 ACFS Patch Set Update : 12.1.0.2.170117 (24828643)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
22806133 DATABASE BUNDLE PATCH: 12.1.0.2.160419 (22806133)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25101514 OCW Interim patch for 25101514
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
21527488 DATABASE BUNDLE PATCH: 12.1.0.2.12 (21527488)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
20788771 DATABASE BUNDLE PATCH: 12.1.0.2.8 (20788771)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
26925263 Database Bundle Patch : 12.1.0.2.180116 (26925263)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
26717470 Database Bundle Patch : 12.1.0.2.171017 (26717470)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
20950328 DATABASE BUNDLE PATCH: 12.1.0.2.9 (20950328)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
24007012 ACFS Patch Set Update : 12.1.0.2.161018 (24007012)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
21125181 DATABASE BUNDLE PATCH: 12.1.0.2.10 (21125181)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
26983807 WLM Patch Set Update: 12.1.0.2.180116 (26983807)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
21436941 WLM Patch Set Update: 12.1.0.2.5 (21436941)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
26609798 DATABASE BUNDLE PATCH: 12.1.0.2.170814 (26609798)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total Rows: 29

Verb checkApplicability completed successfully

Changes

 

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