操作系统:redhat linux 6.4
数据库版本:oracle 11.2.0.4.0单实例
p30805461_112040_linux-x86-64.zip
升级前环境检查,oracle_base至少有5g的空间
可以添加至oracle用户的.bash_profile文件,也可以在命令行执行(临时生效)
export path=$oracle_home/bin:$oracle_home/opatch:$path
[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.
[oracle@ocp03 ~]$ opatch lsinventory
oracle interim patch installer version 11.2.0.3.25
米乐app官网下载 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.
[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
[oracle@ocp03 ~]$ lsnrctl stop
[oracle@ocp03 ~]$ sqlplus / as sysdba
sql> shut immediate
[oracle@ocp03 30670774]$ opatch lsinventory |grep sub-patch
[oracle@ocp03 30670774]$ cd $oracle_home/rdbms/admin
[oracle@ocp03 admin]$ sqlplus / as sysdba
sql> startup
sql> @catbundle.sql psu apply
set line 200
col action_time for a35
col comments for a45
select action_time,version,comments from registry$history;