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)
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)
Hello Mr.Adinarayana,
ReplyDeleteA quick query, I understand there is no direct upgrade path available from 8.1 to 8.6.3 or 8.6.4. In this case, which of the following approach would be advisable?
1) Step by Step upgrade approach from 8.1 to 8.6.3 then 8.6.4
2) Re-implmentation of AACG using the 8.6.4 latest release.
Can you please advice ?
Thanks
Viddyasagar CS
csviddyasagar@gmail.com