Changing Database Password

Use the procedure below to change the password of the users mzadmin and mzowner in Oracle, PostgreSQL and SAP HANA databases.

1. Disable all workflow groups, either from the Execution Manager in Desktop, or by using the mzsh wfdisable command.
   
   

2. Let all batch workflows finish execution.

   Note!

   Batch workflows containing Inter Workflow agents that do not have the Deactivate on Idle check box selected will have to be shutdown manually.

3. Use the command mzsh topo to list the instances of the the service storage-dispatcher.

   $ mzsh topo get --format data-only topo://services:standard/obj:storage-dispatcher

   Example - List of sevice instances

   {
       "storage-dispatcher1" : {
           "config" : {
               "password" : "DR_DEFAULT_KEY-48851644227183C2041D838568E117EC",
               "type" : "oracle",
               "url" : "jdbc:oracle:thin:@myhost:1521:orcl"
               "user" : "mzadmin"
           },
           "start-after" : [],
           "template" : "1/standard/oracle"
       }
   }

4. Use the mzsh topo command to update the passwords in the STR:

   $ mzsh topo set topo://services:standard/val:storage-dispatcher.<service instance>.\
   config.password `mzsh encryptpassword <password>`

   Example - Updating the password(s)

   $ mzsh topo set topo://services:standard/val:storage-dispatcher.storage-dispatcher1.\
   config.password `mzsh encryptpassword mypassword`

   
   

5. Shut down the platform using the mzsh shutdown command.
   
   
6. Update the Oracle, PostgreSQL or SAP HANA passwords to correspond to the ones you set in the STR.
   
   
7. Startup the Platform.
   
   
8. Enable all workflow groups and start all workflows again.