1、環(huán)境介紹
操作系統(tǒng)：Redhat Linux 6.4
數(shù)據(jù)庫(kù)版本：Oracle 11.2.0.4.0單實(shí)例
2、安裝介質(zhì)
p30805461_112040_Linux-x86-64.zip
3、空間檢查
升級(jí)前環(huán)境檢查，ORACLE_BASE至少有5G的空間
4、配置OPatch命令環(huán)境變量
可以添加至oracle用戶(hù)的.bash_profile文件，也可以在命令行執(zhí)行（臨時(shí)生效）
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
5、升級(jí)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、查看當(dāng)前補(bǔ)丁信息
[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、解壓補(bǔ)丁并授權(quán)
[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、停止監(jiān)聽(tīng)并一致性關(guān)庫(kù)
[oracle@ocp03 ~]$ lsnrctl stop
[oracle@ocp03 ~]$ sqlplus / as sysdba
SQL> shut immediate
9、應(yīng)用補(bǔ)丁
10、檢查補(bǔ)丁信息
[oracle@ocp03 30670774]$ opatch lsinventory |grep Sub-patch
11、執(zhí)行升級(jí)腳本
[oracle@ocp03 30670774]$ cd $ORACLE_HOME/rdbms/admin
[oracle@ocp03 admin]$ sqlplus / as sysdba
SQL> startup
SQL> @catbundle.sql psu apply
12、檢查升級(jí)后版本信息
set line 200
col ACTION_TIME for a35
col COMMENTS for a45
select ACTION_TIME,version,COMMENTS from registry$history;
