1、环境介绍
操作系统：Redhat Linux 6.4
数据库版本：Oracle 11.2.0.4.0单实例
2、安装介质
p30805461_112040_Linux-x86-64.zip
3、空间检查
升级前环境检查，ORACLE_BASE至少有5G的空间
4、配置OPatch命令环境变量
可以添加至oracle用户的.bash_profile文件，也可以在命令行执行（临时生效）
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
5、升级OPatch版本
[root@ocp03 soft]# unzip p6880880_112000_Linux-x86-64_11.2.0.3.25.zip
[root@ocp03 soft]# chown oracle:oinstall OPatch/ -R
[oracle@ocp03 11.2.0.4]$ cp -r OPatch/ $ORACLE_HOME
[oracle@ocp03 11.2.0.4]$ opatch version
OPatch Version: 11.2.0.3.25
OPatch succeeded.
6、查看当前补丁信息
[oracle@ocp03 ~]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.25
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/oracle/product/11.2.0.4
Central Inventory : /u01/oraInventory
from : /u01/oracle/product/11.2.0.4/oraInst.loc
OPatch version : 11.2.0.3.25
OUI version : 11.2.0.4.0
Log file location : /u01/oracle/product/11.2.0.4/cfgtoollogs/opatch/opatch2020-07-13_15-45-35PM_1.log
Lsinventory Output file location : /u01/oracle/product/11.2.0.4/cfgtoollogs/opatch/lsinv/lsinventory2020-07-13_15-45-35PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ocp03
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
7、解压补丁并授权
[root@ocp03 soft]# unzip p30805461_112040_Linux-x86-64.zip
[root@ocp03 soft]# chown oracle:oinstall 30805461/ -R
[root@ocp03 soft]#chmod 777 30805461/ -R
8、停止监听并一致性关库
[oracle@ocp03 ~]$ lsnrctl stop
[oracle@ocp03 ~]$ sqlplus / as sysdba
SQL> shut immediate
9、应用补丁
10、检查补丁信息
[oracle@ocp03 30670774]$ opatch lsinventory |grep Sub-patch
11、执行升级脚本
[oracle@ocp03 30670774]$ cd $ORACLE_HOME/rdbms/admin
[oracle@ocp03 admin]$ sqlplus / as sysdba
SQL> startup
SQL> @catbundle.sql psu apply
12、检查升级后版本信息
set line 200
col ACTION_TIME for a35
col COMMENTS for a45
select ACTION_TIME,version,COMMENTS from registry$history;
