Move the database management system

If you run ARIS using an external database management system and the operational database server has moved, you must update the settings, for example, the IP address and the server name.

Procedure

  1. Start ARIS Cloud Controller (ACC).
  2. Stop all runnables, except the zoo runnable (service registry).
  3. Determine the service ID of the external database service to be changed. Enter: list external services
  4. Check the current settings of the external database settings. Enter: show external service <service ID>

    Example: show external service db0000000000

    Depending on the database system in use different settings are displayed.

    Output example (Oracle):

    Service db0000000000 (Type DB)

    Parameters:

    ...

    host sbrva100.com.ad.aaf

    ...

    url jdbc:oracle:thin:@//sbrva100.com.ad.aaf:1521/aris

    ...

    Output example (Microsoft SQL Server):

    Service db0000000000 (Type DB)

    Parameters:

    ...

    host sbrva100.com.ad.aaf

    ...

    url jdbc:sqlserver://sbrva100.com.ad.aaf;DatabaseName=aris10db;instanceName=aris

    ...

  5. Change the required settings using the update external service command.

    Example (Oracle):

    update external service <service ID> url="jdbc:oracle:thin:@//<Oracle server>:<listener port>/<instance name>" host=<Oracle server>

    Example (Microsoft SQL Server):

    update external service <service ID> url="jdbc:sqlserver://<Microsoft SQL Server>:<listener port>;DatabaseName=<database name>;instanceName=<instance name>" host=<Microsoft SQL Server>

  6. Check the applied database schema. Enter: list tenant <name> data for service db

    Output example (default tenant):

    Data of tenant default tenant for application db

    Key Value

    com.aris.cip.db.schema aris_default

    com.aris.ecp.db.schema aris_default

    name default

  7. Change the schema settings for all tenants, if required. Enter:

    set tenant <tenant name> data for service db com.aris.cip.db.schema=<new schema name>

    Example (master tenant):

    set tenant master data for service db com.aris.cip.db.schema=aris10_master

    (com.aris.ecp.db.schema not needed)

    Example (default tenant):

    set tenant default data for service db com.aris.cip.db.schema=aris10_default com.aris.ecp.db.schema=aris10_default

  8. Check the new settings using the commands:

    show external service <service ID>

    list tenant <tenant name> data for service db

  9. Start all runnables. Enter: startall