Update external service (database clusters)

If you have performed an installation using an Oracle or Microsoft SQL database cluster you need to reconfigure the external service after the installation process.

This procedure shows an example for an Oracle database.

Procedure

  1. Start ARIS Cloud Controller (ACC).

  2. To connect to an Oracle cluster using a JDBC URL you may use this example:

    update external service <dbserviceID> url="jdbc:oracle:thin:@(DESCRIPTION=ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=<virtual-ip-oracle-cluster>)(PORT = <target port>)))(CONNECT_DATA=(SERVICE_NAME=cluster-database-name)))" driverClassName="oracle.jdbc.OracleDriver" username="<cip_app_user>" password="<new_cip_app_pwd>" maxIdle=15 maxActive=100 maxWait=10000 removeAbandoned=false removeAbandonedTimeout=600 logAbandoned=true defaultAutoCommit=false rollbackOnReturn=true host=<target_host> jmxEnabled=true validationQuery="select 1 from dual" testOnBorrow=true

ARIS server can be started using the Oracle cluster.