Question for migration of PAM database

Products

• CA Process Automation Base

Issue/Introduction

I have a question for migration of PAM database. It was recommended to reconfigure PAM using installer. I am afraid that something will go wrong using the "reconfiguration/reinstallation" using installer and that some values will not be remembered.

Can I just modify the OasisConfig.properties file and set the location of new database?

Environment

Release : 4.3

Component : Process Automation

Resolution

While the preferred method of making this kind of change is going back through the installer and selecting the "reconfigure" option, it is possible to backup and then update the following options in the OasisConfig.properties file with the new hostname for the ITPAM database:

oasis.database.dbhostname=
oasis.database.connectionurl=
oasis.reporting.database.dbhostname=
oasis.reporting.database.connectionurl=
oasis.runtime.database.dbhostname=
oasis.runtime.database.connectionurl=

You will need to ensure that the login credentials for the database are the same on the new server as on the old.

Please restart ITPAM after making this change.  If you have a cluster configuration this change must be made on all orchestrator machines.