首页 > 数据库 > Oracle > Oracle11gR2打补丁
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/ ,如需转载,请注明出处,否则将追究法律责任。