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).

    ARIS Cloud Controller can be used in multiple modes.

    To start ACC under a Windows operating system click Start > All Programs > ARIS > Administration > Start ARIS Cloud Controller. If you have changed agent user credentials you must enter the user name and/or the password.

    To start ACC under a Linux operating system, execute the acc10.sh shell script instead.

  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.