메뉴 건너뛰기

검색창 닫기

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 조회 수 : 398

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 605
24 New Features in Oracle Database 19c 명품관 2019.02.02 543
23 11.1.0.6 부터 지원하는 Oracle Online Patching New Feature 명품관 2016.04.22 522
22 Brief about Workload Management in Oracle RAC file ecrossoug 2015.11.18 512
21 Different MOS Notes for xTTS PERL scripts – Use V4 scripts 명품관 2019.01.29 492
20 Explaining the Explain Plan – How to Read and Interpret Execution Plans 명품관 2021.02.09 490
19 Why You Can Get ORA-00942 Errors with Flashback Query 명품관 2016.02.01 448
18 SQL Window Functions Cheat Sheet 명품관 2020.05.26 440
17 New Features of Backup & Recovery in Oracle Database 19c 명품관 2019.02.07 431
» Can I apply a BP on top of a PSU? Or vice versa? 명품관 2016.06.01 398
15 On ROWNUM and Limiting Results (오라클 매거진 : AskTom) 명품관 2016.04.28 384
14 V$EVENT_NAME 뷰의 Name 컬럼에 정의된 event name에서 오는 오해 명품관 2017.03.08 370
13 Parameter Recommendations for Oracle Database 12c - Part II 명품관 2016.03.18 353
12 How many checkpoints in Oracle database ? [1] file 명품관 2015.11.20 283
11 How do I capture a 10053 trace for a SQL statement called in a PL/SQL package? 명품관 2016.01.06 263
10 Oracle Enterprise Manager Cloud Control 13c Release 1 (13.1.0.0) Installation on Oracle Linux 6 and 7 명품관 2015.12.23 200
9 Quick tip on Function Based Indexes 명품관 2016.04.19 191
8 Hybrid Columnar Compression Common Questions 명품관 2016.03.04 191
7 What is an In-Memory Compression Unit (IMCU)? 명품관 2016.02.24 181
6 Upgrade a Pluggable Database in Oracle 12c 명품관 2015.12.30 170
5 (유투브) KISS series on Analytics: Dealing with null - Connor McDonald 명품관 2016.01.05 155
쓰기 태그
위로