GRC (AACG) Transaction Synchronization/Access Synchronization Failing

Issue : Data Source validation is fine. But Access Synchronization/Transaction Synchronization is failing.

Cause : Caching 

Fix:

• Shutdown GRC Application.
• Shutdown GRC database.
• Take backup of GRC database and application.
• Startup GRC database.

• Run the below query to see if there are any tables in GRC schema with name SNP_
• select owner,table_name from dba_tables where table_name like 'SNP_%' and owner='GRC';
• If the above query returns any rows, drop those tables under GRC schema.
• Make sure there are no tables with SNP_% under GRC schema by running above select query again.
  
• Go to Application Tier and Clear Cache 
• In case of Weblogic based, take backup and delete the contents of tmp and cache folders.
• Take backup of ETL directory and remove the "temp.repository" folder alone under ETL directory.

• Startup the GRC application.
• Validate the Data source.
• Run the Access Synchronization first followed by Transaction Synchronization.

Install/configure GRC 8.6.6.15000 using Tomcat

 

GRC (AACG) 8.6.6.15000 is NOT a straight forward installation. We have to first install the base version 8.6.6.1000. Upgrade it to 8.6.6.2000 And then to 8.6.6.3000 So on till 8.6.6.15000   In this document, we will see the steps followed for installing/configuring GRC instance.   DB Servers : testdb01/testdb02 Application server : testmt01 DB Name : GRCTEST DB port : 1521   GRC 8.6.6.1000   8.6.6.1000 is compatible with 12c version of database and needs JDK1.7 and Tomcat 7.0.47.   Database Steps:   create tablespace GRCDATA datafile '+DATA01' size 1G autoextend on maxsize 10G; create temporary tablespace GRCTEMP tempfile '+DATA01' size 1G autoextend on maxsize 10G;   create user GRCUSER identified by XXXXXXXXXXXXXXXXXX default tablespace GRCDATA temporary tablespace GRCTEMP quota unlimited on GRCDATA ;   grant alter any table to GRCUSER; grant create any table to GRCUSER; grant drop any table to GRCUSER; grant connect, resource to GRCUSER; grant create view to GRCUSER; grant create synonym to GRCUSER; grant create session to GRCUSER; GRANT EXP_FULL_DATABASE, IMP_FULL_DATABASE TO GRCUSER; GRANT CREATE SESSION TO GRCUSER; GRANT CREATE TABLE TO GRCUSER; GRANT UNLIMITED TABLESPACE TO GRCUSER; GRANT EXECUTE ON UTL_FILE TO GRCUSER;     Application Configuration:   1)     Install InstantClient   mkdir -p /u01/web cd /u01/web unzip /mnt/grc/instantclient-basic-linux.x64-11.2.0.4.0.zip mv instantclient_11_2 instantclient   2)     Install Apache Tomcat   mkdir -p /u01/web/tomcat cd /u01/web/tomcat unzip /mnt/patches_grc/apache-tomcat-7.0.47.zip ln -s apache-tomcat-7.0.47 current     3)     Install JDK 1.7   mkdir -p /u01/web/java cd /u01/web/java tar xzf /mnt/java/jdk-7u251-linux-x64.tar.gz ln -s jdk1.7.0_251 current   4)     Configure env file   cd /home/applacgt vi acgt.env export TOMCAT_HOME=/u01/web/tomcat/current export JAVA_HOME=/u01/web/java/current export LD_LIBRARY_PATH=/u01/web/instanctclient:$LD_LIBRARY_PATH export PATH=$JAVA_HOME/bin:$PATH export PATH=$TOMCAT_HOME/bin:$PATH   5)     Configure Tomcat startup parameters   cd /u01/web/tomcat/current/bin vi setenv.sh CATALINA_OPTS="-Xss512k -XX:MaxPermSize=256m -XX:+UseParallelGC -Djava.awt.headless=true -XX:-UseGCOverheadLimit -XX:ReservedCodeCacheSize=128M -Doracle.mds.cache=simple -Dfile.encoding=UTF-8" export CATALINA_OPTS export CATALINA_OPTS="$CATALINA_OPTS -Xms1G" export CATALINA_OPTS="$CATALINA_OPTS -Xmx12G" export JAVA_HOME=/u01/web/java/current export PATH=$JAVA_HOME/bin:$PATH   6)     Install GRC 8.6.6.1000   cd /mnt/patches_grc/grc866_1305/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_1305/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_1305/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib   cd $TOMCAT_HOME/bin sh ./startup.sh   7)     Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services   cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   8)     Validate the Application :   Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.1305

 

Upgrade to 8.6.6.2000     cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-1000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_2056/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_2056/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_2056/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.2056

 

Upgrade to 8.6.6.3000     cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-2000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_3050/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_3050/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_3050/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.3050

 

 

 

 

Upgrade to 8.6.6.4000     cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-3000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_4037/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_4037/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_4037/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.4037

 

 

 

Upgrade to 8.6.6.5000     cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-4000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_5020/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_5020/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_5020/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.5020

 

Upgrade to 8.6.6.6000     cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-5000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_6063/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_6063/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_6063/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.6063

 

 

Upgrade to 8.6.6.7000     cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-6000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_7017/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_7017/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_7017/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.7017

 

 

Upgrade to 8.6.6.8000     cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-7000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_8040/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_8040/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_8040/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.8040

 

Upgrade to 8.6.6.8000     From GRC 8.6.6.8000 onwards, it needs Tomcat to be upgraded to 7.0.82.   cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-7000.tar.gz grc rm -rf grc   cd /u01/web/tomcat unlink current ln -s apache-tomcat-7.0.82 current cd /u01/web/tomcat/current/conf vi catalina.properties org.apache.catalina.startup.ContextConfig.jarsToSkip=*.jar cd /u01/web/tomcat/current/bin vi setenv.sh CATALINA_OPTS="-Xss4m -XX:MaxPermSize=256m -XX:+UseParallelGC -Djava.awt.headless=true -XX:-UseGCOverheadLimit -XX:ReservedCodeCacheSize=128M -Doracle.mds.cache=simple -Dfile.encoding=UTF-8" export CATALINA_OPTS   export CATALINA_OPTS="$CATALINA_OPTS -Xms1G" export CATALINA_OPTS="$CATALINA_OPTS -Xmx12G"   export JAVA_HOME=/u01/web/java/current export PATH=$JAVA_HOME/bin:$PATH   cd /mnt/patches_grc/grc866_8040/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_8040/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_8040/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.8040

 

 

Upgrade to 8.6.6.9000       cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-8000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_9006/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_9006/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_9006/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/conf perl -pi -e 's?org.apache.catalina.startup.ContextConfig.jarsToSkip=?org.apache.catalina.startup.ContextConfig.jarsToSkip=*.jar?g' catalina.properties cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.9006

 

 

Upgrade to 8.6.6.10000       cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-9000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_10002/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_10002/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_10002/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/conf perl -pi -e 's?org.apache.catalina.startup.ContextConfig.jarsToSkip=?org.apache.catalina.startup.ContextConfig.jarsToSkip=*.jar?g' catalina.properties cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.10002

 

 

Upgrade to 8.6.6.11000       cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-10000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_11006/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_11006/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_11006/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/conf perl -pi -e 's?org.apache.catalina.startup.ContextConfig.jarsToSkip=?org.apache.catalina.startup.ContextConfig.jarsToSkip=*.jar?g' catalina.properties cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.11006

 

 

Upgrade to 8.6.6.12000       cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-11000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_12002/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_12002/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_12002/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/conf perl -pi -e 's?org.apache.catalina.startup.ContextConfig.jarsToSkip=?org.apache.catalina.startup.ContextConfig.jarsToSkip=*.jar?g' catalina.properties cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.12002

 

Upgrade to 8.6.6.13000       cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-12000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_13000/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_13000/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_13000/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cp /mnt/patches_grc/"Upgrade Patch"/lib/grc-dataservices-common-8.6.6.13-SNAPSHOT.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/conf perl -pi -e 's?org.apache.catalina.startup.ContextConfig.jarsToSkip=?org.apache.catalina.startup.ContextConfig.jarsToSkip=*.jar?g' catalina.properties cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.13000

 

Upgrade to 8.6.6.14000       cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf * cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-13000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_14030/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_14030/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_14030/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cp /mnt/patches_grc/"Upgrade Patch"/lib/grc-dataservices-common-8.6.6.13-SNAPSHOT.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/conf perl -pi -e 's?org.apache.catalina.startup.ContextConfig.jarsToSkip=?org.apache.catalina.startup.ContextConfig.jarsToSkip=*.jar?g' catalina.properties cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx     Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.14030

 

 

8.6.6.15000 Pre-Requisite Steps   To upgrade GRC to 8.6.6.15000, the pre-requisite is to upgrade the Database to 19c.   Before DB upgrade, we will shutdown the 8.6.6.14000 application   cd $TOMCAT_HOME/bin sh shutdown.sh cd $TOMCAT_HOME/work rm -rf Catalina cd $TOMCAT_HOME/temp rm -rf * cd $TOMCAT_HOME/logs rm -rf *   Attached below worknotes followed for upgrading the GRCTEST database to 19c:

 

Upgrade to 8.6.6.15000       cd $TOMCAT_HOME/webapps tar czf /mnt/grc/backup/grc866-14000.tar.gz grc rm -rf grc cd /mnt/patches_grc/grc866_15046/dist sh  grc_tomcat_setup.sh /mnt/patches_grc/grc866_15046/dist /u01/web/tomcat/current /u01/web/java/current cp /mnt/patches_grc/grc866_15046/lib/xdoparser-10.1.3.4.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cp /mnt/patches_grc/"Upgrade Patch"/lib/grc-dataservices-common-8.6.6.13-SNAPSHOT.jar $TOMCAT_HOME/webapps/grc/WEB-INF/lib cd $TOMCAT_HOME/conf perl -pi -e 's?org.apache.catalina.startup.ContextConfig.jarsToSkip=?org.apache.catalina.startup.ContextConfig.jarsToSkip=*.jar?g' catalina.properties cd $TOMCAT_HOME/bin sh ./startup.sh   Config Steps:   http://testmt01:8080/grc/faces/oracle/apps/grc/ui/setup/view/page/ConfigUIPG.jspx   Actions -> Save     Restart Services cd $TOMCAT_HOME/bin sh shutdown.sh sleep 30 sh ./startup.sh   Validate the Application : Access the URL  : http://testmt01:8080/grc   SQL> select CURRENT_BUILD_VERSION from GRCUSER.grc_sys_version;   CURRENT_BUILD_VERSION -------------------------------------------------- GRC-all-8.6.6.15046