ORACLE 11.2.0.4 180116 PSU HP 安騰 11.31 安裝

標籤：11.2.0.4 PSU 180116

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

ORACLE 11.2.0.4 180116 PSU HP 安騰 11.31 安裝