VMware
 

Knowledge Base

Search the Knowledge Base:
Products:
Search In:
 

How to create default alarms when upgrading to vSphere 4.0

Details

Some of the default alarms included with vSphere 4.0 are not created on your system when you upgrade from a previous version. SQL scripts that ensure that the default alarms are added to your system are attached to this KB article. Download the script appropriate for your system.

NOTE: This is an issue with upgrading to vSphere 4.0. Fresh installations of vSphere 4.0 are not affected. Running the scripts attached to this knowledge base article on a fresh vSphere 4.0 installation can cause vCenter Server to fail to start.

Solution

To create the missing default alarms:
  1. Download the following applicable SQL script:
    • For Microsoft SQL Server use create_alarms_mssql.sql.
    • For Oracle Database use create_alarms_oracle.sql.
  2. Back up your database and shut down the vCenter Server.
  3. Run the script.

To run the alarm creation script in Microsoft SQL Server:

  1. Log in to the database using the same user credentials that the vCenter Server uses to connect to the database.
  2. In Microsoft SQL Server Management Studio, navigate to the folder Databases > VC_database_DSN.
  3. Click New Query.
  4. In the query editor, copy and paste the contents of create_alarms_mssql.sql.
  5. Press F5 to run the script.

To run the alarm creation script in an Oracle database:
  1. Using sqlplus, log in to the database with the same user credentials that vCenter Server uses to connect to the database.
  2. Type @<path to create_alarms_oracle.sql>\create_alarms_oracle.sql
  3. Press enter to run the script.

Keywords

Alarms, vCenter Server, vSphere, ESX

Attachments

Feedback

Rating: 1 - Lowest 2 3 4 5 - Highest (1 Ratings)   

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (2000 or fewer characters)
Submit
Rating: 1 - Lowest 2 3 4 5 - Highest (1 Ratings)   
Actions
  • KB Article: 1010399
  • Updated: Aug 14, 2009
  • Products:
    VMware vCenter Server
  • Product Versions:
    VMware ESX 4.0.x
    VMware vCenter Server 4.0.x