Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

Creating default alarms when upgrading to vCenter Server 4.0 (1010399)

Details

This article describes how to create default database alarms for vCenter Server 4.0, following an upgrade.

Note: This is an issue with upgrading to vCenter Server 4.0 only. Fresh installations of vCenter Server 4.0 are not affected.

Warning: Running the scripts attached to this article on a fresh vCenter Server 4.0 installation can cause vCenter Server to fail.

Solution

This issue is resolved in vCenter 4.0 Server Update 1. For more information, see VMware vCenter Server 4.0 Update 1 Release Notes .

Note: Before performing any of the troubleshooting steps below, create backups of the vCenter Server database.

To create missing default alarms:

  1. Download the files 1010399_create_alarms_mssql.txt and 1010399_create_alarms_oracle.txt attached to this article.
  2. Save 1010399_create_alarms_mssql.txt as create_alarms_mssql.sql.
  3. Save 1010399_create_alarms_oracle.txt as create_alarms_oracle.sql.
  4. Copy the appropriate SQL query file to the C:\Program Files\VMware\Infrastructure\VirtualCenter Server directory on your vCenter server:

    Note: The vCenter Server 4.0 installation directory may have been relocated to another drive.

    • For Microsoft SQL Server, copy create_alarms_mssql.sql.
    • For Oracle Database, copy create_alarms_oracle.sql.

  5. Create backups of the vCenter Server database.
  6. Stop the VMware VirtualCenter Server service. For more information, see Stopping, starting, or restarting vCenter services (1003895).
  7. Execute the downloaded SQL queries:

    • For Microsoft SQL Server:

      1. Log in to the vCenter database using the same user credentials that 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.
      6. Start the VMware VirtualCenter Server service. For more information, see Stopping, starting, or restarting vCenter services (1003895).

    • For 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. Enter this command to run the script:

        @<path to create_alarms_oracle.sql>\create_alarms_oracle.sql

      3. Start the VMware VirtualCenter Server service. For more information, see Stopping, starting, or restarting vCenter services (1003895).

Tags

create-vcenter-database-alarm

Attachments

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 11 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? (4000 or fewer characters)
  • 11 Ratings
Actions
KB: