none
The provider is not compatible with the version of Oracle client at Oracle.DataAccess.Client.OracleInit.Initialize() RRS feed

  • Question

  • Hello,

       For last 20 days i am trying to find out a solution for the Oracle error "The provider is not compatible with the version of Oracle client". I had gone through some forums and follow the possibilities but still it is not resolved. Could anyone please provide a solution for this?

    General Info:-

    OS in Server:- Windows 2012 R2

    Service pack:- No service pack

    System type:- 64bit operating system

    Oracle Client version:- 11.1.0

    ODAC version:-  ODAC1110720Xcopy

    Oracle.Dataaccess.dll versions available in GAC :- 2.111.7.20, 1.111.6.0, 1.111.6.0

     

       I have a service running in the server which uses the provider Oracle.dataaccess to get the data from Oracle db.Application wise i am using 2.111.7.20 version of Oracle.Dataaccess DLL but it was not included in the MSI. While calling the service method i am getting this error intermittently. 

    Workaround i have done so far:-

    1) Copied the oracle.dataaccess.dll in the bin folder of the application

    2) Copied the unmanaged Dll's of ODP.net like Oraops.dll to bin folder of the application.

    3) Tried "dependent Assembly" configuration in web.config to redirect the oracle.dataaccess dll to 2.111.7.20 version .

    4) Uninstall the other versions of Oracle.dataaccess.dll from GAC.

    Error deatils:- 

    Message=Apollo.MessageCenter.Core.Model.Utility.CircuitBreakerTrippedException: An exception has tripped the circuit breaker. from Half-Open ---> System.Web.Services.Protocols.SoapException: There was a problem with the GetMessageCenterMessages() method. Details: The current build operation (build key Build Key[Microsoft.Practices.EnterpriseLibrary.Data.Database, SDWSproc]) failed: Exception has been thrown by the target of an invocation. (Strategy type ConfiguredObjectStrategy, index 2) ---> Microsoft.Practices.ObjectBuilder2.BuildFailedException: The current build operation (build key Build Key[Microsoft.Practices.EnterpriseLibrary.Data.Database, SDWSproc]) failed: Exception has been thrown by the target of an invocation. (Strategy type ConfiguredObjectStrategy, index 2) ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleClientFactory' threw an exception. ---> Oracle.DataAccess.Client.OracleException The provider is not compatible with the version of Oracle client    at Oracle.DataAccess.Client.OracleInit.Initialize()
       at Oracle.DataAccess.Client.OracleClientFactory..cctor()
       --- End of inner exception stack trace ---
       --- End of inner exception stack trace ---
       at System.RuntimeFieldHandle.GetValue(Object instance, RuntimeTypeHandle fieldType, RuntimeTypeHandle declaringType, Boolean& domainInitialized)
       at System.Reflection.RtFieldInfo.InternalGetValue(Object obj, Boolean doVisibilityCheck, Boolean doCheckConsistency)
       at System.Reflection.RtFieldInfo.GetValue(Object obj)
       at System.Data.Common.DbProviderFactories.GetFactory(DataRow providerRow)
       at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
       at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetDefaultMapping(String name, String dbProviderName)
       at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetProviderMapping(String name, String dbProviderName)
       at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseCustomFactory.CreateObject(IBuilderContext context, String name, IConfigurationSource configurationSource, ConfigurationReflectionCache reflectionCache)
       at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.ConfiguredObjectStrategy.PreBuildUp(IBuilderContext context)
       at Microsoft.Practices.ObjectBuilder2.StrategyChain.ExecuteBuildUp(IBuilderContext context)
       --- End of inner exception stack trace ---
       at Microsoft.Practices.ObjectBuilder2.StrategyChain.ExecuteBuildUp(IBuilderContext context)
       at Microsoft.Practices.ObjectBuilder2.Builder.BuildUp(IReadWriteLocator locator, ILifetimeContainer lifetime, IPolicyList policies, IStrategyChain strategies, Object buildKey, Object existing)
       at Microsoft.Practices.ObjectBuilder2.Builder.BuildUp[TTypeToBuild](IReadWriteLocator locator, ILifetimeContainer lifetime, IPolicyList policies, IStrategyChain strategies, Object buildKey, Object existing)
       at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.EnterpriseLibraryFactory.BuildUp[T](IReadWriteLocator locator, ILifetimeContainer lifetimeContainer, String id, IConfigurationSource configurationSource)
       at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.EnterpriseLibraryFactory.BuildUp[T](String id, IConfigurationSource configurationSource)
       at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.NameTypeFactoryBase`1.Create(String name)
       at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase(String name)
       at Apollo.MessageCenter.Core.DAL.MessageServiceData.GetMessageCenterMessages(List`1& messages, Int64 irn, Int64 siteId)
       --- End of inner exception stack trace ---

    • Moved by Grady_Dong Thursday, December 10, 2015 5:47 AM Data Related
    Tuesday, December 8, 2015 9:48 AM

Answers

  • Hi Madhu.net,

    As your error message, it’s possible the provider version Incorrect. You can try download the The latest version from the following link.

    http://www.oracle.com/technetwork/topics/dotnet/downloads/net-downloads-160392.html

    On the Internet, it was resolved by an upgrade odp.net version of a similar problem.

    Before installation, you need to uninstall the old version.

    By the way, since you are using Oracle database, I suggest you could ask such questions on the Oracle forum,  you can get better technical support.

    https://community.oracle.com/welcome

    Best Regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Friday, December 11, 2015 8:17 AM
    Moderator

All replies

  • Hi Madhu.net,

    According to this case, I thought this case is related to Data forum more.

    I help you move this case to Data forum for dedicated support.

    Thank you for your understanding.

    Best Regards,

    Wanjun Dong


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. Click HERE to participate the survey.


    • Edited by Grady_Dong Thursday, December 10, 2015 5:44 AM
    Thursday, December 10, 2015 5:44 AM
  • Hi Madhu.net,

    As your error message, it’s possible the provider version Incorrect. You can try download the The latest version from the following link.

    http://www.oracle.com/technetwork/topics/dotnet/downloads/net-downloads-160392.html

    On the Internet, it was resolved by an upgrade odp.net version of a similar problem.

    Before installation, you need to uninstall the old version.

    By the way, since you are using Oracle database, I suggest you could ask such questions on the Oracle forum,  you can get better technical support.

    https://community.oracle.com/welcome

    Best Regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Friday, December 11, 2015 8:17 AM
    Moderator