asp. net could not load an error solution such as oci. dll

Solution 1

Repair method:

1: Find the installation directory of oracle client, such as: E:/oracle/ora92, select the directory, delete "ASP. NET, Users user" in "Properties -- Security", and then add it, and grant "complete control or modify permission"; Give everyone "full control or modify permission". Note: the directory permission of the website should also be set to ervryone full access, otherwise the website will also be inaccessible. Restart.
2: The simplest and most direct method is to enable ASP. Net user emulation, in web. config < system.web > < /system.web > Added in the configuration section: < identity impersonate="true" userName="USER" password="PASSWORD"/ >
Such as: < identity impersonate="true" userName="administrator" password="123456" > < /identity >

Solution 2

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

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

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSDTC/MTxOCI]
 " OracleXaLib " = " oraclient8.dll " 
 " OracleSqlLib " = " orasql8.dll " 
 " OracleOciLib " = " oci.dll " 

For the xp system in the first method, the property is default no security options, solution: tools - > Folder options - > View, remove the "use simple home sharing" option

Additional measures

ASP. NET connection to Oracle database failed to load DLL (ES64en. dll)
Unfolder option □ Simple file sharing (recommended)
The partition format of the ORACLE_HOME path is NTFS format:
Oracle installation directory under ora92 attribute - > security
So if you have permission set 1, anyone can access it or if you set it to ASPNET this user can access it
Ensure that ASP. NET users have access to ES80en. dll.