1 2 3 4 Previous Next 45 Replies Latest reply on Apr 6, 2011 9:19 AM by 826457 Go to original post
      • 30. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
        573436
        I faced similar problem for a dotnet application. Tried all these steps. It worked only after reinstalling the Oracle Client.

        Thanks.

        Subhani Shaik
        • 31. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
          610625
          Hi,

          I have been with the same problem.
          - App with .NET Framework 1.1
          - Oracle Database
          - Running in Windows Server 2003

          I tried all solutions described here...and nevertheless iit didn't work..

          So, I just removed my Application from my server folder and I paste it again. I refreshed my browser and it works fine...

          Remember:
          In 'bin' folder you must have to include the Oracle.DataAccess.dll and OraOps10.dll, otherwise it will not work.
          • 32. Mismatched .dlls after an Oracle upgrade from 10.2 to 10.3.
            615667
            After upgrading our Windows 2003 server we discovered that it installed a bad .dll
            oraops10.dll. Our web app could not connect - the error stated 'unable to find entry point in oraops10.dll'. Looking at the new .dll the upgrade installed ,we noticed the version number was strange - 10.102.0003.000. We located a good .dll 10.2.0.2 and replaced the new one with the 10.2.0.2 version , restarted the server and the problem went away.
            • 33. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
              685405
              Flavio:

              Am I correct to assume that your step #10 is for me to check on the checkbox that says "Replace permission entries on all child objects with entries shown here that apply to child objects" ?

              I installed:

              •     Oracle 9.2.0.1.0
              •     Oracle Data Provider for .NET 9.2.0.7.0 (from ODAC92070)

              onto my Windows 2003 server.

              When I execute my ASP.NET 2.0 program, I get this error:

              Unable to load DLL '*OraOps10.dll*': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
              Exception Details: System.DllNotFoundException: Unable to load DLL '*OraOps10.dll*': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

              Do you know why I get this error when I did NOT install Oracle 10?

              Any suggestions is greatly appreciated!
              • 34. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
                gdarling - oracle
                Apparently you're using an app that was compiled with 10g ODP. You can use an app with a newer version of ODP (via the policy files that install with the provider), but not an older one. You'd need to either install the same or higher version of ODP than the app was compiled with, or recompile the app with 9.2. but 9.2 odp was not certified with .NET 2 anyway.

                And, regarding the steps to manually correct permissions, yes you need to apply the permission change to child objects as well. The better thing to do though is simply apply the latest patch for the version of your client, which will run a utility that will automatically fix the permissions issue.

                Hope it helps,
                greg

                Edited by: gdarling on Feb 16, 2009 5:36 PM

                Actually, I may have mispoke. The error you're getting means that 10g ODP cant find 10g oraops. Apparently you have 10g odp on your box and it's getting picked up by the app. Perhaps your app was compiled with 10g and distibuted it as well, or maybe the app was compiled with 9.2 and due to policy files it's getting redirected to a 10g odp. Either way, its fairly safe to say you have 10g odp and it's getting picked up by the app.
                • 35. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
                  685405
                  gdarling:

                  Thanks for replying.

                  What are you referring to when you say "app"? I assume that you are not referring to my ASP.NET 2.0 application, since it cannot be compiled by Oracle.

                  I exported a database (schema) from Oracle 9.2.0.1.0 on an old server. On my second server, I installed the Oracle 9.2.0.1.0 database engine and then I imported the database (schema). Onto a third server, I installed ODP for .NET 9.2.0.7.0 to enable my ASP.NET 2.0 applicaton to connect to the Oracle database. Are you referring to Oracle 9.2.0.1.0, or the database or ODP for .NET as the "app"?

                  Maybe the policy files are redirecting to a 10g ODP. Is it possible to change these policy files? How do I find them?

                  Where do I get the latest patch for the client to fix the permission issue?

                  Also, as mentioned, I installed ODP for .NET (and my ASP.NET 2.0 application) onto my third server, which is on a different server than where I installed Oracle 9.2.0.1.0. Does this make a difference? Could this be causing the problem?
                  • 36. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
                    gdarling - oracle
                    Hi,

                    By "app" I'm referring to the ASP.NET box where ODP.NET is installed.

                    Is/was your app compiled on a different machine and deployed to this one? If so, what version was it compiled with, and does that box have 10.2 installed?

                    You can check to see what Oracle.DataAccess.dll is getting loaded, and from where, via tools like [Process Explorer|http://sysinternals.com] for example.

                    You'd only have 10.2 policy files if you installed 10.2 ODP/client, or the redirect could be occurring if your app.config/web.config has an entry redirecting to the newer version for some reason.

                    If you don't want the default policy files that ODP installs, you can just delete them from the GAC (Policy.10.2.Oracle.DataAccess for example), but your app would only run with the specific version of ODP it was compiled with in that case, unless you redirected via your app/web.config.

                    You get the latest patch for your client install via Metalink. For 9.2, the 9.2.0.8 patch is on Metalinnk as patch number 4547809 .

                    cheers,
                    Greg
                    • 37. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
                      685405
                      Greg,

                      The ASP.NET 2.0 application was not compiled. The ASPX files are running in interpretted mode, and were copied from the old server which was running Oracle 9.

                      On my second server (with Oracle database), Process Explorer showed that the server is running:

                      Oracle MTS Recovery Service
                      Oracle Intelligent Agent Executable
                      Oracle RDBMS Kernel Executable

                      Are any of these related to Oracle 10? I cannot find anything that resembles Oracle 10.

                      On the third server (with ASP.NET 2.0 application), Process Explorer did not show anything loaded from Oracle.

                      I cannot find anything resembling Oracle 10 in my web.config. It has this:

                      <compilation debug="true" strict="true" explicit="true">
                                     <assemblies>
                                          <add assembly="Oracle.DataAccess, Version=9.2.0.700, Culture=neutral, PublicKeyToken=89B483F429C47342"/>
                                     </assemblies>
                      </compilation>

                      using Windows Explorer on the third server, I searched for "app.config". It did not find this file. However, it found many instances of PrecompiledApp.config, but none of them were in the domain set up for this ASP.NET 2.0 application.

                      Should I create an app.config file? If so, what is the source code to redirect to Oracle 9?

                      I tried to execute C:\gacutil.exe from a CMD window and it said that gacutil.exe is not recognized. How do I start and use GAC to delete Policy.10.2.Oracle.DataAccess ?

                      For the properties of C:\oracle\ora92 on my second server (with Oracle database), I added ASPNET user and IWAM user and gave them full control. For Authenticated User, I clicked off Read/Execute, applied, clicked on Read/Execute, applied. I clicked on the checkbox that says "Replace permission entries on all child objects with entries shown here that apply to child objects" and applied.

                      Curt
                      • 38. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
                        gdarling - oracle
                        Hi Curt,

                        You only need to concern yourself with the ASP.NET box.

                        Use Process Explorer to search for processes using Oracle.DataAccess (use the find menu at the top). Set the bottom pane to show dll's, and also to include full PATH to the dll's.

                        Also search the box using regular windows OS search for all occurrences of Oracle.DataAccess.dll.

                        I'm pretty confident you'll find you have 10g laying around for some reason or other, and that's what's getting loaded by IIS. Perhaps it was already there before you installed 9i?

                        You can view/add/remove things to/from the gac by browsing with Windows Explorer to c:\windows\assembly. You can remove things from the gac (in this case, a policy file) by clicking it then hitting the delete key on your keyboard.


                        Hope it helps,
                        Greg
                        • 39. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
                          685405
                          Greg,

                          Thanks for your replies!

                          I used the Find menu and searched for Oracle.DataAccess. It found:

                          Process Type Handle or DLL
                          w3wp.exe 3260 DLL C:\WINDOWS\assembly\GAC\Oracle.DataAccess\10.2.0.100__89b483f429c47342\Oracle.DataAccess.dll
                          w3wp.exe 3260 Handle C:\WINDOWS\assembly\GAC\Oracle.DataAccess\10.2.0.100__89b483f429c47342\Oracle.DataAccess.dll

                          Using Windows Explorer to search for Oracle.DataAccess.dll, I found this:

                          C:\oracle\product\9i\bin\Oracle.DataAcess.dll
                          C:\oracle\product\9i\ODP.NET\PublisherPolicy\Policy.9.2.Oracle.DataAcess.dll

                          I went to c:\windows\assembly and saw these:

                          Assembly Name Version Culture
                          Oracle.DataAccess 9.2.0.700
                          Oracle.DataAccess 10.2.0.100
                          Oracle.DataAccess.resources 10.2.0.100 pt-BR
                          Oracle.DataAccess.resources 10.2.0.100 it
                          Oracle.DataAccess.resources 10.2.0.100 fr
                          Oracle.DataAccess.resources 10.2.0.100 es
                          Oracle.DataAccess.resources 10.2.0.100 de
                          Policy.9.2.Oracle.DataAccess 9.2.0.700
                          Policy.9.2.Oracle.DataAccess 10.2.0.100

                          Should I simply delete all of the ones with Version 10.2.0.100 and leave just these two?:

                          Assembly Name Version Culture
                          Oracle.DataAccess 9.2.0.700
                          Policy.9.2.Oracle.DataAccess 9.2.0.700

                          If I do this, do I still need to create an app.config file or change my web.config file?
                          • 40. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
                            gdarling - oracle
                            Hi Curt,

                            So, apparently you did have 10.2 ODP at one time, and now the policy files are pointing your 9.2 app to use the 10.2 ODP. However, apart from the GAC'd ODP, you dont have 10.2 anymore. So, assuming that is the case and you dont have 10.2 anymore (other than the GAC at least), you should be able to just delete all the 10.2 things from the gac, no web or app.config modification should be needed.

                            Cheers,
                            Greg
                            • 41. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
                              685405
                              Greg,

                              THANK YOU SO MUCH!!!

                              I deleted the Oracle 10 entries from c:\windows\assembly and now I don't get that error message anymore.

                              Curt
                              • 42. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
                                752591
                                A very simple and quick fix -->

                                search OraOps.dll and copy it into your c:\..\oracle_home\bin.

                                Hurray.. :-)

                                Kesar
                                • 43. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
                                  757561
                                  I had the same problem with a .net window service I created.
                                  In my developer machine everything worked but in others client machines with .net Framework installed, I always got the same error message.

                                  I solved my problem by installing the Oracle Data Access Components (ODAC) on each client machine.

                                  You can download DOAC from : http://www.oracle.com/technology/software/tech/windows/odpnet/index.html
                                  Make sure you choose the right version and install it in a new Oracle home.

                                  Best Regards
                                  jkpd
                                  • 44. Re: One way to fix the "Unable to load DLL (OraOps.dll)" error
                                    user3635589
                                    Just had this very same issue. Found this thread...

                                    Without modifying any permissions we just rebooted the server and POOF it worked.

                                    I should probably mention that we had Oracle 9i client and installed 10g client with ODP.Net.