April 14, 2012

How to Patch PSU on Grid and Database

How to Patch oracle 11.2.0.3 to 11.2.0.3.1 with PSU 13348650


After Installing RAC 11.2.0.3 in one of my client, i wondering why is alert.log from root use asmcmd places in user directory, after struggling and searching finally i found that is a bug and those are one of the bug and i have to patch with PSU 13348650


"ROOT USE OF ASMCMD PLACES ALERT.LOG IN USER DIRECTORY"


my environment is

1. Grid Home and Oracle Home is not share

2. The Operating System is solaris sparc 64 bit


here is the summary the way to patch

1. Download and unzip opatch utility

2. Generate response file

3. Finally patch the GI Home and Database Home


1. Download and unzip patch utility

In order to do it by automatically you must use the OPatch utility version 11.2.0.1.8 or later to apply this patch. Oracle recommends that you use the latest released OPatch for 11.2 releases, which is available for download from My Oracle Support patch 6880880 by selecting ARU link for the 11.2.0.0.0 release. It is recommended that you download the Opatch utility and the patch in a shared location to be able to access them from any node in the cluster for the patch application on each node


a. Download the OPatch utility to a temporary directory.For each Oracle RAC database home and the GI home that are being patched, run the following commands as the home owner to extract the OPatch utility.

unzip Opatchxxx.ZIP -d $ORACLE_HOME/

b. Verify the Opatch Version

$ORACLE_HOME/OPatch/opatch version

and the the version output of the previous command should be 11.2.0.1.8 or later.



2. Generate response file

As the Grid home owner execute

$ORACLE_HOME/OPatch/ocm/bin/emocmrsp


3. Finally patch the GI Home and Database Home

Follow these instructions in this section if the GI home is not shared and none of the Oracle database homes is shared. As root user execute the following command on each node of the cluster:

opatch auto /UNZIPPED_PATCH_LOCATION/ -ocmrf /OcmFIleFolder/ocm.rsp


root# export PATH=$PATH:/apps/11.2.0/grid/OPatch


root# opatch auto /export/home/oracle/patch -ocmrf /export/home/grid/opatch/ocm.rsp

Executing /usr/bin/perl /apps/11.2.0/grid/OPatch/crs/patch112.pl -patchdir /export/home/oracle -patchn patch -ocmrf /export/home/grid/opatch/ocm.rsp -paramfile /apps/11.2.0/grid/crs/install/crsconfig_params

opatch auto log file location is /apps/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2012-04-11_11-59-25.log

Detected Oracle Clusterware install

Using configuration parameter file: /apps/11.2.0/grid/crs/install/crsconfig_params

patch /export/home/oracle/patch/13348650/custom/server/13348650 apply successful for home /apps/oracle/product/11.2.0/db_1

patch /export/home/oracle/patch/13343438 apply successful for home /apps/oracle/product/11.2.0/db_1

Successfully unlock /apps/11.2.0/grid

patch /export/home/oracle/patch/13348650 apply successful for home /apps/11.2.0/grid

patch /export/home/oracle/patch/13343438 apply successful for home /apps/11.2.0/grid

ACFS-9300: ADVM/ACFS distribution files found.

ACFS-9312: Existing ADVM/ACFS installation detected.

ACFS-9314: Removing previous ADVM/ACFS installation.

ACFS-9315: Previous ADVM/ACFS components successfully removed.

ACFS-9307: Installing requested ADVM/ACFS software.

ACFS-9308: Loading installed ADVM/ACFS drivers.

ACFS-9154: Loading 'oracleoks' driver.

ACFS-9154: Loading 'oracleadvm' driver.

ACFS-9154: Loading 'oracleacfs' driver.

ACFS-9327: Verifying ADVM/ACFS devices.

ACFS-9156: Detecting control device '/dev/asm/.asm_ctl_spec'.

ACFS-9156: Detecting control device '/dev/ofsctl'.

ACFS-9309: ADVM/ACFS installation correctness verified.

CRS-4123: Oracle High Availability Services has been started.


while the patch is running parallelly you can see the patch log with this command

root# tail -f apps/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2012-04-11_11-59-25.log



No comments:

Post a Comment