Applying Latest PSU On Grid+RDBMS Homes

Download Below Latest PSU and OPatch zip files from MOS

p6880880_121010_Linux-x86_64.zip---OPatch

p27468957_121020_Linux-x86_64.zip--PSU

Create directory to keep files

As a root user 

cd /oracle/software

mkdir psu

mkdir gpsu

chown oracle:oinstall psu

chown grid:oinstall gpsu

cp p6880880_121010_Linux-x86_64.zip gpsu

cp p27468957_121020_Linux-x86_64.zip gpsu

cp p6880880_121010_Linux-x86_64.zip psu

cp p27468957_121020_Linux-x86_64.zip psu

Applying PSU on GRID Home

Change owner ship to grid user

As root user

cd /oracle/software/gpsu

chown grid:oinstall p6880880_121010_Linux-x86_64.zip

chown grid:oinstall p27468957_121020_Linux-x86_64.zip

As a grid user unzip OPatch on grid home

cd /u01/app/12.1.0.2/grid

unzip -o /oracle/software/gpsu/p6880880_121010_Linux-x86_64.zip

Once OPatch unzipped , Please check Opatch version using below command

. oraenv

+ASM

cd $ORACLE_HOME/OPatch

./opatch version

Now unzip PSU 

As a grid user

cd /oracle/software/gpsu

unzip p27468957_121020_Linux-x86_64.zip

As a root user stop crs services

. oraenv

+ASM

crsctl stop crs(has --if Single Instance) -f

Now Apply PSU on Grid Home

As a root 

. oraenv

+ASM

echo $ORACLE_SID

ASM

echo $ORACLE_HOME

/u01/app/12.1.0.2/grid

nohup $ORACLE_HOME/OPatch/opatchauto apply /oracle/software/gpsu/p27468957 -oh /u01/app/12.1.0.2/grid &

Once Patch applied successfully, Start crsctl services

. oraenv

+ASM

crsctl start crs

Applying PSU on RDBMS Home

Change owner ship to oracleuser

As root user

cd /oracle/software/psu

chown oracle:oinstall p6880880_121010_Linux-x86_64.zip

chown oracle:oinstall p27468957_121020_Linux-x86_64.zip

As a oracle user unzip OPatch on RDBMS home

cd /u01/app/oracle/product/12.1.0.2/dbhome_1

unzip -o /oracle/software/psu/p6880880_121010_Linux-x86_64.zip

Once OPatch unzipped , Please check Opatch version using below command

. oraenv

+DB1

cd $ORACLE_HOME/OPatch

./opatch version

Now unzip PSU 

As a oracle user

cd /oracle/software/psu

unzip p27468957_121020_Linux-x86_64.zip

As a root user stop crs services

. oraenv

+ASM

crsctl stop crs(has --if Single Instance) -f

Now Apply PSU on RDBMS Home

As a root 

. oraenv

+DB1

echo $ORACLE_SID

DB1

echo $ORACLE_HOME

/u01/app/oracle/product/12.1.0.2/dbhome_1

nohup $ORACLE_HOME/OPatch/opatchauto apply /oracle/software/psu/p27468957 -oh /u01/app/oracle/product/12.1.0.2/dbhome_1 &

Once Patch applied successfully, Start crsctl services

. oraenv

+ASM

crsctl start crs

Once RDBMS Patch Applied, source each RDBMS SID then apply Datapatch 

$ORACLE_HOME=/OPatch/datapatch

Finally Check PSU applied status

set pages 4000 lines 4000

col description for a60

select patch_id,version,action,status,description from  dba_registry_sqlpatch;

col verify_queryable_inventory for a30

select dbsm_sqlpatch.verify_veryable_inventory from dual;

************************************************** All The Best *********************************************