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 get to list the jdbc parameters.

   $ mzsh topo get -s --format data-only topo://container:<mz.container>/pico:platform/obj:config.properties.mz.jdbc

   Example - List of jdbc parameters

   mzsh topo get -s --format data-only topo://container:platform1/pico:platform/obj:config.properties.mz.jdbc
   
   {
     "password": "DR-4-48851644227183C2041D838568E117EC",
     "oracle": {
       "ons": ""
     },
     "type": "oracle",
     "user": "mzadmin",
     "url": "jdbc:oracle:thin:@//<install.ora.host>:1521/MZ"
   }    

4. Use the mzsh topo set command to update the password for mzadmin in the STR:

   $ mzsh topo set topo://container:<mz.container>/pico:platform/val:config.properties.mz.jdbc.password `mzsh encryptpassword <new password>` 

   Example - Updating mzadmin password

   $ mzsh topo set topo://container:platform1/pico:platform/val:config.properties.mz.jdbc.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 your new mzadmin password.
   
   
7. Startup the Platform.
   
   
8. Enable all workflow groups and start all workflows again.