Oracle.DataAccess provider incompatible only in dev server but not in prod and test server

Discussion in 'Databases' started by Md Samim, Aug 20, 2014.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. We have 3 environments Production, Test and Dev. And a web application is deployed in IIS of each server.
    In production and Dev environment the application works fine. But while trying to access the Dev environment the provider is incompatible issue occurs.
    The issue in dev server is below.
    ERROR Class->CDM.Controllers.BaseCdmController; Method->BindLocalSection;Message->BindLocalSection failed with exception
    System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' 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.OracleConnection..cctor()
    --- End of inner exception stack trace ---
    at Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString)
    at CDM.Domain.Concrete.OracleMasterRepository`1.GetData(DaoConfiguration daoConfig, GridSettings jqProperties, SearchState SearchCriteria)
    at CDM.Domain.Model.DataAccess`1.GetCustomerData(DaoConfiguration daoConfig, GridSettings jqProperties, SearchState SearchCriteria)
    at CDM.Controllers.BaseCdmController.BindLocalSection(IUserInfo userInfo, LocalSearchCriteria searchCriteria, GridSettings jqProperties)
    I have checked the versions for ODP.Net provider and Oracle client provider from GAC, Machine.config etc. for all environments.
    It shows the same version for all the environments but still the issue occurs for only development environment.
    The configuration for all servers are below.
    1) We are using .net 4.0 framework with Visual Studio 2010 installed and
    2) Oracle.DataAccess.dll version:- 2.111.7.20
    3) ODP.net version:- 11.1.0
    4) Directory of Oracle installed in Dev server: D:\app\bdsouza-adm\product\11.1.0\client_1
    5) Directory of Oracle installed in prod Server:- D:\Oracle\product\11.1.0\client_1
    Additionally all the environements are using 32 bit version enabled from IIS.
    The only diference which I could check between 3 environments is
    1) The path of oracle installation
    2) Another blank folder 11.2.0 do exists under path D:\app\bdsouza-adm\product\ for for only Development enviornment
    3) Extra file tnsname.ora exists in D:\app\bdsouza-adm\product\11.1.0\client_1\Network\Admin for only Development enviornment in addition to ldap.orac and sqlnet.ora.
    But it should not through provider incompatible error.
    I copied the unmanaged dlls like oci.dll, OraOps11w.dll, oraociicus11.dll in bin folder but of no use.
    Could anybody help me to know what is going on. Where is the issue? What needs to be done?
     
  2. Since that's not really a Winhost issue, this might not be the best place to get help. You may have better luck in an Oracle forum, or someplace where you can discuss your server config.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page