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 Andre Broers , ,
Applies to:

Oracle Data Provider for .NET - Version: 11.1.0.7.0

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

Microsoft Windows (32-bit)

Symptoms

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

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

Cause

The patch install scripts failed to register the performance counters.

Solution

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..

Syntax:

/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: