CA RiskMinder UNIX Installation Guide › Upgrading RiskMinder › Upgrading to Release 3.1 › Migrating the Database to RiskMinder Release 2.2.7 for Arcot Common Components

Migrating the Database to RiskMinder Release 2.2.7 for Arcot Common Components

Note: Perform this procedure only if you are upgrading from release 1.x. If you are upgrading from release 2.x or 3.0.x, you can ignore this procedure.

Important! If you installed AuthMinder with RiskMinder and completed the AuthMinder upgrade, then do not migrate the database for Arcot common components. This is because the database migration has already been performed during the AuthMinder upgrade.

Migrate the database to the release 2.2.7 state for Arcot common components.

Follow these steps:

1. Copy the Upgrade directory to a temporary location on the system where you plan to upgrade.

   This directory contains the following zip files that are applicable for this migration path:

   • arcot-common-upgrade-0.x-1.0.zip
   • arcot-riskfort-upgrade-1.x-2.2.7.zip
2. Copy the arcot-common-upgrade-0.x-1.0.zip file to the ARCOT_HOME directory.
3. Extract the contents of the arcot-common-upgrade-0.x-1.0.zip file in this directory.
4. Navigate to the following directory:

   $ARCOT_HOME/dbscripts/<db_type>
   

   Here, db_type can be mssql or oracle.

5. Run the arcot-db-config-for-common-1.0.sql script.

   Note: In SQL Server, if you run the database script from the command line using SQLCMD, then you must specify the –I option to set the QUOTED_IDENTIFIER connection option to ON and the -x option to disable variable substitution.

6. Navigate to the following directory:

   $ARCOT_HOME/dbscripts/<db_type>/upgrade-scripts/
   

   Here, db_type can be mssql or oracle.

7. Run the arcot-upgrade-for-common-1.0.sql script.

   Note: In SQL Server, if you run the database script from the command line using SQLCMD, then you must specify the –I option to set the QUOTED_IDENTIFIER connection option to ON and the -x option to disable variable substitution.

8. Download the JDBC JAR that is compatible with your database:
   • Oracle: ojdbc.jar
   • SQL Server: sqljdbc.jar

   Copy it to the following directory:

   $ARCOT_HOME/java/lib
   

9. Back up the existing libArcotAccessKeyProvider.so file if it is in the following directory. Then, copy the $ARCOT_HOME/native/<platform>/<32bit-or-64bit>/libArcotAccessKeyProvider.so file to <JAVA_HOME used by Application Server>/jre/bin.
10. Set and export the LD_LIBRARY_PATH variable to the directory where libArcotAccessKeyProvider.so is copied.
11. Copy the file $ARCOT_HOME/java/lib/arcot-crypto-util.jar

    to

    <JAVA_HOME used by Application Server>/jre/lib/ext/
    

12. Navigate to the $ARCOT_HOME/tools/upgrade directory.

    Note: Ensure that you have the privileges that are required to run the upgrade-common.sh tool.

13. Run the upgrade-common.sh tool.
14. To ensure that the common database upgrade operation was run successfully, examine the $ARCOT_HOME/logs/upgrade-common.log file.