oracle 11.2.0.4 PSU补丁升级

一、准备工作
1、下载补丁程序
oracle patch是oracle的更新工具，由于本次更新补丁要求使用OPatch 11.2.0.3.6以上，而默认安装的oracle 11.2.0.4的OPatch为11.2.0.3.5。
为此需要下载一个新的OPatch工具。下载地址：https://updates.oracle.com/download/6880880.html
p6880880_112000_Linux-x86-64.zip   ---opatch11.2.0.3.18
p26925576_112040_Linux-x86-64.zip  ----11.2.0.4.180116
2、关闭数据库及监听


二、更新OPatch程序
To install this patch, Please extract the file "zipped file" using unzip or winzip,
depending upon the platform. You should extract the zip file directly under the
ORACLE_HOME. Please follow the following steps for extracting the zip file of OPatch.


(1)  Please take a backup of ORACLE_HOME/OPatch into a dedicated backup
location.
(2) Please make sure no directory ORACLE_HOME/OPatch exist.
(3) Please unzip the OPatch downloaded zip into ORACLE_HOME directory.


To check the version of the opatch utility installed in the above step,
go to the OPatch directory and run "opatch version".


将原ORACLE_HOME目录下的OPatch目录备份，并解压新的OPatch程序，操作步骤如下：
[oracle@ogg1 db_1]$ export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
[oracle@ogg1 db_1]$ cd $ORACLE_HOME/
[oracle@ogg1 db_1]$ mv OPatch/ OPatchbk
[oracle@ogg1 db_1]$ unzip p6880880_112000_Linux-x86-64.zip
[oracle@ogg1 db_1]$ opatch version
OPatch Version: 11.2.0.3.18




三、更新PSU
1、更新操作
[oracle@ogg1 soft]$ export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
[oracle@ogg1 soft]$ unzip p26925576_112040_Linux-x86-64.zip
[oracle@ogg1 soft]$ cd /26925576
[oracle@ogg1 26925576]$ opatch apply
更新中根据提示完成。


2、检查更新
[oracle@ogg1 26925576]$ opatch lspatches   --查看补丁集
26925576;Database Patch Set Update : 11.2.0.4.180116 (26925576)


OPatch succeeded.


[oracle@ogg1 26925576]$ opatch lsinventory   --查看补丁清单
Oracle Interim Patch Installer version 11.2.0.3.18
Copyright (c) 2018, Oracle Corporation.  All rights reserved.




Oracle Home       : /u01/oracle/product/11.2.0/db_1
Central Inventory : /u01/oraInventory
   from           : /u01/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.18
OUI version       : 11.2.0.4.0
Log file location : /u01/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-03-14_17-15-03PM_1.log


Lsinventory Output file location : /u01/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-03-14_17-15-03PM.txt


--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ogg1
ARU platform id: 226
ARU platform description:: Linux x86-64


Installed Top-level Products (1): 


Oracle Database 11g