This content has been marked as final. Show 7 replies
Which version of ODP is your app actually using?
10201 ODP relies on your PATH environment variable. If you install 10201 first, then add an 11g install, the 11g install will come before the 102 install in your path. If your app is using 10201 and that's the situation, either putting the 10201 home to the top in the Oracle Universal Installer, or manually adjusting your PATH so that the 10201 OH\BIN comes before 11g should resolve the issue.
Hope it helps,
Edited by: gdarling on Mar 27, 2012 11:31 AM
Also, you're actually using the ASP.NET providers then, as opposed to simply coding an ODP.NET app? If so, what version of ODP.NET does the app itself use?
I'm not sure whether the ASP.NET stuff runs in the same process space as the app itself, but I suspect there may be a conflict trying to load multiple versions into the same process.
Thanks for the reply.
The following Version of odp.net are available in the refernce of the applocation
184.108.40.206 from the following location E:\app\100468\product\11.1.0\client_1\odp.net\bin\2.x\Oracle.DataAccess.dll
10.2.0.100 from location F:\oracle\product\10.2.0\db_2\BIN\Oracle.DataAccess.dll
The following Version of asp.net are available in the refernce of the applocation
220.127.116.11 from location E:\app\100468\product\11.1.0\client_1\ASP.NET\bin\2.x\Oracle.Web.dll
Thanks and Regards
As u said removed the multiple versions and with a single version getting follwing error when running the application.
Parser Error Message: Could not load file or assembly 'Oracle.Web, Version=18.104.22.168, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
Line 176: <healthMonitoring>
Line 177: <providers>
Line 178: <add name="OracleWebEventProvider" type="Oracle.Web.Management.OracleWebEventProvider, Oracle.Web, Version=22.214.171.124, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" buffer="true" bufferMode="OracleNotification" />
Line 179: </providers>
Line 180: </healthMonitoring>
Source File: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config Line: 178
I'm not sure if "na" means "disregard, I figured it out", but the error you're getting now is that it's looking for *11.2* ODP. Did you previously have 11.2 installed? If so, and you removed it, did you also remove the policy files?
Was the app compiled with 11.2?
The best thing to do at this point may be to completely remove the oracle client software, and "start over" clean, and install only a single Oracle home, but it kind of looks like you also have a 10.2 database on that box?
Note also that 10.2.0.1 ODP was only 1.x, and as of 126.96.36.199.20 and newer (ie, 11.2) ODP.NET, there is no more 1.x.
You might want to open a SR with support and we'll give you a hand getting it all sorted out.