1.下载最新的OPatch,p6880880_112000_Linux-x86-64.zip,解压并检查OPatch是否是最新的版本
[oracle@gxx2db01 bp23]$ unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/11.2.0.3/grid/ [oracle@gxx2db01 bp23]$ $ORACLE_HOME/OPatch/opatch version
2.配置OCM文件
% $ORACLE_HOME/OPatch/ocm/bin/emocmrsp
3.验证Oracle Inventory
% $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
4.解压BP23
% cd /u01/app/oracle/patches % unzip p18835772_112030_Linux-x86-64.zip % cd /u01/app/oracle/patches/18835772 # chown -R oracle:oinstall /u01/app/oracle/patches/18835772
5.进行冲突检测
For Grid Infrastructure Home, as home user: % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /18835772/18707883 % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /18835772/18906063 For Database home, as home user: % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /18835772/18707883 % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /18835772/18906063/custom/server/18906063
6.检查SystemSpace,这里主要是ORACLE_HOME是否有足够空间
For Grid Infrastructure Home, as home user: % $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /18835772/18707883 % $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /18835772/18906063 For Database home, as home user: % $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /18835772/18707883 % $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /18835772/18906063/custom/server/18906063
7.使用auto的方式打patch
# opatch auto /u01/app/oracle/patches/18835772
8.执行脚本
% SQL> sqlplus / as sysdba % SQL> @rdbms/admin/catbundle.sql exa apply
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29960155/viewspace-1402865/ ,如需转载,请注明出处,否则将追究法律责任。