Apply PSU6 Manually

In this post I am describing how to manually apply the PSU patch on both GI home and RAC Home respectively. 

when one uses opatch auto the whole process is automated which we are going to do manually. Opatch will check the applicability of the each component of the PSU patch and apply it on GI OR RAC home accordingly. 


##
## APPLY PSU 6 i.e. patch 20834621
##
PSU 6 has following patch components. One has to apply this components both on GI home and RAC Home. 
Before starting the patch process, make sure you dont have any conflicts with prior applied patches.


GI PSU - 
GI PSU component         - 20485808
DB PSU - 20299013
OCW Component - 20420937
ACFS Component - 20299019 

Process - 

root@host301[/ora00/app/11.2.0.4/grid/crs/install]# ./roothas.pl -unlock
Using configuration parameter file: ./crsconfig_params

Successfully unlock /ora00/app/11.2.0.4/grid


Run the pre root script. If this is a GI Home, as the root user execute:
# /ora00/app/11.2.0.4/grid/crs/install/roothas.pl -unlock



##
## RUN SLIBCLEAN AS ROOT( only for AIX )
##
root@host401[/ora00/app/11.2.0.4/grid]# /usr/sbin/slibclean


PATCH - 20834621

Apply the CRS patch using grid user. As the GI home owner execute:

$ /ora00/app/11.2.0.4/grid/OPatch/opatch apply -oh /ora00/app/11.2.0.4/grid -local /11204_PSU6/20834621/20485808/20420937

Patching component oracle.crs, 11.2.0.4.0...

Verifying the update...
Patch 20420937 successfully applied
Log file location: /ora00/app/11.2.0.4/grid/cfgtoollogs/opatch/opatch2015-05-01_18-12-49PM_1.log

OPatch succeeded.

##

As the GI home owner execute:
$ /ora00/app/11.2.0.4/grid/OPatch/opatch apply -oh /ora00/app/11.2.0.4/grid -local /11204_PSU6/20834621/20485808/20299019

Patching component oracle.usm, 11.2.0.4.0...

Verifying the update...
Patch 20299019 successfully applied
Log file location: /ora00/app/11.2.0.4/grid/cfgtoollogs/opatch/opatch2015-05-01_18-23-01PM_1.log

OPatch succeeded.

##


As the GI home owner execute:
$ /ora00/app/11.2.0.4/grid/OPatch/opatch apply -oh /ora00/app/11.2.0.4/grid -local /11204_PSU6/20834621/20485808/20299013

Composite patch 20299013 successfully applied.
OPatch Session completed with warnings.
Log file location: /ora00/app/11.2.0.4/grid/cfgtoollogs/opatch/opatch2015-05-01_18-24-59PM_1.log

OPatch completed with warnings.

Composite patch 20299013 successfully applied.
OPatch Session completed with warnings.
Log file location: /ora00/app/11.2.0.4/grid/cfgtoollogs/opatch/opatch2015-05-01_18-24-59PM_1.log

OPatch completed with warnings.


AS ORACLE USER - 

Run the pre script for DB component of the patch. As the database home owner execute:
$ /11204_PSU6/11204_PSU6/20834621/20485808/20420937/custom/scripts/prepatch.sh -dbhome /ora01/app/oracle/product/11.2.0.4/db_1

Apply the DB patch. As the database home owner execute:

$ /ora01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch apply -oh /ora01/app/oracle/product/11.2.0.4/db_1 -local /11204_PSU6/11204_PSU6/20834621/20485808/20420937/custom/server/20420937

Patching component oracle.rdbms, 11.2.0.4.0...

Verifying the update...
Patch 20420937 successfully applied
Log file location: /ora01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2015-05-01_19-33-25PM_1.log

OPatch succeeded.

$ /ora01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch apply -oh /ora01/app/oracle/product/11.2.0.4/db_1 -local /11204_PSU6/20834621/20485808/20299013

Composite patch 20299013 successfully applied.
OPatch Session completed with warnings.
Log file location: /ora01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2015-05-01_19-35-30PM_1.log

OPatch completed with warnings.



Run the post script for DB component of the patch. As the database home owner execute:
$ /11204_PSU6/20834621/20485808/20420937/custom/scripts/postpatch.sh -dbhome /ora01/app/oracle/product/11.2.0.4/db_1

Reapplying file permissions on /ora01/app/oracle/product/11.2.0.4/db_1/srvm/admin/ractrans
Reapplying file permissions on /ora01/app/oracle/product/11.2.0.4/db_1/srvm/admin/getcrshome
Reapplying file permissions on /ora01/app/oracle/product/11.2.0.4/db_1/bin/gnsd
Reapplying file permissions on /ora01/app/oracle/product/11.2.0.4/db_1/bin/crsdiag.pl
Postpatch completed successfully


Run the post script. As the root user execute:
# /ora00/app/11.2.0.4/grid/rdbms/install/rootadd_rdbms.sh

-- 
If this is a GI Home, as the root user execute:
# /ora00/app/11.2.0.4/grid/crs/install/roothas.pl -patch

Using configuration parameter file: /ora00/app/11.2.0.4/grid/crs/install/crsconfig_params
ACFS driver install actions failed
CRS-4123: Oracle High Availability Services has been started.

The following steps load modified SQL files into the database. For an Oracle RAC environment, perform these steps on only one node.

Install the SQL portion of the patch by running the following command. For an Oracle RAC environment, reload the packages on one of the nodes.

# cd $ORACLE_HOME/sqlpatch/20406239
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> startup upgrade
SQL> @postinstall.sql
SQL> shutdown
SQL> startup 

Now run the following script for each database running out of this RDBMS Home.

SQL> $ORACLE_HOME/rdbms/admin/catbundle.sql PSU APPLY 

After installing the SQL portion of the patch, some packages could become INVALID. This will get recompiled upon access or you can run utlrp.sql to get them back into a VALID state.

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

Hope this helps...