Oracle 12c PSU rollback and upgrade

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