Oracle 12c
Problem:
If ORACLE patch PSU 22191659 binary also upgrades the database dictionary through $oracle_home/opatch/datapatch-verbose.
Next, the patch Super-patch PSU 25433980 binary is continued, but the $oracle_home/opatch/datapatch-verbose is not executed
So then there are two things to keep in mind.
1. Although Super-patch is binary only, the database is running the latest Lib library at startup, except that some of the database dictionaries are not updated.
Also, after Super-patch binary succeeded patch, the Sub-set patch PSU is no longer in effect.
Sub-set patch [22139226] have become inactive due to the application of a super-set patch [25437695]
2. In this case, if you want to roll back the Super-patch, you can do so. Similar to the following:
$ORACLE _home/opatch/opatch Nrollback-id 25437695-OJVM
$ORACLE _home/opatch/opatch Nrollback-id 25171037-db
After these two operations are complete, Oracle retains the patch PSU from the SELECT * from Dba_registry_sqlpatch.
That is, the rollback of a simple super-patch binary retains the sub-patch of the data dictionary, such as performing the above operation, and the patch_id PSU 21948354 below will remain and take effect.
Sql> select * from Dba_registry_sqlpatch;
patch_id VERSION STATUS
---------- ---------- ----------------------
21948354 19553095 1 SUCCESS
3. When rollback does not update the binary of the database dictionary, you do not need to run $oracle_home/opatch/datapatch-verbose
When rollback has updated the PSU for the database dictionary, it is necessary to perform all operations by the upgrade operation, otherwise the information in the Dba_registry_sqlpatch attempt is inaccurate.
Incidental
Oracle 12c PSU Upgrade
1.sql>shutdown DB
2.stop Listener
3.stop agent and Ome and TFA (if you have)
4.exit all sqlplus and Plsql or kill all sessions from external
5.MV $ORACLE _home/opatch $ORACLE _home/opatch_bak (optional)
6.unzip p6880880_122010_linux-x86-64.zip-d $ORACLE _home
7.unzip p25433980_121020_linux-x86-64.zip-d 25433980
8. $ORACLE _home/opatch/opatch napply 25433980/25433980
9.sql>startup upgrade;
$ORACLE _home/opatch/datapatch-verbose
11.start all has stop at Frist
12.finish
Oracle 12c PSU Rollback
1.sql>shutdown DB
2.stop Listener
3.stop agent and Ome and TFA (if you have)
4.exit all sqlplus and Plsql or kill all sessions from external
5. $ORACLE _home/opatch/opatch Nrollback-id 25437695 (e.g)
6.sql>startup upgrade;
7. $ORACLE _home/opatch/datapatch-verbose
8.start all has stop at Frist
9.congratulations
Oracle 12c PSU rollback and upgrade