Skip to main content

Patch Set Update (PSU)

安裝 PSU 10.2.0.5.4

教學參考：p12419392_10205_Linux-x86_64.zip 解壓後 Readme.html

事前準備
  •  Oracle DB 必須已經安裝完成 patch 10.2.0.5。
  • 下載需要的檔案
    • p6880880_102000_LINUX.zip (OPatch_upgrade)
    • p12419392_10205_Linux-x86-64.zip (PSU 10.2.0.5.4)

如何檢查目前 DB 的版本訊息

方法一：

> su - oracle
> cd $ORACLE_HOME/OPatch
> ./opatch lsinventory

Invoking OPatch 10.2.0.4.9

Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Oracle Home       : /opt/oracle/product/10.2.0/db_1
Central Inventory : /opt/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.9
OUI version       : 10.2.0.5.0
OUI location      : /opt/oracle/product/10.2.0/db_1/oui
Log file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2014-06-11_10-55-50AM.log

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

Lsinventory Output file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-06-11_10-55-50AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (3):

Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4                            10.2.0.5.0
There are 3 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


--------------------------------------------------------------------------------

OPatch succeeded.

方法二：

$ ./opatch  lsinventory -bugs_fixed  | grep -i -E 'DATABASE PSU|DATABASE PATCH SET UPDATE'
9952230    12419392  Wed Jun 11 11:45:57 CST 2014   DATABASE PSU 10.2.0.5.1 (INCLUDES CPUOCT2010)
10248542   12419392  Wed Jun 11 11:45:57 CST 2014   DATABASE PSU 10.2.0.5.2 (INCLUDES CPUJAN2011)
11724962   12419392  Wed Jun 11 11:45:57 CST 2014   DATABASE PSU 10.2.0.5.3 (INCLUDES CPUAPR2011)
12419392   12419392  Wed Jun 11 11:45:57 CST 2014   DATABASE PSU 10.2.0.5.4 (INCLUDES CPUJUL2011)

方法三：

> sqlplus / as sysdba
SQL> col comments for a20
SQL> col version for a20
SQL> col bundle_series for a20
SQL> select comments, version, bundle_series
from sys.registry$history
where bundle_series = 'PSU'
order by action_time;

COMMENTS             VERSION              BUNDLE_SERIES
-------------------- -------------------- --------------------
PSU 10.2.0.5.4       10.2.0.5             PSU
升級 OPatch 至 12.0.5.1

要安裝 PSU 之前，Oracle 的 OPatch 版本必須是 10.2.0.5 以上。

檢查 OPatch 版本的指令有二：

 

 

 

 

 

 

Back to top