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:

      Table 3-3 Input sample for the script

      Input Type	User Input
      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:

   Figure 3-1 Start Application Upgrade

   
   Description of "Figure 3-1 Start Application Upgrade"

   Figure 3-2 Start Application Upgrade

   
   Description of "Figure 3-2 Start Application Upgrade"

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: OBCL INSTALLATION

   First load SMS objects first and then OBCL objects. i.e. Run SMSDBCompileRun.bat and after SMS object loading is completed, then initiate OBCL 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:

   Figure 3-3 Recomp

   
   Description of "Figure 3-3 Recomp"

   Figure 3-4 Recomp

   
   Description of "Figure 3-4 Recomp"

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:

   Figure 3-5 End Application Upgrade

   
   Description of "Figure 3-5 End Application Upgrade"

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:

      Table 3-4 Input sample for the script

      Input Type	User Input
      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:

      Table 3-5 Input sample for the script

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

   Execution Screenshot:

   Figure 3-6 Application Root objects conversion for new objects

   
   Description of "Figure 3-6 Application Root objects conversion for new objects"

   Figure 3-7 Application Root objects conversion for new objects

   
   Description of "Figure 3-7 Application Root objects conversion for new objects"

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:

      Table 3-6 Input sample for the script

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

   Execution Screenshot:

   Figure 3-8 Application Root objects conversion for existing objects

   
   Description of "Figure 3-8 Application Root objects conversion for existing objects"

   Figure 3-9 Application Root objects conversion for existing objects

   
   Description of "Figure 3-9 Application Root objects conversion for existing objects"

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:

   Figure 3-10 Recompilation of Invalids

   
   Description of "Figure 3-10 Recompilation of Invalids"

   Figure 3-11 Recompilation of Invalids

   
   Description of "Figure 3-11 Recompilation of Invalids"
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:

    Figure 3-12 synch

    
    Description of "Figure 3-12 synch"