Upgrade SCOM from 2012 r2 UR14 to 2016

Pre-Upgrade

  1. Review the Operations Manager event logs, save a copy.

  2. Cleanup the ETL table, use scripts below on OM db.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
-- (c) Copyright 2004-2006 Microsoft Corporation, All Rights Reserved         --
-- Proprietary and confidential to Microsoft Corporation --
-- File: CatchupETLGrooming.sql --
-- Contents: A bug in the ETL grooming code could have left the customer --
-- Database with a large amount of ETL rows to groom. This script will groom --
-- The ETL entries in a loop 100K rows at a time to avoid filling up the --
-- Transaction log --
---------------------------------------------------------------------------------
DECLARE @RowCount int = 1;
DECLARE @BatchSize int = 100000;
DECLARE @SubscriptionWatermark bigint = 0;
DECLARE @LastErr int;
-- Delete rows from the EntityTransactionLog. We delete the rows with TransactionLogId that aren't being
-- used anymore by the EntityChangeLog table and by the RelatedEntityChangeLog table.
SELECT @SubscriptionWatermark = dbo.fn_GetEntityChangeLogGroomingWatermark();
WHILE(@RowCount > 0)
BEGIN
DELETE TOP(@BatchSize) ETL
FROM EntityTransactionLog ETL
WHERE NOT EXISTS (SELECT 1 FROM EntityChangeLog ECL WHERE ECL.EntityTransactionLogId = ETL.EntityTransactionLogId) AND NOT EXISTS (SELECT 1 FROM RelatedEntityChangeLog RECL
WHERE RECL.EntityTransactionLogId = ETL.EntityTransactionLogId)
AND ETL.EntityTransactionLogId < @SubscriptionWatermark;
SELECT @LastErr = @@ERROR, @RowCount = @@ROWCOUNT;
END
  1. Remove Agents from pending management

    • In the Administration pane, expand Device Management, and then click Pending Management.
    • Right-click each agent, and then click Approve or Reject.
  2. Disable notification subscriptions

    • Also in Administration view, expand Administration, expand the Notifications container, and then click Subscriptions.
    • Select each subscription, and then click Disable in the Actions pane. (Do not try to multi select)
  3. Verify the OM database has more than 50 percent free

    • Open SSMS, expand Databases and right-click the OperationsManager database, select to Reports, Standard Reports, and then click Disk Usage.
    • View the Disk Usage report. If the database does not have 50 percent free, right-click the OperationsManager database, and then click Properties.
    • Under Select a page, click Files. In the results pane, increase the Initial Size value for the MOM_DATA database by 50 percent.
  4. Backup the OM databases (If not backup regularly)

  5. Stop Operations Manager website in IIS

  6. Increase agent HealthService cache size

    • Update the following registry setting on the agents: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlsSet\Services\HealthService\Parameters\Management Groups<ManagementGroupName>\maximumQueueSizeKb
    • Default is 15360 (15 MB), change it to is 76800 (75 MB).
    • Reset it back after upgrading.

Upgrade

  1. Log on to the server as an Operations Manager Administrators role.
  2. Run Setup.exe, click Install.
  3. Select install location.
  4. Review prerequisites, and click Verify prerequisites again to recheck.
  5. Configure accounts.

    If you receive a message about using the wrong version of SQL Server, or experience a problem with the SQL Server Windows Management Instrumentation (WMI) provider, you can resolve this. Open a Command Prompt window by using the Run as administrator option. Then run the following command, replace the placeholder with the location of Microsoft SQL Server:

    mofcomp.exe \Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof

  6. Review the upgrade summary, then click Upgrade if everything satisfies you.

Post-Upgrade

  1. Re-enable the Notification Subscriptions

  2. Reset agent HealthService Cache size

  3. Verify the upgrade was successful

    • In Operations console, open Administrator panel.
    • Under Device Management, click Management Servers. In the results pane, you should see the management server that you just installed with a green check mark in the Health State column.

Next Step

  1. See SCOM - Push Agent
  2. Get familiar to other management packs

(Ref: M$ SCOM Documents)

 上一篇

algorithm python data struction linked list node