R – System.Data.OracleClient requires Oracle client software version 8.1.7

asp.netoracle

I have the same problem as the poser of this question:

System.Data.OracleClient requires Oracle client software version 8.1.7

I have made the changes to the security settings on the oracle folder, and have to wait for the server to reboot overnight.

My question is why is this reboot necessary? I am getting the same error after making the changes without rebooting, so I don't doubt that it is. Is there an alternative to rebooting the server, like IISRESET? (Although I wouldn't be allowed to run IISRESET during the day either)

Best Answer

Perhaps not an answer to your specific question, but for the record it is for this kind of reasons that I always favor Oracle Instant Client :

  • You don't have to install anything on the target machines (including dev boxes !). So no tricky manual setup and goat sacrificing.
  • You can make sure that your application will run with the specific client you picked (version, x86/x64).
  • You could even easily have multiple applications work with different client versions on the same computer.
  • As a downside, it adds a significant weight to your application (~19Mb minimum), and you can't participate in distributed transactions.

If you still can switch, this is the way to go IMHO. Check What is the minimum client footprint required to connect C# to an Oracle database? for more information.

Related Topic