Resetting the vCenter Server embedded database repository for vCenter Server Appliance 5.x
search cancel

Resetting the vCenter Server embedded database repository for vCenter Server Appliance 5.x

book

Article ID: 342772

calendar_today

Updated On:

Products

VMware vCenter Server

Issue/Introduction

This article provides supported methods for resetting the vCenter Server Appliance embedded database. Licensing is a consideration in both methods.

Environment

VMware vCenter Server Appliance 5.1.x
VMware vCenter Server Appliance 5.5.x
VMware vCenter Server Appliance 5.0.x

Resolution

Caution: This procedure modifies the database. Ensure to take a backup of the database before proceeding.

Resetting from the vCenter Server Appliance 5.1/5.5 web console

Notes:
  • This method removes all information from the vCenter Server database, including license key information. You must add your license key(s) again when the steps are completed.
  • Stop vpxd before resetting the database.
To reset the embedded PostgreSQL database via the web console:
  1. Log in to the VMware vCenter Server Appliance Web console. For example, access a URL similar to:

    https://vCenter_Server_Appliance_IP_address:5480

  2. On the vCenter Server tab, click the Summary tab.
  3. Click Stop to stop the vCenter Services.
  4. On the vCenter Server tab, click Database.
  5. Click Reset DB contents under Actions.

    Note: This action generates the warning:

    WARNING: WILL DELETE ALL RECORDS

  6. Click Start to start the vCenter Server database.

Resetting from the vCenter Server Appliance 5.0 web console

Note: This method removes all information from the vCenter Server database, including license key information. You must add your license key(s) again when the steps are completed.

To reset the embedded DB2 database via the web console:
  1. Log in to the VMware vCenter Server Appliance Web console. For example, access a URL similar to:

    https://vCenter_Server_Appliance_IP_address:5480

  2. On the vCenter Server tab, click Status.
  3. Click Stop vCenter to stop the current instance of the vCenter Server database. You see the messages, Operation was successful and Service Status is Stopped.
  4. On the vCenter Server tab, click Database.
  5. Click Reset DB contents. You see the message, Operation was successful.
  6. On the vCenter Server tab, click Status.
  7. Click Start vCenter to start the current instance of the vCenter Server database.
  8. Connect to the vCenter Server with the vSphere Client.
  9. Check the vCenter Server Inventory objects.


Resetting from the command line

Note: This method does not remove license key information from the vCenter Server database.

To reset the embedded DB2 database via the command line:
  1. Use SSH or open a virtual machine console to the vCenter Server Appliance and log in as root.
  2. Run these commands:

    # service vmware-vpxd stop
    # /usr/sbin/vpxd -b

    You see output similar to:

    ------ In-memory logs start --------
    2012-02-01T15:13:50.019-07:00 [7FFFF3B09700 info 'Hooks'] Hooks Initialized

    ------ In-memory logs end --------
    2012-02-01T15:13:50.071-07:00 [7FFFF3B09700 info 'Default'] Initialized channel manager
    2012-02-01T15:13:50.176-07:00 [7FFFF3B09700 info 'Default'] Current working directory: /root
    2012-02-01T15:13:50.176-07:00 [7FFFF3B09700 info 'Default'] Log path: /var/log/vmware/vpx
    2012-02-01T15:13:50.176-07:00 [7FFFF3B09700 info 'Default'] Initializing SSL
    2012-02-01T15:13:50.472-07:00 [7FFFF3B09700 info 'Default'] Vmacore::InitSSL:doVersionCheck = true, handshakeTimeoutUs = 120000000
    2012-02-01T15:13:50.542-07:00 [7FFFF3B09700 info 'Default'] Registry Item DB 5 value is ''
    2012-02-01T15:16:04.665-07:00 [7FFFF3B09700 info 'Default'] [LdapBackup] Making sure LDAP instance VMwareVCMSDS is running
    2012-02-01T15:16:04.665-07:00 [7FFFF3B09700 info 'Default'] [LdapBackup] Checking service ldap for running
    2012-02-01T15:16:04.689-07:00 [7FFFF3B09700 info 'Default'] [LdapBackup] LDAP not started: 0x300
    2012-02-01T15:16:05.789-07:00 [7FFFF3B09700 info 'Default'] [LdapBackup] Started LDAP

    # service vmware-vpxd start
    # service vmware-vpxd status

    You see output similar to output:

    vmware-vpxd is running
    tomcat is running

  3. Connect to the vCenter Server with the vSphere Client and check the vCenter Server Inventory objects.


Additional Information

For translated versions of this article, see:

重置 vCenter Server Appliance 5.x 的 vCenter Server 嵌入式数据库存储库

Powered by Wolken Software