System Center Oprations Manager 2007 SP1 RTM Upgrade Diary
I just upgrade our SCOM environment to SP1 the other day. I have followed the Operations Manager 2007 SP1 Upgrade Guide which is in the UpdateCDImage.
The whole upgrade process is rather smooth except when I was trying to take OperationsManager DB offline to make a backup, It is “In Progress” forever. I have to hard “kill” the process and then tried the below query
ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK IMMEDIATE (The rollback immediately statement will force currently executing statements to rollback immediately)
I got an error message “ ALTER DATABASE failed because a lock could not be placed on database 'OperationsManager'. Try again later.”
After I stopped OpsMgr Config Service & OpsMgr SDK Service, I run the above query again – it worked imediately!
I then upgrade the agents using the Operations Console – In the administrtion pane, expand Device Management and then click Pending Management. In the pending Management pane, expand Type: Agent Require Update, select them all and Click Approve.
Most of our agents are upgraded successfully except two of our Blackberry Server and one Exchange (2000) Server. One Blackberry server was in “pending” reboot state. I don’t know if it is just a coincidence or not, a day later, the server stopped responding (Memory Leak?). We have to reboot the box which give me the opportunity to upgrade the agent. I still have WMI errors on the other two servers and I am waiting for a reboot opportunity and troubleshooting afterwards.
I also upgrade the Management Packs by importing the management packs in the UpdateCDImage. This part is also very cool. If you import a management with out importing the MP it depends on, the import process will fail. If you have an old version of the same MP, you will getting a message which tells the old MP (version number) will be replaced by the new MP (version number) and wait for your confirmation.
Now a couple of days after the upgrade. We get significantly less alerts on this one – “Alert: Script or Executable Failed to run” which we had a lot before the upgrade. But we do get a lot of alerts on this one “Alert: Performance Module could not find a performance counter” which I disabled for now.
All in all, this is a very smooth upgrade and I have to say Microsoft have done a great job to make our life easier!