Wednesday, November 14, 2007

WMI Performance Adapter Event Log Spam

If your running oracle 10.2.0.3 on Windows, you may find the the System Event log being filled with Start Stop messages for the WMI Performance Adapter ... every few minutes or even more often...

Event ID:7036 The WMI Performance Adapter service entered the running state.
Event ID:7035 The WMI Performance Adapter service was successfully sent a start control.
Event ID:7036 The WMI Performance Adapter service entered the stopped state.


I hate Event Log Spam, then again, I find the event log very 1990's :)


Turns out it's due to an old NT4 dll, pdh.dll in the %ORACLE_HOME%\bin directory.

The fix is easy, stop your dbconsole service(s), rename the file and restart the dbconsole service(s).

The metalink docid is 454987.1

This feels like a much better solution than the autostart option for the service which has been mentioned around the web.

Why didn't the latest critical update for oracle (oct 07) include this, I consider this to be very critical as it obscures important the event log entries...hmmm

Side Note: The McAfee McShield service entered the running state is a bug in the version 8.50i of viruscan :(

6 comments:

Anonymous said...

THANK YOU!!!

Anonymous said...

Thank you too !!

Anonymous said...

Yeees --- Thank you --a lot

Brad N said...

Hey zac
reading the blog wmi performance adapter (Nov-07). I have the same problem and am running oracle 10.2.0.3.

For clarification. you say shutdown dbconsole, rename the file, then restart them?
does this mean oracle does not need the dll? if I rename it to junk.dll.
Also what "them" am I restarting?
Is that a typo and you mean restart the dbconsole?
Thanks

Zac Spitzer said...

No oracle doesn't need this file

Good catch, you need to restart the dbconsole (i have updated the entry to reflect)

Anonymous said...

I was lost, I tough that was a windows problem. thnks a lot.