ORACLE 11.2.0.4 180116 PSU HP Itanium 11.31 installation

27282436 = 27107360 (PSU) + 26925532 (OJVM)

0. In order to avoid installing patches running data dictionary scripts and system background jobs conflict, view Autotask, if there is enabled, first disable, after the patch and then enable.

Su-oraclesqlplus "/as sysdba" set Lin pages 10000COL client_name format a40col consumer_group format A30col window_gr OUP 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_spac E_group Ora$at_wgrp_sasql Tuning Advisor DISABLED Ora$autotask_sql_group ora$at_wgrp_s Qbegindbms_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;/

Confirm that the current database component status is normal and that the current status is logged:

Set Lin comp_id,status,version pages 10000select from Dba_registry; comp_id STATUS VERSION----------------------------------------------------------- -----------------------OWB VALID 11.2.0.4.0APEX VALI                            D 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.0CATA        LOG 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. Stop listener with the grid user and kill the database session process

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

2. Disable DB Auto start with Oracle user, then stop DB

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

3. (This step has been completed in advance) to replace the Opatch tool with the root user to the latest version

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. Follow the steps below to install the patch

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. Check the root user's environment variables, if there are settings such as oracle_home,ora_grid_home,grid_home, you need to unregister these environment variables, and then re-login system;
B. Check the installation of CRS and DB file system space is sufficient, at least to ensure that 50G free space before patching;
C. Check root/grid/oracle user's crontab job, log off access to $oracle_home and $grid_home jobs before patching, and then enable after patching
D. See if there are grid/oracle independent processes that are not registered in OCR, such as other listener, that kill these processes through kill-9, and if you are not sure which processes are independent
, you may consider stopping the CRS and then pulling them back, then follow the steps

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

Error handling

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

----------the following script for the patch rollback operation----------

######### $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 Itanium 11.31 installation