ITPub博客

首页 > 数据库 > Oracle > Oracle11gR2打补丁

Oracle11gR2打补丁

原创 Oracle 作者:Yojen_Qi 时间:2014-06-16 23:21:24 0 删除 编辑
1、备份/oracle和/grid目录
root用户执行
tar -cvf /appview/oracle.tar /oracle
tar -cvf /appview/grid.tar  /grid


2、更新Oracle database home和GI home的OPatch
oracle执行:

unzip /tmp/orasoft/psu5/p6880880_112000_HPUX-IA64.zip -d $ORACLE_HOME
选A
$ORACLE_HOME/OPatch/opatch version
grid用户执行:

unzip /tmp/orasoft/psu5/p6880880_112000_HPUX-IA64.zip -d $ORACLE_HOME
选A
$ORACLE_HOME/OPatch/opatch version



3、配置OCM
grid用户:
cd到grid用户的home目录
cd
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp
遇到:
Email address/User Name: --回车
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y
会产生一个名为ocm.rsp的文件:
ls -l ocm.rsp

4、验证Oracle Inventory
使用grid用户:
$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

使用oracle用户:
$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME


5、解压PSU补丁
grid用户:
mkdir /tmp/orasoft/psu5
将p14727347_112030_HPUX-IA64.zip上传到/tmp/orasoft/psu5
unzip p14727347_112030_HPUX-IA64.zip

6、One-off Patch Conflict Detection and Resolution
grid用户:
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/orasoft/psu5/14727310 -oh  $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/orasoft/psu5/15876003 -oh  $ORACLE_HOME

oracle用户:
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/orasoft/psu5/14727310 -oh  $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir  /tmp/orasoft/psu5/15876003/custom/server/15876003 -oh $ORACLE_HOME


7、手工打补丁(两边)
7.1 oracle用户:
$ORACLE_HOME/bin/emctl stop dbconsole
如果没有安装EM 的话,会报错找不到/oracle/db11g/oc4j/j2ee/OC4J_DBConsole_hostname_sid not found
确认没有dbconsole进程就可以:
ps -ef | grep dbconsole


7.2 oracle用户:
node1:
$ORACLE_HOME/bin/srvctl stop home -o $ORACLE_HOME -s /home/oracle/status -n hostname1
node2:
$ORACLE_HOME/bin/srvctl stop home -o $ORACLE_HOME -s /home/oracle/status -n hostname2


7.3 root用户:
. /home/grid/.profile 
$ORACLE_HOME/crs/install/rootcrs.pl -unlock

root@ylkdb12[+ASM2]/$$ORACLE_HOME/crs/install/rootcrs.pl -unlock
Using configuration parameter file: /grid/grid_home/crs/install/crsconfig_params
CRS-4544: Unable to connect to OHAS
CRS-4000: Command Stop failed, or completed with errors.
The path "/grid/grid_home/bin/acfsrepl_initializer" does not exist
The path "/grid/grid_home/bin/acfssinglefsmount" does not exist
The path "/grid/grid_home/bin/acfsroot" does not exist
The path "/grid/grid_home/lib/acfsregistrymount.pl" does not exist
The path "/grid/grid_home/lib/acfssinglefsmount.pl" does not exist
The path "/grid/grid_home/lib/acfsroot.pl" does not exist
The path "/grid/grid_home/bin/acfsrepl_apply.bin" does not exist
The path "/grid/grid_home/lib/acfstoolsdriver.sh" does not exist
The path "/grid/grid_home/bin/acfsload" does not exist
The path "/grid/grid_home/bin/acfsdriverstate" does not exist
The path "/grid/grid_home/lib/acfsdriverstate.pl" does not exist
The path "/grid/grid_home/lib/acfsload.pl" does not exist
The path "/grid/grid_home/bin/acfsrepl_apply" does not exist
The path "/grid/grid_home/bin/acfsregistrymount" does not exist
Successfully unlock /grid/grid_home
root@ylkdb12[+ASM2]/$


7.4 打CRS补丁
grid用户:
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /tmp/orasoft/psu5/15876003
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /tmp/orasoft/psu5/14727310

7.5 oracle用户执行
/tmp/orasoft/psu5/15876003/custom/server/15876003/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

7.6 打database补丁
oracle用户:
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /tmp/orasoft/psu5/15876003/custom/server/15876003
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /tmp/orasoft/psu5/14727310

7.7 oracle用户执行脚本:
oracle用户:
/tmp/orasoft/psu5/15876003/custom/server/15876003/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME

7.8(两边打完补丁后执行)
root用户执行:
. /home/grid/.profile
$ORACLE_HOME/rdbms/install/rootadd_rdbms.sh
$ORACLE_HOME/crs/install/rootcrs.pl -patch

7.9 此时如果报“ "A system reboot is recommended before using ACFS” ”,重启机器,没报的话就继续,不需重启



检查:
每个节点都执行:
oracle用户:
$ORACLE_HOME/OPatch/opatch lsinventory
grid用户:
$ORACLE_HOME/OPatch/opatch lsinventory

8.0关闭crs
root用户执行
crsctl stop cluster -all
crsctl stop crs


11072246
oracle用户:
cd /tmp/orasoft/psu5
unzip p11072246_112030_HPUX-IA64.zip
cd 11072246
$ORACLE_HOME/OPatch/opatch apply -local
$ORACLE_HOME/OPatch/opatch lsinventory


16084707
oracle用户:
cd /tmp/orasoft/psu5
unzip p16084707_112035_HPUX-IA64.zip
cd 16084707
$ORACLE_HOME/OPatch/opatch apply -local
$ORACLE_HOME/OPatch/opatch lsinventory

14644185
oracle用户:
cd /tmp/orasoft/psu5
unzip p14644185_112035_HPUX-IA64.zip
cd 14644185
$ORACLE_HOME/OPatch/opatch apply -local
$ORACLE_HOME/OPatch/opatch lsinventory

14472647
oracle用户:
cd /tmp/orasoft/psu5
unzip p14472647_112034_HPUX-IA64.zip
cd 14472647
$ORACLE_HOME/OPatch/opatch apply -local
$ORACLE_HOME/OPatch/opatch lsinventory

13496250
oracle用户:
cd /tmp/orasoft/psu5
unzip p13496250_112030_HPUX-IA64.zip
cd 13496250
$ORACLE_HOME/OPatch/opatch apply -local
$ORACLE_HOME/OPatch/opatch lsinventory

13477790
oracle用户:
cd /tmp/orasoft/psu5
unzip p13477790_112030_HPUX-IA64.zip
cd 13477790
$ORACLE_HOME/OPatch/opatch apply -local
$ORACLE_HOME/OPatch/opatch lsinventory

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/28520410/viewspace-1184327/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-06-16

  • 博文量
    80
  • 访问量
    141908