GRC Upgrade from 8.6.3.6001 to 8.6.3.6036 for TOMCAT

Pre Checks

1. Note down the configuration Home page settings

 login to the GRC url with admin user/password

 Note: If you face issues to get GRC application page, Uncheck all the settings in your Web Browser LAN Settings Section in Connect Tab and try again.

 Click on Navigator(Drop down from top left corner) --> Administration Management --> Manage Application Configurations

 (Take screen shoot of all the tabs and also note down all the values)

Upgrade steps

2. login as tomcat user to the tomcat Application server

   Shut down the Tomcat application server

    /<sid>/ias/AACG863/tomcat/bin/shutdown.sh

   login as db user to DB server

    Shutdown database

    sqlplus "/as sysdba"

    SQL> shut immediate

    SQL> exit

   Stop Listener

    lsnrctl stop <Listener Name>

3. Take cold backup of df -h /sid/* file systems. Make sure cold snap is taken before proceeding onto next step

4.Start the DB and Listener

  Login as db user to DB server

   sqlplus "/as sysdba"

    SQL> startup

    SQL> exit

    lsnrctl start <Listener Name>

5.login as tomcat user to the tomcat Application server

  Remove the directory <TomcatHome>/webapps/grc

     rm -rf /sid/ias/AACG863/tomcat/webapps/grc

  Remove the grc directory from the Tomcat work area (<TomcatHome>/work/Catalina/localhost/grc).

     rm -rf /sid/ias/AACG863/tomcat/work/Catalina/localhost/grc

6.  Run the file grc_tomcat_setup.sh to upgrade 8.6.3.6012 , Patch: 13931550

   ## ./grc_tomcat_setup.sh <grc_patch_stage>/dist <TomcatHome> JavaHomePath

 ex:  /<patch location>/13931550/dist/grc_tomcat_setup.sh /<patch location>/13931550/dist /sid/ias/AACG863/tomcat  /usr/java/jdk1.6.0_24/

7. Start the Tomcat application server.

   /sid/ias/AACG863/tomcat/bin/startup.sh

8.Access GRC at https://hostname.domain:port/grc, and fill out configuration as previously noted down in Step 1 and fill configurations

9. In the Manage Application Configurations page, click on Actions ? Save. GRC tests the values you’ve entered and, if they are valid, saves them.

(If any are in-valid, an error message instructs you to re-enter them.)

10. Exit the Manage Application Configurations page.

11. Shut down the Tomcat application server.

   /sid/ias/AACG863/tomcat/bin/shutdown.sh

12. Start the Tomcat application server.

   /sid/ias/AACG863/tomcat/bin/startup.sh

13. Wait till we see message like "Application Deployment Complete Successful" in grc.log file(tail -100f grc.log).

location : /sid/ias/AACG863/tomcat/webapps/grc/log

This will display the upgrade messages (Note: if Debug option was selected then additional upgrade messages will appear).

14. In a web browser, enter the GRC URL, You will be redirected to a GRC logon page. Log on to the application and check about for version of GRC.

15. After the successful patch deployment, run the data sync

 Drop down tab Navigator --> Administration Management --> Manage Application Data --> highlight EBS Instance datafiled line --> Synchronize --> Run Now --> Access -- Confirmation OK

Wait until the re-sync of ETL's from EBSO Data source is successful. (watch grc.log which will show you the status of the job).

  ##Check the GRC version, it should give 8.6.3.6012

  $ grep -i version /sid/ias/AACG863/tomcat/webapps/grc/WEB-INF/conf/grc.properties

                # GRC build version

                grc.version = GRC-all-8.6.3.6012

                grc.required.version = GRCC-8.6.0

16.upgrade from 8.6.3.6012 to 8.6.3.6025

  Shut down the Tomcat application server

    /<sid>/ias/AACG863/tomcat/bin/shutdown.sh

  unzip the patch

  Repeat the same steps from 5 to 15 again for 8.6.3.6025 , Patch: 14119308

17.upgrade from 8.6.3.6025 to 8.6.3.6031

   Shut down the Tomcat application server

    /<sid>/ias/AACG863/tomcat/bin/shutdown.sh

   unzip the patch

   Repeat the same steps from 5 to 15 again for 8.6.3.6031 , Patch: 14238616 

18.upgrade from 8.6.3.6031 to 8.6.3.6032

   Shut down the Tomcat application server

    /<sid>/ias/AACG863/tomcat/bin/shutdown.sh

   unzip the patch

   Repeat the same steps from 5 to 15 again for 8.6.3.6032 , Patch: 14258741

19.upgrade from 8.6.3.6032 to 8.6.3.6036

   Shut down the Tomcat application server

    /<sid>/ias/AACG863/tomcat/bin/shutdown.sh

   unzip the patch

   Repeat the same steps from 5 to 15 again for 8.6.3.6036 , Patch: 14572366

Reference Document IDs:

Upgrade Paths to Governance and Risk Compliance Controls (EGRCC) 8.6.4 (8.6.4.5259) (Doc ID 1225726.1): 

Critical Patch Information for Oracle AACG/TCG (Upto Version 8.6.3) (Doc ID 978690.1):

GRC Suite Certification Matrix (Doc ID 741001.1)