My Oracle Support Banner

12.1 datapatch rollback PSU ,on every run after Bundle Patch is applied. (Doc ID 2589153.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

On 12.10.2 , DB PSU applied to ORACLE_HOME and datapach executed and has DB PSU entry in registry$sqlpatch.
Rolledback DB PSU from ORACLE_HOME and DB Bundle patch applied to ORACLE_HOME.
Now execution of datapatch will rollback DB PSU and apply DB Bundle Patch on first run.

Example:
Adding patches to installation queue and performing prereq checks...
Installation queue:
  The following patches will be rolled back:
    25171037 (DATABASE PATCH SET UPDATE 12.1.0.2.170418)
  The following patches will be applied:
    25397136 (DATABASE BUNDLE PATCH 12.1.0.2.170418)

Installing patches...
Patch installation complete.  Total patches installed: 2

Validating logfiles...
Patch 25171037 rollback: SUCCESS
  logfile: < >/25171037_rollback_DB_<timestamp>.log (no errors)
Patch 25397136 apply: SUCCESS
  logfile: < >/25397136_apply_DB_<timestamp>.log (no errors)


 
But now on each re-run of datapatch it again rollsback DB PSU and also there is an  entry in registry$sqlpatch:

Installing patches...
Patch installation complete.  Total patches installed: 1
Validating logfiles...
Patch 25171037 rollback: SUCCESS
  logfile: < >/25171037_rollback_DB_<timestamp>.log (no errors)


registry$sqlpatch shows all datapatch run rollback PSU with SUCCESS

25171037    ROLLBACK    <timestamp>     DATABASE PATCH SET UPDATE 12.1.0.2.170418    <PSU rollback log>     SUCCESS     PSU      170418
25397136    APPLY          <timestamp>     DATABASE BUNDLE PATCH 12.1.0.2.170418          <Apply DB BP log>      SUCCESS     DBBP    170418
25171037    ROLLBACK    <timestamp>     DATABASE PATCH SET UPDATE 12.1.0.2.170418    <PSU rollback log>     SUCCESS     PSU      170418
25171037    ROLLBACK    <timestamp>     DATABASE PATCH SET UPDATE 12.1.0.2.170418    <PSU rollback log>     SUCCESS     PSU      170418
25171037    ROLLBACK    <timestamp>     DATABASE PATCH SET UPDATE 12.1.0.2.170418    <PSU rollback log>     SUCCESS     PSU      170418

 

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.