Procedure
1
Run the database password change utility from the command prompt.
cd
Installation_Directory\vCenter-CB-Tools\database-update\bin
UpdateChargebackDatabaseCredentials.bat
You can also run this utility by selecting Update Chargeback Database Credentials from the Start >
Programs > VMware > VMware vCenter Chargeback > vCenter Chargeback Tools menu.
2
Enter the existing and new passwords.
n
Existing password
n
New password
n
Confirmation of the new password
3
Restart the vCenter Chargeback service and the data collector services.
What to do next
If you have installed the VMware Cloud Director Data Collector and vShield Manager Data Collector with
vCenter Chargeback or individually installed any of the data collectors, then you must copy the
hibernate.cfg.xml
file from the
Installation_Directory/apache-tomcat-6.0.18/webapps/vCenter-CB/WEB-
INF/classes
folder to the
Installation_Directory/Data_Collector_Name/classes
folder for each data
collector. You must restart the data collectors after copying the
hibernate.cfg.xml
file.
vCenter Chargeback Database Management Scripts
vCenter Chargeback provides SQL scripts that can help database administrators to manage the vCenter
Chargeback database.
These SQL scripts can be run from the SQL prompt by any database user having the required permissions.
These scripts are packaged with the application and are located in the following folders:
n
For SQL Server
Installation_Directory\Database Scripts\main\v1.5.0\mssql\db-management
The script names are of the form
script_name_mssql.sql
.
n
For Oracle
Installation_Directory\Database Scripts\main\v1.5.0\oracle\db-management
The script names are of the form
script_name_oracle.sql
.
Generic Scripts
vCenter Chargeback provides few generic SQL scripts that let you fetch certain statistical data about the
vCenter Chargeback database.
Prerequisites for Running the Generic SQL Scripts
You must have the SELECT permission on the tables in the vCenter Chargeback database to run these scripts.
Before running the generic scripts on an SQL Server database, you must replace
$dbName
with the name of the
vCenter Chargeback database in the SQL scripts.
About the Generic SQL Scripts
Table 9-1
lists the generic SQL scripts provided with vCenter Chargeback.
vCenter Chargeback User’s Guide
130
VMware, Inc.