ORACLE PSU(Patch SetT Update)

    ORACLE PSU是Patch SetT Update的缩写。ORACLE提供了PSU升级的工具OPatch。PSU对OPatch Utility的版本有要求，必须满足PSU要求的版本才能使用OPatch Utility完成升级操作。本次升级的数据库版本10.2.0.5，使用的PSU是16619894 - 10.2.0.5.12。该PSU要求使用OPatch 10.2版本10.2.0.5.0或者以上。因此需要更新OPatch，再打PSU，过程如下。

1. Upgrade OPatch

$ opatch version
Invoking OPatch 10.2.0.4.9

OPatch Version: 10.2.0.4.9

OPatch succeeded.

opatch版本10.2.0.4.9，不满足版本要求，先升级opatch版本。

$ unzip p6880880_102000_Linux-x86-64.zip
$ opatch version
Invoking OPatch 10.2.0.5.1

OPatch Version: 10.2.0.5.1

OPatch succeeded.

2. Patch Pre-Installation
进行冲突检测
$ unzip p16619894_10205_Linux-x86-64_psu12.zip

$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./16619894
Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /oracle/product/10.2.0
Central Inventory : /oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.5.0
OUI location      : /oracle/product/10.2.0/oui
Log file location : /oracle/product/10.2.0/cfgtoollogs/opatch/opatch2014-11-13_14-23-54PM.log

Patch history file: /oracle/product/10.2.0/cfgtoollogs/opatch/opatch_history.txt

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

3. Patch Installation

停数据库，打PSU

$ lsnrctl stop
$ sqlplus / as sysdba
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

$ cd 16619894
$ opatch apply

 

4. Post Installation

再次检测

$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir .
$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus / as sysdba
SQL> startup
SQL> @catbundle.sql psu apply
SQL> @utlrp.sql

 

5. 验证

$ opatch lsinventory

 

$ opatch lsinv -bugs_fixed|grep PSU

SQL> select substr(action_time,1,30) action_time,
  2         substr(id,1,10) id,
  3         substr(action,1,10) action,
  4         substr(version,1,8) version,
  5         substr(BUNDLE_SERIES,1,6) bundle,
  6         substr(comments,1,20) comments
  7  from registry$history;

ACTION_TIME                         ID  ACTION VERSION    BUNDLE COMMENTS
----------------------------------- --- ------ ---------- ------ ---------------
13-NOV-14 02.38.02.306904 PM        12  APPLY  10.2.0.5   PSU    PSU 10.2.0.5.12
13-NOV-14 02.38.31.915570 PM        12  APPLY  10.2.0.5   PSU    PSU 10.2.0.5.12
13-NOV-14 02.38.47.031112 PM        12  APPLY  10.2.0.5   PSU    PSU 10.2.0.5.12