Oracle- Patching steps- Rollforward

Instructions to be applied for the databases running on version 11.2.0.4

Pre Release Activity :
======================

1. Take the backup of the complete database using data pumps.
2. Shutdown Apache & Tomcat Services in application host.
3. Check the invalid objects count in schema user by running the query
    sql> select object_name, object_type from user_objects where status='INVALID';


Rollforward :

1. Shutdown all the services related to Oracle by navigating to start -> Run -> Services.msc
    i) Make sure no services related to oracle are running.
    ii) Make sure no files related to oracle softwares are in use by another fore and background processes.
1.1 Stop msdtc using
    Logon to command prompt using administrator
    net stop msdtc
2. Copy the patch zip file (p21821802_112040_MSWIN-x86-64.zip) from remote host D:\oracle_patches\11.2.0.3 to destination server under d:\patches.
3. Copy the Opatch software zip file (p6880880_112000_MSWIN-x86-64.zip) from remote host (172.26.0.43) D:\oracle_patches\OPatch to destination server under d:\patches.
4. unzip p21821802_112040_MSWIN-x86-64.zip & p6880880_112000_MSWIN-x86-64.zip
    4.1) This creates folders 21821802 & OPatch
5. Navigate to %ORACLE_HOME% in windows explorer and rename OPatch directory to OPatch_Old
6. Copy d:\patches\OPatch directory to %ORACLE_HOME%
7. Open command prompt in Administrator mode and perform the below :
    7.1) SET ORACLE_HOME=<PATH_OF_ORACLE_HOME>
    7.2) SET PATH=%ORACLE_HOME%\bin;%ORACLE_HOME%\OPatch\;%ORACLE_HOME%\perl\bin;%PATH%
    7.3) sqlplus / as sysdba
    7.4) shutdown immediatae
    7.5) exit
    7.6) cd d:\patches\21821802\
    7.7) opatch apply
        7.7.1) Most probably the patch may fail if any files related to oracle are in use. Kill them manually.
    7.8) Inspect the opatch<timestamp>.log file generated in %ORACLE_HOME%\cfgtoollogs\opatch for any errors.
    7.9) When patch applied, connect to the database and start the database and listener services from start -> run -> services.msc
    7.10) start msdtc using
        Logon to command prompt using administrator
        net start msdtc
8. Check the invalid objects count in schema user by running the query and the invalid objects count should be matching with the count executed in pre release step.
    sql> select object_name, object_type from user_objects where status='INVALID';
9. start the Apache & Tomcat services in application host.
10. Perform the sanity of the application.