ORACLE 11.2.0.4 180116 PSU HP 安腾 11.31 安装

27282436 = 27107360 (PSU) + 26925532 (OJVM)

0.为了避免安装补丁运行数据字典脚本时与系统后台作业冲突，查看AutoTask，如果有Enabled的，先Disable，打完补丁后再Enable.

su - oraclesqlplus "/as sysdba"set lin 180 pages 10000COL CLIENT_NAME FORMAT A40COL CONSUMER_GROUP FORMAT A30COL WINDOW_GROUP FORMAT A30select CLIENT_NAME,STATUS,CONSUMER_GROUP,WINDOW_GROUP from dba_autotask_client;CLIENT_NAME                              STATUS   CONSUMER_GROUP                 WINDOW_GROUP---------------------------------------- -------- ------------------------------ ------------------------------auto optimizer stats collection          ENABLED  ORA$AUTOTASK_STATS_GROUP       ORA$AT_WGRP_OSauto space advisor                       DISABLED ORA$AUTOTASK_SPACE_GROUP       ORA$AT_WGRP_SAsql tuning advisor                       DISABLED ORA$AUTOTASK_SQL_GROUP         ORA$AT_WGRP_SQBEGINDBMS_AUTO_TASK_ADMIN.DISABLE(client_name => 'auto optimizer stats collection', operation => NULL, window_name => NULL);END;/BEGINDBMS_AUTO_TASK_ADMIN.DISABLE(client_name => 'auto space advisor', operation => NULL, window_name => NULL);END;/BEGINDBMS_AUTO_TASK_ADMIN.DISABLE(client_name => 'sql tuning advisor', operation => NULL, window_name => NULL);END;/

再确认当前的数据库组件状态是否都正常，并记录当前状态：

set lin 170 pages 10000select comp_id,status,version from dba_registry;COMP_ID                        STATUS                 VERSION------------------------------ ---------------------- ------------------------------OWB                            VALID                  11.2.0.4.0APEX                           VALID                  3.2.1.00.12EM                             VALID                  11.2.0.4.0AMD                            VALID                  11.2.0.4.0SDO                            VALID                  11.2.0.4.0ORDIM                          VALID                  11.2.0.4.0XDB                            VALID                  11.2.0.4.0CONTEXT                        VALID                  11.2.0.4.0EXF                            VALID                  11.2.0.4.0RUL                            VALID                  11.2.0.4.0OWM                            VALID                  11.2.0.4.0CATALOG                        VALID                  11.2.0.4.0CATPROC                        VALID                  11.2.0.4.0JAVAVM                         VALID                  11.2.0.4.0XML                            VALID                  11.2.0.4.0CATJAVA                        VALID                  11.2.0.4.0APS                            VALID                  11.2.0.4.0XOQ                            VALID                  11.2.0.4.0RAC                            VALID                  11.2.0.4.019 rows selected.

1.以grid用户停止listener，并kill数据库会话进程

su - gridsrvctl stop listenersrvctl stop scan_listenerkill -9 `ps -ef|grep LOCAL=NO|grep -v grep|grep -iv ASM|awk '{print $2}'`

2.以oracle用户禁用db自动启动，然后停止db

su - oraclesrvctl disable db -d pubdbsrvctl stop db -d pubdb

3.（该步骤已经提前执行完成）以root用户替换opatch工具到最新版本

su - rootcat /home/oracle/.profile | grep HOMEexport PATCH_DIR=/oracle/softwareexport PATCH_GRID_HOME=/grid/app/11.2.0.4/gridexport PATCH_ORACLE_HOME=/oracle/app/oracle/11.2.0.4/db_1mv $PATCH_GRID_HOME/OPatch $PATCH_GRID_HOME/Opatch.orig`date +%Y%m%d`mv $PATCH_ORACLE_HOME/OPatch $PATCH_ORACLE_HOME/OPatch.orig`date +%Y%m%d`cd $PATCH_DIRunzip p6880880_112000_HPUX-IA64.zipcp -r ./OPatch $PATCH_GRID_HOME/cp -r ./OPatch $PATCH_ORACLE_HOME/cd $PATCH_GRID_HOME/; chown -R grid:oinstall ./OPatchcd $PATCH_ORACLE_HOME/; chown -R oracle:oinstall ./OPatch

4.按照下面的步骤安装补丁

su - oracleexport PATCH_DIR=/oracle/softwarecd $ORACLE_HOME/OPatch/ocm/bin./emocmrsp -output /tmp/ocm.rspcd $PATCH_DIRunzip p27282436_112040_HPUX-IA64.zipsu - root

a.检查root用户的环境变量，如果有ORACLE_HOME,ORA_GRID_HOME,GRID_HOME等设置，需要注销这些环境变量，然后重新登录系统；
b.检查安装crs和db的文件系统空间是否足够，打补丁前至少要保证50G空闲空间；
c.检查root/grid/oracle用户的crontab作业，打补丁前先注销访问$ORACLE_HOME和$GRID_HOME的作业，打完补丁后再启用
d.查看是否有未注册到OCR里的grid/oracle独立进程，例如其他的listener，通过kill -9 杀掉这些进程；如果不确定哪些进程是独立的
，可以考虑先停止CRS后再重新拉起来，然后执行后续的步骤

su - rootexport PATCH_DIR=/oracle/softwareexport PATCH_GRID_HOME=/grid/app/11.2.0.4/gridexport PATCH_ORACLE_HOME=/oracle/app/oracle/11.2.0.4/db_1export PSU_PATCH_ID=27282436/27107360

# $PATCH_GRID_HOME/OPatch/opatch auto $PATCH_DIR/$PSU_PATCH_ID -oh $PATCH_GRID_HOME -ocmrf /tmp/ocm.rsp# $PATCH_ORACLE_HOME/OPatch/opatch auto $PATCH_DIR/$PSU_PATCH_ID -oh $PATCH_ORACLE_HOME -ocmrf /tmp/ocm.rsp

报错处理

Opatch version check failed for oracle home /grid/app/11.2.0.4/grid
Opatch version check failed
ERROR: update the opatch version for the failed homes and retry

UtilSession failed: IPMRWServices::verifyPatchStorageDirectory() cannot read or write to /grid/app/11.2.0.4/grid/.patch_storage

OPatch failed with error code 73

CRMAPP3#[/]#cd /grid/app/11.2.0.4/grid/CRMAPP3#[/grid/app/11.2.0.4/grid]#mkdir .patch_storageCRMAPP3#[/grid/app/11.2.0.4/grid]#chown grid:oinstall .patch_storage

----------以下脚本用于补丁回滚操作----------

######### $PATCH_GRID_HOME/OPatch/opatch auto $PATCH_DIR/$PSU_PATCH_ID -rollback -oh $PATCH_GRID_HOME -ocmrf /tmp/ocm.rsp######### $PATCH_ORACLE_HOME/OPatch/opatch auto $PATCH_DIR/$PSU_PATCH_ID -rollback -oh $PATCH_ORACLE_HOME -ocmrf /tmp/ocm.rspsu - grid$ORACLE_HOME/OPatch/opatch lsinvsu - oracle$ORACLE_HOME/OPatch/opatch lsinv