5.5

VMware vCenter Server 5.5 Database is Full

Posted by robd on May 27, 2015
SQL, vmware, vSphere / 9 Comments

So today a vCenter Server Service wouldnt start Java was going mental and we kept seeing event IDs 1105 and 1827.  So what this means is our SQL Express instance reached the limits the size of databases i.e. 10GB on SQL Express 2008 R2.

Error_event1

Error_event

You can confirm this by looking at the size of the VIM_VCDB.MDF file in c:\program files\Microsoft SQL Server\MSSQL10_50.VIM_SQLEXP\MSSQL\Data, if its 10GB then your in trouble.

So the first thing to do is fire up Microsoft SQL Server Management studio and run a standard report against the VIM_VCDB by right clicking the DB > Reports > Standard Reports > Disk Usage by Top Tables:

Error1

From here you can see which tables are causing the problems, in my case its dbo.VPX_EVENT_ARG which is massive.

So from here you need to purge the above table:

  1. From Microsoft SQL Server Management studio
  2. Click databases to expand and select VIM_VCDB > Tables.
  3. Right-click the dbo.VPX_PARAMETER table and select Open.Note

    : If you are using SQL Server 2008, right-click the dbo.VPX_PARAMETER table and click Edit Top 200 Rows.
    Error3

  4. Modify event.maxAge to 30, and modify the event.maxAgeEnabled value to true.
  5. Modify task.maxAge to 30, and modify the task.maxAgeEnabled value to true.

Error5.5

Error5

  1. Next run a built-in stored procedure to shink the logs:
  2. Go to VIM_VCDB > Programmability > Stored Procedures.

Error6

3. Right-click dbo.cleanup_events_tasks_proc and select Execute Stored Procedure. This purges the data from the vpx_event, vpx_event_arg, and vpx_task tables based on the date specified for maxAge.

Now the records have been purged you need to shrink the DB:

  1. As before connect using SQL Server Management Studio.

ExecuteScript

2. Right click on the VIM_VCDB database and New Query, when the white SQLQuery box opens type the below and click ! Execute

3. It’ll start running and when its finished you should see:

ExecuteScript2

Check the size of the file again and you should be able to start the services.

 

Tags: , , , ,

ESXi 5.1 to 5.5 Upgrade with Update Manager

Posted by robd on December 08, 2014
ESXi 5.5, vSphere / No Comments

So a client asked me to upgrade their ESXi server from 5.1 to 5.5.  Fairly straight forward if you rememeber this:

  1. Update vCenter to 5.5,
  2. Update vSphere Update Manager to 5.5,
  3. Lastly update ESXi to 5.5.

So lets get going:

Update vCentre:

Firstly download the vCentre ISO: VMware-VIMSetup-all-5.5.0-2183112-20140901-update02.iso (or what ever is the latest version).

Logon to your vCentre server and run the ISO.

If all the components of the existing vCenter Server infrastructure are installed on the same machine, the easiest and fastest upgrade way it to select Simple Install on VMware vCenter 5.5 Installer screen. Remember that upgrading from 5.0 or 5.1 is much easier as SSO will be already installed and the upgrade of SSO will be almost seamless.
01
It will upgrade all necessary components of vCenter Server, starting with SSO. As you can see, I am upgrading from a version with SSO already installed (i.e. 5.1) so it says it will upgrade it.
02

After a few checks the upgrade process for SSO will start making sure that SSO users, groups and Lookup Services are migrated. The previous version will be uninstalled and the new one configured:
03
04
After Web Client, the next element is Inventory Service. You’ll be asked if you want to keep or overwrite your database:
05

And now vCenter Server itself will be upgraded:
06
After asking if the vCenter Server database should be upgraded
08
the installer will ask you a few other questions like if host agents should be updated automatically once vCenter Server upgrade is done or which account vCenter Server service should run on as well as you will be able to customized port used by vCenter Server. Finally the upgrade starts:
09
and the whole process completes successfully:
10
Once the vSphere Client is upgraded, you can check version of your vCenter Server:
11
Done. Almost everything has been done automatically and we were asked only for necessary information. If you want to have much more control over the upgrade process or if your vCenter Server components are installed on different machines, check the next post in the series when I show how to upgrade them.

Udate vSphere Update Manager:

Run the ISO again and choose Vsphere Update manager:

01

Tick the download if you have a internet connection:

Update01

Type your password for your installation:

Update02

Update:

Update03

Next through:

Update05

Update06

The installation will take the service off line so make sure no other Admins are working. Once finished you need to update your client.

vSphere Update Manager client update:

Open the vSphere Client, and log into the vCenter

From Plug-ins menu, select Manage Plug-ins

This should show the plug-in manager, that will show the VMware vSphere Update Manager, and blue link to download and install the plug-in.
client01
At the end of the install, the plug-in will attempt to connect to the VUM server, accept the default certificate that is presented.

client02

Note: This should add an Update Manager icon to the “Solutions and Application” portion of the vSphere Client:

client03

Finally update the host!!

Update the host:

Download a ESXi image from VMware or if you have a HP as I do (HP ProLiant DL385 G7), then you can use the below which has all the HP drivers etc:
http://www8.hp.com/us/en/products/servers/solutions.html?compURI=1499005#tab=TAB4

First put your chosen host into Maintenance mode.

upgrade0

Connect to your vCenter server using vSphere client. Click on Solutions and Applications -> Update Manager. Click on ESXi Images Tab and Select “Import ESXi Image”

upgrade1

Click on Browse and browse towards the ESXi 5.5 ISO image from your system and click on Next

upgrade2

Import ESXi Image wizard will detect the ESXi 5.5 information and click on Next to complete the Import.

upgrade3

Create a New Baseline for ESXi host upgrade.Enter the name ,description and Select Host Upgrade under Host baselines and click on Next

upgrade4

Select the ESXi Image to be included as part of this Upgrade baseline and click on Next.

upgrade5

Review the information for this baseline and click on Finish.

upgrade6

Select the cluster or Host to attach the newly created Host upgrade Baseline. Select the Update Manager tab and click on Attach. Select the checkbox for the baseline to attach to the Host. I am attaching this host upgrade baseline to my ESXi 5.5 host 192.168.1.1. Click on Attach

upgrade7

Click on Scan to check the compliance for the Host against the attached baseline.

upgrade8

If the attached baseline is applicable to the selected Host, Click on Remediate and click on Next.

upgrade9

Accept the End user License Agreement for this ESXi 5.5 upgrade and click on Next.

upgrade10

Verify the Upgrade settings.Select the checkbox if you want to remove the installed third-party software that is incompatible with the upgrade, and continue with the remediation and click on Next.

upgrade11

Enter the Task name and description. If you want to perform this upgrade in later time,Select the checkbox At time and define the time. I am doing it with immediately option. Click on Next.

upgrade13

Specify the Host Remediation option as per your requirement and click on Next.

upgrade14

Specify the cluster Remediation options as per your requirement and click on Next.

upgrade15

Review the selected remediation settings and click on Finish to start the Upgrade process.

upgrade16
Once Upgrade Baseline Remediation is completed, your done!!

upgrade17 upgrade18

Tags: , , , , ,

Copy Protected by Chetan's WP-Copyprotect.