UpdateReportEngineDBPassword
If the database password is changed, this command is used to reset the password on the Report Engine to connect to the database. You must run this command to enable the data collection from TrueSight Infrastructure Management to the Report Engine.
To change the BMC TrueSight Operations Management Report Engine database schema password
- Stop the BMC TrueSight Operations Management Report Engine service.
- Access the Report Engine database host and connect to the database.
Run the following commands:
Set ORACLE_SID=bppmre
sqlplus / as sysdba
alter user re identified by re1;
Where,
re
is the current user andre1
is the new password.Navigate to the <ReportEngineInstallDir>\ReportEngine\bin\reportsCLI.
(Linux) Run the following commands to provide execute permissions:
chmod 755 UpdateReportEngineDBPassword.sh <Report Engine database user name>
chmod 755 Installer.jar
Run the following command to change the password:
(Windows)
UpdateReportEngineDBPassword.cmd <Report Engine database user name>
(Linux)UpdateReportEngineDBPassword.sh <Report Engine database user name>
Note
When you do not provide any argument for the UpdateReportEngineDBPassword command, the system displays the help message by default.
- Start the BMC TrueSight Operations Management Report Engine service.
Comments
"alter user re identified by re1; Where, re is current password and re1 is new password. "
The above statement is incorrect. 're' is the user NOT the current password
Thank you for the observation, John. We have corrected the document.
Regards,
Mukta
Log in or register to comment.