Enterprise Manager Cloud Control Patch Plan Doesn't Support Patches which have different SQL/PL SQL execs (Doc ID 2007331.1)

Last updated on MAY 12, 2015

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.3.0 and later
Information in this document applies to any platform.
When applying Combo Patches to a Database it is recommended to add the individual patches to a patch plan rather than the Combo Patch itself.
The below patches are added to a Patch Plan:

Patch 20299010 - DB SPU
Patch 20406220 - OJAVAVM PU

The Analyze fails with the following messages:

Issue:
Patches 20299010, 20406220 need to execute SQL/PL SQL files in the upgrade mode, whereas other patches need to execute these files in the normal mode. This combination is not supported in the same patching session.

Solution:
In a single patching session, select only those patches which have the same SQL/PL SQL exec

The database was was not started in upgrade mode before applying the OJAVAVM post patch script. Both scripts were executed without the database being shutdown and restarted between executions. It is noted in document Doc ID 1929745.1.

Post install steps depend on whether a database has JavaVM installed or not.
For each database with JavaVM installed the following must occur:

Start the database in UPGRADE mode
Run OJVM PSU post install steps
Shutdown and restart the database for DB PSU post install steps

It is not mandatory to use UPGRADE mode but some database configurations may report ORA-7445 errors if the DB is started normally before OJVM PSU post install steps have been executed.
From April 2015 onwards the OJVM PSU Readme and patching steps now use UPGRADE mode

Enhancement Request 21026320 - Ability to include both DB SPSU and OJAVAVM PSU in the same Patch Plan - has been created to have this method of patching looked at and possibly added to a future version of Enterprise Manager Cloud Control.

Symptoms

When applying Combo Patches to a Database it is recommended to add the individual patches to a patch plan rather than the Combo Patch itself. 

The below patches are added to a Patch Plan:

Patch 20299010 - DB SPU
Patch 20406220 - OJAVAVM PU

The Analyze fails with the following messages:

Issue:
Patches 20299010, 20406220 need to execute SQL/PL SQL files in the upgrade mode, whereas other patches need to execute these files in the normal mode. This combination is not supported in the same patching session.

Solution:
In a single patching session, select only those patches which have the same SQL/PL SQL exec

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