11204 Dozen Latest Patches (24436338)

October 18, 2016 Oracle released the latest patch with a 11204 RAC on hand (Patch auto patching).

I. Environment

1. Database environment

Operating system version: CentOS 6.7

Database version: Oracle 11.2.0.4 RAC

grid:11.2.0.4

Oracle database:11.2.0.4

2. Preparing content

GI Psu:p24436338_112040_linux-x86-64.zip

Opatch:p6880880_112000_linux-x86-64.zip

Second, update Opatch version

opatch:https://updates.oracle.com/download/6880880.html Update the Opatch version on two nodes respectively:

[[EMAIL PROTECTED] ~]# CD /APPS/11.2.0/GRID[[EMAIL PROTECTED] GRID]# MV  OPatch OPatch.bak[[email protected] ~]# cd /apps/11.2.0/grid[[email  protected] grid]# mv opatch opatch.bak[[email protected] ~]# cd /apps/ oracle/11.2.0/db_1[[email protected] db_1]# mv opatch opatch.bak[[email  protected] ~]# cd /apps/oracle/11.2.0/db_1[[email protected] db_1]# mv  opatch opatch.bak[[email protected] ~]# cp p6880880_112000_linux-x86-64.zip / apps/11.2.0/grid/[[email protected] ~]# cd /apps/11.2.0/grid/[[email protected]  Grid]# unzip p6880880_112000_linux-x86-64.zip [[email protected] grid]# chown  -r grid:oinstall opatch[[email protected] ~]# cp p6880880_112000_ Linux-x86-64.zip /apps/11.2.0/grid/[[email protected] ~]# cd /apps/11.2.0/grid/[[email protected] grid]# unzip  P6880880_112000_linux-x86-64.zip [[email protected] grid]# chown -r grid:o install opatch[[email protected] ~]# cp p6880880_112000_linux-x86-64.zip /apps/ oracle/11.2.0/db_1/[[email protected] ~]# cd /apps/oracle/11.2.0/db_1/[[email  Protected] db_1]# unzip p6880880_112000_linux-x86-64.zip [[email protected] db_1 ]# chown -r oracle:oinstall opatch[[email protected] ~]# cp p6880880_ 112000_linux-x86-64.zip /apps/oracle/11.2.0/db_1/[[email protected] ~]# cd /apps/ oracle/11.2.0/db_1/[[email protected] db_1]# unzip p6880880_112000_linux-x86-64.zip [ [Email protected] db_1]# chown -r oracle:oinstall opatch

Three. Upload the patch to all nodes and unzip

[Email protected] apps]# unzip P24436338_112040_linux-x86-64.zip[[email protected] apps]# chown-r Grid:oinstall 24436338[[email protected] apps]# unzip P24436338_112040_linux-x86-64.zip[[email protected] apps]# chown-r grid:o Install 24436338

Four. Check if the required patches conflict with existing patches

[[Email protected] apps]$ CD 24436338/[[email protected] 24436338]$ $ORACLE _home/opatch/opatch prereq Checkconflictagainstohwithdetail-ph./[[email protected] apps]$ CD 24436338/[[email protected] 24436338]$ $ORACLE _home /opatch/opatch prereq checkconflictagainstohwithdetail-ph.

Six. Verifying inventory consistency

[Email protected] 24436338]$ $ORACLE _home/opatch/opatch lsinventory-detail-oh $ORACLE _home[[email protected] 24436338]$ $ORACLE _home/opatch/opatch Lsinventory-detail-oh $ORACLE _home

Seven. Configuring the OCM Response file

[[email protected] apps]# mkdir/apps/psu[[email protected] apps]# chown-r grid:oinstall psu[[email protected] apps]# su -Grid[[email protected] ~]$ CD $ORACLE _home/opatch/ocm/bin[[email protected] bin]$./EMOCMRSP-NO_BANNER-OUTPUT/APPS/1 1.2.0/grid/opatch/ocm/bin/ocm.rsp[[email protected] apps]# mkdir/apps/psu[[email protected] apps]# chown-r grid:o Install Psu[[email protected] apps]# Su-grid[[email protected] ~]$ CD $ORACLE _home/opatch/ocm/bin[[email protected] bin] $./EMOCMRSP-NO_BANNER-OUTPUT/APPS/11.2.0/GRID/OPATCH/OCM/BIN/OCM.RSP

Eight. Opatch apply (all nodes need to be executed) (no need to close any components and resources)

Users with root privileges can automatically use the PSU for GI and db. Must be performed at every node, and GI home and DB home are not shared. And two nodes cannot be executed in parallel.

[Email protected] ~]#/apps/11.2.0/grid/opatch/opatch auto/psu/24436338/-ocmrf/apps/11.2.0/grid/opatch/ocm/bin/ Ocm.rsp[[email protected] 11.2.0]#/apps/11.2.0/grid/opatch/opatch auto/psu/24436338/-ocmrf/apps/11.2.0/grid/ Opatch/ocm/bin/ocm.rsp

Grid user authentication:

Su-grid

Opatch lsinventory

Oracle User authentication:

Su-oracle

Opatch lsinventory

You may encounter problems in this step: the Opatch minimum version check for patch is generally reported

The possible causes are:

The. Patch_storage directory is not created under the/home/grid/directory

Grid user's $oracle_home does not have write permission

No patch is unpacked in an empty directory

Nine. Upgrade data dictionary (run only on one node)

cd  $ORACLE _home/rdbms/admin[[email protected] admin]$ sqlplus / as  sysdbasql>  @catbundle .sql psu applysql> set line 150sql> col  Action_time for a30sql> col action for a8sql> col namespace  for a8sql> col version for a10sql> col bundle_series for  a5sql> col comments for a40sql> select * from dba_registry _history; action_time                     ACTION   NAMESPAC VERSION             id bundl comments------------------------------ --------  -------- ---------- ---------- ----- ----------------------------------------24- Aug-13 12.03.45.119862&nbsP pm   apply    server   11.2.0.4             0 psu   patchset 11.2.0.2.024-oct-16  04.57.07.916237 am   apply    server   11.2.0.4             0 psu   patchset  11.2.0.2.024-oct-16 10.49.21.585728 am   apply    server    11.2.0.4       161018 PSU   PSU  11.2.0.4.1610183 rows selected.

Read the Readme before you hit the patch

This article is from the "just out of the shell of the Birds" blog, please be sure to keep this source http://qhd2004.blog.51cto.com/629417/1865269

11204 Dozen Latest Patches (24436338)