Oracle 12c PSU rollback and upgrade

Source: Internet
Author: User
Tags sessions sqlplus

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.