Shulou(Shulou.com)06/03 Report--

This article introduces the relevant knowledge of "how to solve the error problem such as asp.net can not load oci.dll". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Solution one

Repair method:

1: find the installation directory of the oracle client, for example: E:/oracle/ora92, select the directory, delete "ASP .NET, Users users" in "Properties-Security" and then add it, and give "full control or modify permission" to everyone. Note: the directory permission of the website should also be set to ervryone full access, otherwise oracle, the website can not be accessed either. Restart.

2: the simplest and most straightforward way is to enable ASP .net user emulation, which is added in the configuration section of web.config:

Such as:

Solution two

Studied for a long time, what directory permissions, ah, the registry, ah, did not work.

Finally, I had no choice but to copy oraclient8.dll,orasql9.dll,oci.dll to System32 to solve the problem.

The copy code is as follows:

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSDTC/MTxOCI]

"OracleXaLib" = "oraclient8.dll"

"OracleSqlLib" = "orasql8.dll"

"OracleOciLib" = "oci.dll"

For the first method of the xp system, there is no security option by default in the properties. The solution: tools-> folder options-> View, and remove the option of "use simple home sharing".

Other methods are attached.

Fixed the failure to load DLL (oci.dll) when ASP.NET connected to the Oracle database

Cancel □ to use simple file sharing in folder options (recommended)

The partition format where the ORACLE_HOME path is located is in NTFS format:

Ora92 attribute-> Security under the Oracle installation directory

If the permission is set, anyone can access it or the user ASPNET can access it.

Ensure that the ASP.NET user has access to oci.dll.

This is the end of the content of "how to solve the error problem such as how asp.net can not load oci.dll". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.