메뉴 건너뛰기

검색창 닫기

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 608
43 Troubleshooting Another Complex Performance Issue – Oracle direct path inserts and SEG$ contention file ecrossoug 2015.11.16 100
42 Brief about Workload Management in Oracle RAC file ecrossoug 2015.11.18 514
41 NOUG Session: How Cache Fusion Works file ecrossoug 2015.11.18 137
40 How many checkpoints in Oracle database ? [1] file 명품관 2015.11.20 283
39 Parallel Execution 12c New Features Overview file 명품관 2015.11.23 111
38 On Invokers and Outs file 명품관 2015.11.23 102
37 Top 5 SQL Monitor Features file 명품관 2015.12.01 780
36 Oracle Enterprise Manager Cloud Control 13c Release 1 (13.1.0.0) Installation on Oracle Linux 6 and 7 명품관 2015.12.23 203
35 Oracle 12c SQL – Using JSON 명품관 2015.12.29 2584
34 Upgrade a Pluggable Database in Oracle 12c 명품관 2015.12.30 174
33 (유투브) KISS series on Analytics: Dealing with null - Connor McDonald 명품관 2016.01.05 155
32 How do I capture a 10053 trace for a SQL statement called in a PL/SQL package? 명품관 2016.01.06 265
31 Why You Can Get ORA-00942 Errors with Flashback Query 명품관 2016.02.01 453
30 What is an In-Memory Compression Unit (IMCU)? 명품관 2016.02.24 181
29 Hybrid Columnar Compression Common Questions 명품관 2016.03.04 191
28 Parameter Recommendations for Oracle Database 12c - Part I 명품관 2016.03.07 846
27 Parameter Recommendations for Oracle Database 12c - Part II 명품관 2016.03.18 354
26 Oracle Linux 6.7 with Oracle 11.2.0.4 RAC 명품관 2016.04.15 9699
25 Quick tip on Function Based Indexes 명품관 2016.04.19 191
쓰기 태그
위로