Update the Database Schema

If the ActivID AS database schema needs to be updated (only relevant in context of a service pack), the ActivID AS Companion delivery disk includes the Installation/Database folder containing the required SQL/shell scripts.

After you have stopped the ActivID AS applications, run the scripts on the database host as described below.

Further details are provided in the release notes provided with each service pack.

Update the Schema for an Oracle Database

For each existing security domain, update the schema using the oracle-update-4tress.sql script in the /Installation/Database/oracle/scripts folder on the ActivID AS Companion delivery disk as follows:

Copy 
@./oracle-update-4tress.sql <CONNECTION_STRING> <ADMIN_USER> <ADMIN_PASSWORD> <Security Domain> <Security Domain Password>

Where:

  • <CONNECTION_STRING> is the connection string to connect to the ActivID AS database.

  • <ADMIN_USER> is the dedicated installation user.

  • <ADMIN_PASSWORD> is the password of the dedicated installation user.

  • <Security Domain> is the name of security domain.

  • <Security Domain Password> is the password for security domain.

Note: The script is executed without logging and it uses the ADMIN_USER account and its password to connect to the database.

When the schema updates are complete, continue with the ActivID AS service pack update.