3.2 Patch-set Application Step by Step with Screenshots

This topic provides systematic instructions to patch-set application step by step with screenshots.

1. Start Application upgrade
   1. Login into the Approot Schema as Common user.
   2. Run 01_Start_Upgrade.sql for initiating the application upgrade.
   3. User input has to be inputted for the below:

      Spool Path	<< Any local path>>
      Application next version	14.4.0.0.0

   4. Script will be executed as in the screen shot below and keep the SQL Plus session open for upcoming steps.

   Execution Screenshot:

   
   

   
   Description of the illustration 3.1.2_s1_start-application-upgrade-1.png

   
   
   

   
   Description of the illustration 3.1.2_s1_start-application-upgrade-2.png

   
   

2. Compiling Incremental Units
   1. Make sure that the fcubs.properties and env.properties are updated with approot schema details.
   2. Run the <Product Processor>DBCompileRun.bat from <Patchset>\INSTALLER\SOFT directory. DDL Compilation, Object Compilation and Static Data load will be done.

   For Example: OBTF INSTALLATION

   First load SMS objects first and then OBTF objects. i.e. Run SMSDBCompileRun.bat and after SMS object loading is completed, then initiate OBTF compilation Run TFDBCompileRun.bat

3. Recompilation of invalids
   1. Login into the Approot Schema as Common user
   2. Run 03_Invalids_Recompilation.sql for recompiling the invalids during application upgrade.
   3. No user input is required for this step.
   4. Script will be executed as in the screen shot below and keep the SQL Plus session open for upcoming steps.

   Execution Screenshot:

   
   

   
   Description of the illustration 3.1.2_s3_compiling-incremental-units_1.png

   
   
   

   
   Description of the illustration 3.1.2_s3_compiling-incremental-units_2.png

   
   

4. End Application upgrade
   1. Login into the Approot Schema as Common user.
   2. Run 06_End_Upgrade.sql for recompiling the invalids during application upgrade.
   3. No user input is required for this step.
   4. Script will be executed as in the screen shot below.

   Execution Screenshot:

   
   

   
   Description of the illustration 3.1.2_s4_end-application-upgrade.png

   
   

5. Start Application upgrade
   1. Login into the Approot Schema as Common user.
   2. Run 05_Start_Upgrade.sql for initiating the application upgrade.
   3. User input has to be inputted for the below:

      Spool Path	<< Any local path>>
      Application next version	14.4.0.0.0

   4. Script will be executed similar to step 1 above and keep the SQL Plus session open for upcoming steps.
6. Application Root objects conversion for new objects
   1. Login into the Approot Schema as Common user.
   2. Run 06_New_Object_Conversion.sql for converting new approot objects added during patch-set as DL
   3. User input has to be inputted for the below:

      Spool Path	<< Any local path>>
      Application next version	HUBUSER (common user name)

   Execution Screenshot:

   
   

   
   Description of the illustration 3.12_s6_application-root-objects.png

   
   
   

   
   Description of the illustration 3.12_s6_application-root-objects-2.png

   
   

7. Application Root objects conversion for existing objects
   1. Login into the Approot Schema as Common user.
   2. Run 07_Object_Conversion.sql for initiating the application upgrade.
   3. User input has to be inputted for the below:

      Spool Path	<< Any local path>>
      Application next version	HUBUSER (common user name)

   Execution Screenshot:

   
   

   
   Description of the illustration 3.12_s7_application-root-objects-1.png

   
   
   

   
   Description of the illustration 3.12_s7_application-root-objects-2.png

   
   

8. Recompilation of invalids
   1. Login into the Approot Schema as Common user.
   2. Run 08_Invalids_Recompilation.sql for recompiling the invalids during application upgrade.
   3. No user input is required for this step.
   4. Script will be executed as in the screen shot below and keep the SQL Plus session open for upcoming steps.

   Execution Screenshot:

   
   

   
   Description of the illustration 3.12_s8_recompilation-invalids_1.png

   
   
   

   
   Description of the illustration 3.12_s8_recompilation-invalids_2.png

   
   

9. End Application upgrade
   1. Login into the Approot Schema as Common user.
   2. Run 06_End_Upgrade.sql for recompiling the invalids during application upgrade.
   3. No user input is required for this step.
   4. Script will be executed as that of step 4.
10. Synchronize application PDBs
    1. Login into the PDB Schema as Common user. For each PDB, this steps has to be done individually.
    2. Run 07_PDB_Sync.sql for synching the application upgrade with PDBs.
    3. No user input is required for this step.
    4. Script will be executed as in the screen shot below.

    Execution Screenshot:

    
    

    
    Description of the illustration 3.12_s10_synchronize-application.png