메뉴 건너뛰기

Korea Oracle User Group

Guru's Articles

Can I apply a BP on top of a PSU? Or vice versa?

 

By Mike Dietrich-Oracle on May 03, 2016

This question was in my inbox this morning raised by a customer via a colleague. 

Our feeling said:
Yes, but you'll have to deinstall the PSU first before applying the BP.

Having a feeling is one thing, knowing the truth is better. And as I have so much fun by applying PSUs and BPs back and forth since two weeks I thought "let's give it a try". So here we go ...
.

 

Apply a BP on top of a PSU

 

This is my starting point - Oracle Database 12.1.0.2 with PSU October 2015, the last state in my VBox environment since I experiment with parameters and packages at the moment.

And this is the result when trying to apply the BP from April 2016 on top: 

 

[CDB2] oracle@localhost:/media/sf_CTEMP/22899531/22899531/22806133
$ opatch apply
Oracle Interim Patch Installer version 12.1.0.1.10
Copyright (c) 2016, Oracle Corporation.  All rights reserved.

 

Oracle Home       : /u01/app/oracle/product/12.1.0.2
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/oraInst.loc
OPatch version    : 12.1.0.1.10
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/cfgtoollogs/opatch/opatch2016-05-03_10-26-37AM_1.log

Verifying environment and performing prerequisite checks...

Conflicts/Supersets for each patch are:

Sub-Patch : 20243804

        Bug Conflict with Sub-Patch 21359755
        Conflicting bugs are:
        18966843, 19468991, 19032777, 19587324

[..]

 

Following patches have conflicts: [   21359755   22806133 ]
Refer to My Oracle Support Note 1299688.1 for instructions on resolving patch conflicts.

UtilSession failed: Patch 21359755 is a composite patch which could not be rollback.

Log file location: /u01/app/oracle/product/12.1.0.2/cfgtoollogs/opatch/opatch2016-05-03_10-26-37AM_1.log

OPatch failed with error code 73


Ok, our suspicion was correct.

There are a lot of conflicts - I have to remove the PSU first. And of course the recommended conflict check would have given me the same result. Furthermore I think I have read this a while back in one of the central notes about PSUs and BPs in MOS as well.
.

 

Removing the PSU from October 2015 first

 

Removing a PSU or BP is very simple and straight forward (and well described in the ReadMe.html coming coming with the patch).

 

[CDB2] oracle@localhost:/media/sf_CTEMP/21359755/21359755
$ opatch rollback -id 21359755
Oracle Interim Patch Installer version 12.1.0.1.10
Copyright (c) 2016, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0.2
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/oraInst.loc
OPatch version    : 12.1.0.1.10
OUI version       : 12.1.0.2.0

Log file location : /u01/app/oracle/product/12.1.0.2/cfgtoollogs/opatch/21359755_May_03_2016_10_41_54/rollback2016-05-03_10-41-54AM_1.log

Patches will be rolled back in the following order:
   21359755   20831110   20299023   19769480
The following patch(es) will be rolled back: 21359755  20831110  20299023  19769480
Sub-patches of a composite series are being rolled back. The system will be returned to a state where all subpatches are rolled back.

[..]

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2')

Is the local system ready for patching? [y|n]
y

User Responded with: Y
Rolling back patch 21359755...

[..]

RollbackSession removing interim patch '19769480' from inventory Log file location: /u01/app/oracle/product/12.1.0.2/cfgtoollogs/opatch/21359755_May_03_2016_10_41_54/rollback2016-05-03_10-41-54AM_1.log OPatch succeeded.

 

 

Apply the BP from April 2016

 

I don't want to repeat myself as I wrote already about this positive experience a few days ago:

Oracle Database BP April 2016 applied successfully (Apr 21, 2016)
https://blogs.oracle.com/UPGRADE/entry/oracle_database_bp_april16_applied

 

Further Information?

 

You'll find recent related postings on this blog here:

 

 

--Mike

 

출처 : https://blogs.oracle.com/UPGRADE/entry/can_i_apply_a_bp

번호 제목 글쓴이 날짜 조회 수
공지 Guru's Article 게시판 용도 ecrossoug 2015.11.18 13
27 Parameter Recommendations for Oracle Database 12c - Part I 명품관 2016.03.07 267
26 Oracle 12c SQL – Using JSON 명품관 2015.12.29 172
25 11.1.0.6 부터 지원하는 Oracle Online Patching New Feature 명품관 2016.04.22 169
24 DDL Logging - 12c (조나단 루이스) 명품관 2016.04.26 132
» Can I apply a BP on top of a PSU? Or vice versa? 명품관 2016.06.01 122
22 Oracle Linux 6.7 with Oracle 11.2.0.4 RAC 명품관 2016.04.15 113
21 How to Recover Data (Without a Backup!) 명품관 2016.05.11 92
20 On ROWNUM and Limiting Results (오라클 매거진 : AskTom) 명품관 2016.04.28 88
19 Parameter Recommendations for Oracle Database 12c - Part II 명품관 2016.03.18 83
18 NOUG Session: How Cache Fusion Works file ecrossoug 2015.11.18 68
17 Oracle Enterprise Manager Cloud Control 13c Release 1 (13.1.0.0) Installation on Oracle Linux 6 and 7 명품관 2015.12.23 64
16 How many checkpoints in Oracle database ? [1] file 명품관 2015.11.20 63
15 V$EVENT_NAME 뷰의 Name 컬럼에 정의된 event name에서 오는 오해 명품관 2017.03.08 60
14 Why You Can Get ORA-00942 Errors with Flashback Query 명품관 2016.02.01 58
13 How to change the database name in 12c 명품관 2016.05.31 55
12 What is an In-Memory Compression Unit (IMCU)? 명품관 2016.02.24 49
11 How do I capture a 10053 trace for a SQL statement called in a PL/SQL package? 명품관 2016.01.06 41
10 Quick tip on Function Based Indexes 명품관 2016.04.19 40
9 Hybrid Columnar Compression Common Questions 명품관 2016.03.04 38
8 Parallel Execution 12c New Features Overview file 명품관 2015.11.23 31
위로