Update the Oracle schema

This step is only needed if you are using the external DBMS Oracle in your installation.

Prerequisites

Procedure

  1. Start ARIS Cloud Controller (ACC) and enter the ARIS Agent's user credentials, if prompted.
  2. Enter stopall.
  3. Update the database schema for each tenant in your system. To do so prepare and execute the cip_update_schema_for_tenant.bat file for Microsoft® Windows® operating system or the cip_update_schema_for_tenant.sh file for Unix operating systems (ARIS DVD folder: Add-ons\DatabaseScripts\Design&ConnectServer\Oracle). Make sure to use the envset.bat file that had been adjusted when ARIS was installed the first time. This file contains all settings used by all configuration scripts.
  4. If this file is not available, edit the envset.bat file (ARIS DVD folder: Add-ons\DatabaseScripts\Oracle\Design&ConnectServer) to specify the connection data of the Oracle instance again.
  5. Identify the names of the schemas of all tenants that are used by the installation.

    If the schemas were originally created following the recommended naming convention, the schema names will look like:

    aris_<tenant_ID>, for example, aris_default and aris_master.

  6. If you do not know the schema name of a tenant, you can get it via the list tenant <tenant_ID> data for service db ACC command, for example, for default tenant schema:

    list tenant default data for service db

    The result of the command will show the default tenant's schema name aris_default:

    Key Value

    com.aris.cib.db.schema aris_default

  7. For each tenant’s schema run the cip_update_schema_for_tenant.bat script with the schema name as parameter. Call the file directly on a computer where an Oracle client is installed, for example, command for schema aris_default:

    cip_update_schema_for_tenant.bat aris_default

  8. Update all other tenant's schemas. It is important that the schemas of all existing tenants are updated this way, even if the tenants are currently not used. This includes both default and master tenants.

The tenant's oracle schemas are up to date.