메뉴 건너뛰기

검색창 닫기

Korea Oracle User Group

Guru's Articles

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

명품관 2016.06.01 15:08 조회 수 : 396

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 603
44 Troubleshooting Another Complex Performance Issue – Oracle direct path inserts and SEG$ contention file ecrossoug 2015.11.16 99
43 On Invokers and Outs file 명품관 2015.11.23 102
42 Parallel Execution 12c New Features Overview file 명품관 2015.11.23 110
41 NOUG Session: How Cache Fusion Works file ecrossoug 2015.11.18 136
40 (유투브) KISS series on Analytics: Dealing with null - Connor McDonald 명품관 2016.01.05 155
39 Upgrade a Pluggable Database in Oracle 12c 명품관 2015.12.30 168
38 What is an In-Memory Compression Unit (IMCU)? 명품관 2016.02.24 181
37 Hybrid Columnar Compression Common Questions 명품관 2016.03.04 191
36 Quick tip on Function Based Indexes 명품관 2016.04.19 191
35 Oracle Enterprise Manager Cloud Control 13c Release 1 (13.1.0.0) Installation on Oracle Linux 6 and 7 명품관 2015.12.23 200
34 How do I capture a 10053 trace for a SQL statement called in a PL/SQL package? 명품관 2016.01.06 263
33 How many checkpoints in Oracle database ? [1] file 명품관 2015.11.20 283
32 Parameter Recommendations for Oracle Database 12c - Part II 명품관 2016.03.18 352
31 V$EVENT_NAME 뷰의 Name 컬럼에 정의된 event name에서 오는 오해 명품관 2017.03.08 367
30 On ROWNUM and Limiting Results (오라클 매거진 : AskTom) 명품관 2016.04.28 384
» Can I apply a BP on top of a PSU? Or vice versa? 명품관 2016.06.01 396
28 New Features of Backup & Recovery in Oracle Database 19c 명품관 2019.02.07 429
27 SQL Window Functions Cheat Sheet 명품관 2020.05.26 437
26 Different MOS Notes for xTTS PERL scripts – Use V4 scripts 명품관 2019.01.29 446
25 Why You Can Get ORA-00942 Errors with Flashback Query 명품관 2016.02.01 448
쓰기 태그
위로