Trying to connect Spotlight to Oracle database on a windows2003 server.
The database connect, but they keep receiving errors about Processors, System, Paging.
Spotlight on Oracle 6.0.0.1325
--------------------------------------------------------------------------------
Message:
An error occurred while refreshing the table Processors in connection NAME.
Click OK to continue,
Click Ignore to ignore any further errors related to this table, or
Click Disconnect to close this connection.
--------------------------------------------------------------------------------
Details:
The table Table_name could not be refreshed.
Error 80041010: Invalid class
Both Logical and Physical Disk Performance counters on this system are automatically enabled on demand.
Raw counters are also enabled for IOCTL_DISK_PERFORMANCE.
It is not a stand-by database.
O/S issue
This is a Windows OS monitoring problem. If OS monitoring is switched off for that Spotlight connection, the errors would go away.
The underlying issue is that the necessary WMI performance objects are not registered on the Windows 2003 server.
There are two reason why this might happen:
1. The Processor performance object is not enabled. The easiest way to check this is using the Microsoft extcrlst utility.
Install and run this utility, and identify the Windows 2003 server in the Machine Name field. Scroll down to look at the four services in turn: PerfDisk, PerfNet, PerfOS, PerfProc. In each case, the checkbox Performance Counters Enabled must be ticked.
2. The performance object is not registered with WMI. The easiest way to fix this is to use the Microsoft wmiadap (http://msdn.microsoft.com/en-us/library/aa394528(VS.85).aspx) utility on the Windows 2003 server, with the /f switch.
So checking and resolving both these items should get the OS monitoring working.
