Oracle ODAC 11g breaking TFS Team Sites


Problem

Last night I installed the Oracle ODAC client for 11g on my dev TFS Build machine which also happens to be the TFS App Tier and Sharepoint Server for the project sites. This morning, when I tried to access my project’s site, I got one of those generic .net error messages telling me “something is wrong but I won’t tell you what…”. Well, that’s not the exact wording but that’s what it meant. My first reaction was to think that all my project sites were gone.

So, after changing the CustomErrors mode from RemoteOnly to Off in the web.config file on my Default Website, I got the more descriptive error message:

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Type ‘Oracle.Web.Management.OracleWebEventProvider’ cannot be instantiated under a partially trusted security policy (AllowPartiallyTrustedCallersAttribute is not present on the target assembly).

Source Error:

[No relevant source lines]


Source File: machine.config Line: 177

The problem seems to be between an element that the Oracle installer added to my machine.config and WSS 2.0 used by the TFS Team Sites.

Solution

The section added by Oracle looked like this:

<healthMonitoring>

<providers>

<add name=”OracleWebEventProvider” type=”Oracle.Web.Management.OracleWebEventProvider, Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342″ connectionStringName=”OraAspNetConString” buffer=”true” bufferMode=”OracleNotification” />

</providers>

</healthMonitoring>

I removed the section from my machine.config and my Team Sites started working again. I am not sure what this is supposed to be used for but I will definately look into it to undersand why Oracle put it there in the first place and then why it broke WSS.

Advertisements