PE

Hi there

We have ARIS Design and Publisher 9.8 servers running on Red Hat Enterprise Linux. Our database connection details have changed due to a DB upgrade and we need to point the Design Server and Publisher Server to these new DB's (hostnames have changed).

What is the easiest way to change existing DB connectivity details on ARIS? ACC is problematic because it requires zookeeper instances, which also require repositories which are not available remotely anymore.

Is there a way to edit config files directly on the servers to reflect these new DB connectivity details?

Thanks!

by Didier Nowak
Posted on Thu, 09/01/2016 - 13:47

Hi Pieter,

You can only change it from the ACC.

To do so, you can start only the zookeeper runnable (start zoo.. ) then update the db service this way:

update external service db0000000000 url="jdbc:oracle:thin:@<server>:<port>:<sid>" driverClassName="oracle.jdbc.OracleDriver" username="<user>" password="<password>" maxIdle=15 maxActive=100 maxWait=10000 removeAbandoned=false removeAbandonedTimeout=600 logAbandoned=true defaultAutoCommit=false rollbackOnReturn=true host=<server> port=<port> jmxEnabled=true validationQuery="select 1 from dual" testOnBorrow=true

You can list the services to get the correct dbid: list external services

Hope this helps...

Cheers,

Didier

 

 

 

 

0
by Willem Engelbrecht
Posted on Fri, 09/02/2016 - 13:47

In reply to by dinow

Hi Didier,

The abovementioned refers.

Zookeeper is not a listed runnable in ARIS Publisher.

The command string given, is the same that we used to update a similar change, but, the string is not applicable to ARIS Publisher, could you please supply the command string used in ACC for Publisher.

Thanks,

Willem

0
by Didier Nowak
Posted on Thu, 09/08/2016 - 14:00

Dear Willem,

Then you can directly adapt and run the following command from acc:

reconfigure businesspublisher_l +bp.db.passwd="<password>" +bp.db.url="jdbc:oracle:thin:@<host>:<port>:<SID>" +bp.db.username="<userName>"

Didier

 

 

0
by Willem Engelbrecht
Posted on Fri, 09/09/2016 - 10:08

In reply to by dinow

Didier,

THANK YOU !!!

Willem

0
by Marcelo Sampaio
Posted on Tue, 03/28/2017 - 14:53

Hello ! I have the same problem.

The database host will be changed but I don't knwown how to change the Aris runnables "zoo_l, couchdb_l, cloudsearch_l, elastic_l, adsadmin_l, umcadmin_l, loadbalancer_l, abs_l, copernicus_l and octopus_l" to point to new database host.

Can You please help me with the ACC command lines to change runnables to new database host ?

Marcelo

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock