SCOM 2012 R2 UR9 Upgrade Step by Step

SCOM 2012 R2 UR9 Upgrade Step by Step

• Microsoft released UP(update Roleup) every now and then. They generally do lot of bug fixes in these update.Today Microsoft has released SCOM UR9 Upgrade. Lets go Step by Step in this upgrade.

• First Download the UR9 from below Site.
• http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3129774 

Upgrading the Management Server:

• Extract the Files that you downloaded to C:\Bin\UR9 folder

• Login using the SCOM service account or account which has local admin,SCOM admin and SA Admin on SCOM database.Usually your SCOM service account will have these acc. So i suggest to use it.
• Now Open Command Prompt in elevated mode and Go to "C:\Bin\UR9" folder
• Type "KB3129774-AMD64-Server.msp"

•  This will lauch Update.You will be prompted to restart your system after the update.Click yes and system will restart
• Once its up check the Application log for Event ID 1036. Make sure it successful.

•  Also check the DLL Versions in the Operations Manager\Server folder and make sure its showing 7.1.10226.1177

•  You Should upgrade your additional management server in same way.

Upgrade SCOM Webconsole and SCOM Console:

• Now Open Command Prompt in elevated mode and Go to "C:\Bin\UR9" folder
• Type "KB3129774-AMD64-ENU-WebConsole.msp"

•  This will update the Web console.
• Next Type "KB3129774-AMD64-ENU-Console.msp"

•  This will update the Console.

Updating the Gateway Servers:

• Login to your Gateway server. Copy the Downloaded file  TO "C:\Bin\UR9" Folder
• Now Open Command Prompt in elevated mode and Go to "C:\Bin\UR9" folder
• Type "KB3129774-AMD64-Gateway.msp"

• This will update the Gateway Server

 Update the SCOM Databases:

• First Make sure you have stopped all SCOM services on your Management server and restart the SQL Server service once
• Login to the SCOM Database Server
• Open a SQL management studio query window, connect it to your Operations Manager database.
• Now go to the upgrade Management server at below location %SystemDrive%\Program Files\Microsoft System Center 2012 R2\Operations Manager\Server\SQL Script for Update Rollups
• Copy the SQL Scripts "update_rollup_mom_db.sql" and execute in the Query windows. This script could faill but continue trying till it succeeds

• Try re-running the script several times until it completes without errors.  In a production environment, you have to shut down the services (sdk, config, and healthservice) on your management servers, to break their connection to the databases, to get a successful run. 
• Once OperationsManager DB is update close the Query window.
• Now open a SQL management studio query window, connect it to your OperationsManagerDW database.
• Copy the SQL Scripts "UR_Datawarehouse.sql" and execute in the Query windows. This script could faill but continue trying till it succeeds.

Import the management packs:

• There are 55 management packs in this update!.Most of these we don’t need 
• The path for these is on your management server, after you have installed the “Server” update: \Program Files\Microsoft System Center 2012 R2\Operations Manager\Server\Management Packs for Update Rollups
• You can install the MP Shown below and ignore the rest.Total 19 MP's will come.

Updating the Agents:

• Login to SCOM Management server
• Open SCOM Console==>Administration Tab
• Click on "Pending Management".Select all the agent you see and Click "Approve".