Wednesday, January 27, 2010

ODP.NET Performance counters do not show up after patching 11106 clientto 11107 [ID 826875.1]

Wednesday, January 27, 2010 Posted by Unknown , ,
Applies to:

Oracle Data Provider for .NET - Version:

Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)

Microsoft Windows (32-bit)


After patching an Oracle client install containing the Oracle Data Provider for .NET (ODP.NET) with the RDBMS patch, the provider is upgraded to include the functionality of the ODAC2007 ( release.

However, the Oracle Data Provider for .NET Performance Counters don't show up in Performance Monitor.


The patch install scripts failed to register the performance counters.


To resolve the problem, register the counters manually as an additional step using OraProvCfg, which can be found in the ODP.NETbin2.x folder of the OracleHome..


/action:register /product:odp /component:perfcounter /providerpath:

Example: using an OracleHome located at C:appAdministratorproduct11.1.0client_1, the following command would be used (all on one line):

C:appAdministratorproduct11.1.0client_1ODP.NETbin2.xOraProvCfg /action:register /product:odp /component:perfcounter /providerpath:C:appAdministratorproduct11.1.0client_1ODP.NETbin2.xOracle.DataAccess.dll

After running the above command, the Performance Counters should now show up in Perfmon.


Put the following in the web/app.config to enable all oracle performance counters: