STEPS FOR APPLYING PSU ON ORACLE 11G DATABASE AND GRID HOME.

STEPS FOR APPLY PSU6 ON ORACLE 11G DATABASE AND GRID HOME.

1.    Download the PSU6 for 11.2.0.4 Grid Infrastructure (Patch Number 20485808) from https://support.oracle.com for according to your operating system and version.

2.    Login as grid user and unzip the patch

$ cd /u02/orabackup/patch/PSU6

$ unzip p20485808 solarix-64.zip

3.    Check the Opatch utility version and Patch applied on Both Oracle and GRID home before applying PSU6. By running below command

                                          i.    $ORACLE_HOME/OPatch/opatch version (check version is upgraded)

                                         ii.    $ORCLE_HOME/OPatch/opatch lsinventory(check inventory is displayed without any errors)

                                        iii.    $GRID_HOME/OPatch/opatch version (check version is upgraded)

                                       iv.    $GRID_HOME/OPatch/opatch lsinventory(check inventory is displayed without any errors)

Note:-Opatch utility should be of latest version before applying PSU. If you don’t have latest Opatch version you can download  it via oracle support.

4.    Create OCM response file for database home.  (Login as oracle user)

$. oraenv

  orcl

$ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /u02/orabackup/ocmrep_PSU6.rsp

5.    Stop database (oracle user)

srvctl stop database -d  orcl

6.    Apply patch on GI home from Root user.

bash-3.2# id

uid=0(root) gid=0(root)

bash-3.2# cd /u02/orabackup/patch/PSU6/20485808

bash-3.2# hostname

orclserver

bash-3.2# /u01/app/grid/product/11.2.0/grid/OPatch/opatch auto /u02/orabackup/patch/PSU6/20485808 -ocmrf /u02/orabackup/ocmrep_PSU6.rsp

Executing /u01/app/grid/product/11.2.0/grid/perl/bin/perl /u01/app/grid/product/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u02/orabackup/patch/PSU6 -patchn 20485808 -ocmrf /u02/orabackup/ocmrep_PSU6.rsp -paramfile /u01/app/grid/product/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/grid/product/11.2.0/grid/cfgtoollogs/opatchauto2015-12-08_19-30-15.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/app/grid/product/11.2.0/grid/cfgtoollogs/opatchauto2015-12-08_19-30-15.report.log

2015-12-08 19:30:15: Starting Oracle Restart Patch Setup

Using configuration parameter file: /u01/app/grid/product/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0.4/dbhome_1 ...

Stopped RAC /u01/app/oracle/product/11.2.0.4/dbhome_1 successfully

patch /u02/orabackup/patch/PSU6/20485808/20299013  apply successful for home  /u01/app/oracle/product/11.2.0.4/dbhome_1

patch /u02/orabackup/patch/PSU6/20485808/20420937/custom/server/20420937  apply successful for home  /u01/app/oracle/product/11.2.0.4/dbhome_1

Stopping CRS...

Stopped CRS successfully

patch /u02/orabackup/patch/PSU6/20485808/20299013  apply successful for home  /u01/app/grid/product/11.2.0/grid

patch /u02/orabackup/patch/PSU6/20485808/20420937  apply successful for home  /u01/app/grid/product/11.2.0/grid

patch /u02/orabackup/patch/PSU6/20485808/20299019  apply successful for home  /u01/app/grid/product/11.2.0/grid

Starting CRS...

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

Starting RAC /u01/app/oracle/product/11.2.0.4/dbhome_1 ...

Started RAC /u01/app/oracle/product/11.2.0.4/dbhome_1 successfully

opatch auto succeeded.

7.    Change permission of oracle binaries (grid user)

$. oraenv

+ASM

$ls -lrth /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle 

$ORACLE_HOME/bin/setasmgidwrap o=/u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle

$ls -lrth /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle

8.    Check opatch lsinventory once patch is applied from both grid and oracle (rdbms) home and start database.

ORACLE USER

$. oraenv

orcl

     $ $ORACLE_HOME/OPatch/opatch lsinventory

     GRID  USER

$. oraenv

orcl

     $ $ORACLE_HOME/OPatch/opatch lsinventory

9.    Check the status of ASM resource and start the Oracle database.

     (from grid home only)

     $crsctl stat res -t

(from database home only)

     $srvctl start database -d  orcl

Note  : In case database is not started using srvctl start it using sqlplus command

           

10.  Apply PSU to database.

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> STARTUP

SQL> @catbundle.sql psu apply

SQL> QUIT

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> @utlrp.sql