I am using NHibernate. On all our developer machines, all the unit tests run fine, but on our test server, none of the tests run.

In a nutshell, I always get the following error:

---> System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation. ----> System.DllNotFoundException : Unable to load DLL 'OraOps10.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
NHibernate.ADOException : Could not execute query ----> System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation. ----> System.DllNotFoundException : Unable to load DLL 'OraOps10.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

I have tried with both the OracleClientDriver and OracleClientDataDriver.

I know this is more of an Oracle question, but I think my problem may be related to how NHibernate uses ADO.NET?

I have tried the following, as per all the (minimal) documentation I can find:

Setting Read and Execute access to the account running the tests.
Setting the ORACLE_HOME environment variable.

The funny thing is that it works fine when I run the tests manually from the NUnitGUI.

FYI: The unit tests are being run from NAnt as part of a CruiseControl build.

Does anyone else have any suggestions as to how to start to resolve this one?

Thanks in advance, (hopefully!)

You might try to reboot the test server. I've encountered this issue a few times in the past and it drove me nuts. All permissions were set right, but still the error. Finally, after a reboot everything went smoothly. Don't ask me why, but it did help...

Thanks.. that was one of the other things I've already tried!

Try copying oraops to the bin directory manually. else register the same with GAC. That should work...

I have done everything possible according to all the answers here and out there in other Google searches... still nothing works.

I am having more and more problems getting Oracle working... I have wasted the whole day today as well as previous days!

Oracle is so unhelpful for developers.. OTN is useless, and that is the best documentation available!

Grrrrrrr!!!!!!!

I'm going to ensure that I get back to SQL Server for my next contract!

Try setting Everyone Full Access to the directory holding oracle client installation. Afterwards, boot the machine.

I was having the same issues and I solved them this way.

Regards,
Robert

I tried everything.. I give up.. I'm using the OracleClient at the moment.. maybe I'll try again when I get more time.. maybe get a witch doctor in...

I'm getting sick of trying to solve Oracle problems......

If you use ODP.NET uninstall it (and removing the files remaining in your home directory by hand after restarting, but backup your tnsnames.ora and sqlnet.ora before doing that) and install your ODP.NET completely new. If you use ODP.NET 10.1.4.00 also install the patch 10.1.4.01 which you can find on the Oracle developer site.

I had the same problem without using NHibernate and that helped for me.

Marco

I had a similar issue with just using standard ADO.Net with the Oracle .Net libraries.

This was for an ASP.Net web application. As soon as I granted more access to the account that runs the IIS service everything worked fine.

I think you may still have some kind of a security issue here.

thnx