即使为11g安装了Oracle Instant Client，asp.net应用程序也未连接到oracle 11g [英] asp.net application not connecting to oracle 11g even after installing oracle instant client for 11g

问题描述

我有一个使用Oracle 11g数据库的asp.net mvc应用程序.在开发机中，一切正常，但是在将其部署到生产服务器中时，asp.net应用程序无法连接到数据库服务器.它总是抛出一个空异常.

I have a asp.net mvc application which is using oracle 11g database. In development machine every thing worked fine, but while deploying it in production server asp.net application is not able to connect to the database server. It is always throwing an empty exception.

我还编写了一个简单的控制台应用程序来测试数据库连接.它也不起作用.然后我意识到这是因为该计算机未安装oracle客户端.所以我为11g数据库32位版本安装了Oracle Instant Client.此后，控制台应用程序开始工作，但Web应用程序仍然无法连接.

I wrote also a simple console application to test the db connectivity. It is also not working. Then I realized it is because that the machine doesn't have a oracle client installed. so I installed Oracle instant client for 11g database 32 bit version. After this the console application started working but the web application still could not connect.

我在Google上搜索了很多，最后决定使用流程监视器进行分析.在进程监视器中，我发现Web应用程序(iis)正在寻找oraclient12.dll.

I google lot and finally decided to analyse using process monitor. In process monitor I found that the web application (iis) is looking for an oraclient12.dll.

此oraclient12.dll是12c数据库的oracle客户端的一部分.我不明白为什么它要寻找这个dll.

This oraclient12.dll is part of oracle client for 12c database. I can't understand why it is looking for this dll.

在安装12g的oracle数据库客户端之后，oraclient12.dll的上述问题已修复.但是iis现在无法找到oraclsce12.dll. 我在整个文件系统中搜索了该文件，但找不到.

After installing oracle database client for 12g, the above issue with oraclient12.dll got fixed. but iis is now not able to locate oraclsce12.dll. I searched the whole file-system for this file but could not find.

有人知道我应该安装什么才能获得oraclsce12.dll.

does anyone know what should i install to get oraclsce12.dll.

谢谢， 苏吉思

推荐答案

我遇到了类似的问题，然后得知要安装dll，现在还应该安装选项«Oracle Advanced Security»， ，方法是在安装oracle 12客户端时选择自定义安装.我做了同样的事情，我的问题就解决了.您可以尝试一下，看看问题是否得到解决.

I was facing similar issue, then came to know that for the dll to be installed you should now also install the option «Oracle Advanced Security»,, by choosing custom installation when installing the oracle 12 client. I did the same and my issue got resolved. You can try this and see if your issue gets resolved.

感谢Sudharsan

thanks Sudharsan

这篇关于即使为11g安装了Oracle Instant Client，asp.net应用程序也未连接到oracle 11g的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！