HP Storage Essentials SRM 6.0 User Guide for Enterprise Edition and Standard Edition SRM Software (July 2008)

Database Maintenance and Management238
Re-initializing the Database
CAUTION: Do not use the Database Admin Utility to re-initialize the HP SIM database. Follow the
steps in this section to re-initialize the HP SIM database and then the HP Storage Essentials
database.
Keep in mind the following:
• Re-initializing the database removes everything from the database. This is not recommended
unless you are sure about what you are doing. It is strongly suggested you export the database
before you re-initialize it. See ”Exporting the Database” on page 236 for more information on
how to save the database.
• When you re-initialize the database, all users are logged out of the management server.
To clear the database:
1. Login to the system as follows:
• Microsoft Windows - Administrator
• Linux - root
2. Stop AppStorManager, which is the service for HP Storage Essentials.
3. Remove the HP SIM connector as described in the Installation Guide.
4. Stop the service for HP SIM.
5. Drop the SEConnectorData table from HP-SIM schema by doing the following:
a. (Linux management servers only) Run the setvars.sh script by entering the following:
./[SE-installDir]/install/setvars.sh"
b. Enter the following:
sqlplus SIM_Manager/quake@appiq
NOTE: The word 'quake' is the default password for SIM_Manager user. Please use the
appropriate password if you have changed the password for SIM_Manager user.
c. Enter the following:
Drop table SEConnectorData;
6. Run the HP SIM CLI command 'mxinitconfig -r' to remove the HP-SIM schema.
7. Run the HP SIM CLI command 'mxinitconfig -a' to re-initialize HP-SIM schema.
HP SIM restarts automatically after running this command.
8. Ensure that the service for HP SIM has restarted successfully.
9. Re-initialize the HP Storage Essentials database:
a. Access the Database Admin Utility as described in ”Accessing the Database Admin Utility”
on page 233.
b. Click Re-initialize Database in the left pane.