Changing the DBO password

This procedure describe how to change the Oracle, MSSQL, or PostgreSQL DBO password on UNIX and Windows. You must perform this procedure on all Control-M/EM installations (primary, secondary, and Control-M/EM Distributed) because they use the same database.

NOTE: If you are working in a High Availability environment, you must perform this procedure on the active Control-M/EM first and then on all other Control-M/EM servers. The first time you perform this procedure on the primary, you need the database administrator username and password.

To change the DBO password:

1. Shut down all Control-M/EM components on all Control-M/EM installations including the Control-M/EM Configuration Agent (primary, secondary, and Control-M/EM Distributed).
2. Run one of the following on the primary host and then on all the other host:
   • UNIX: {BMC_Install_folder}/ctm_em/bin/change_em_database_owner_password.sh
   • Windows: {BMC_Install_folder}\Control-M EM\Default\bin\change_em_database_owner_password.bat