UpdateReportEngineReadOnlyUserDBPassword

After you run the create_TrueSightOperationsManagementReporting_tablespace.sql or create_sqlserver.bat command, the reuniv user and default password RE#Adm1n is created. If you want to change the RE#Adm1n password, perform the following steps depending on your Reporting database.

To change the password for Oracle database

1. Stop the BMC TrueSight Operations Management Report Engine service.
2. Access the BMC TrueSight Operations Management Report Engine database host and connect to the database.

3. Run the following commands:
   
   

   Set ORACLE_SID=bppmre
   sqlplus / as sysdba
   alter user reuniv identified by RE#Adm1n2;
   Where, RE#Adm1n is current  password and RE#Adm1n2 is new password
4. Go to the ReportEngineInstallDir\ReportEngine\bin\reportsCLI.
5. Run either of the following commands to change the password:
   • (UNIX) ./UpdateReportEngineReadOnlyUserDBPassword.sh REUNIV
   • (Windows) UpdateReportEngineReadOnlyUserDBPassword.cmd REUNIV

6. When prompted, specify the new password and confirm the password.
   If the connection is successful, the following messages are displayed:
   
   

   Enter the reuniv User Database password:
   Confirm reuniv User Database password:
   Database connection successful
   Successfully saved encrypted password in: /opt/BMCTrueSightOperationsManagementReportEngine/BMCProactiveNetInstalledConfiguration.xml
7. Start the BMC TrueSight Operations Management Report Engine service.

To change the password for Microsoft SQL Server

1. Stop the BMC TrueSight Operations Management Report Engine service.
2. Access the BMC TrueSight Operations Management Report Engine database host and connect to the Microsoft SQL Server Management Studio.
3. Expand Security > Logins > reuniv.
4. Double Click reuniv, update new password and click OK.
5. Navigate to the ReportEngineInstallDir\ReportEngine\bin\reportsCLI.
6. Run either of the following commands to change the password:
   
   • (UNIX) ./UpdateReportEngineReadOnlyUserDBPassword.sh REUNIV
     
   • (Windows) UpdateReportEngineReadOnlyUserDBPassword.cmd REUNIV

7. When prompted, specify the new password and confirm the password.
   If the connection is successful, the following messages are displayed:
   
   

   Enter the reuniv User Database password:
   Confirm reuniv User Database password:
   Database connection successful
   Successfully saved encrypted password in: /opt/BMCTrueSightOperationsManagementReportEngine/BMCProactiveNetInstalledConfiguration.xml
8. Start the BMC TrueSight Operations Management Report Engine service.