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)
