应用程序无法打开与 Oracle 数据库的连接 - 缺少 DLL OraOps9.dll
我的 .NET 应用程序尝试连接到 Oracle 数据库，但连接无法打开，因为它找不到“OraOps9.dll”。
xxx.CreatedbConnection() failed to open connection.
System.DllNotFoundException: Unable to load DLL (OraOps9.dll).
at Oracle.DataAccess.Client.OpsTrace.GetRegTraceInfo(UInt32& TrcLevel)
at Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString)
at Utilities.Database.OracleDBConnection.Open()
at xxx.CreatedbConnection(String userName, String password)
Oracle 客户端已安装，但该 DLL 不存在于我的 Oracle Home bin\ 文件夹 (C:\oracle\ora92\bin\) 中。我在哪里可以获得这个 DLL？
My .NET application tries to connect to an Oracle database, but the connection fails to open because it cannot find "OraOps9.dll".
xxx.CreatedbConnection() failed to open connection.
System.DllNotFoundException: Unable to load DLL (OraOps9.dll).
at Oracle.DataAccess.Client.OpsTrace.GetRegTraceInfo(UInt32& TrcLevel)
at Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString)
at Utilities.Database.OracleDBConnection.Open()
at xxx.CreatedbConnection(String userName, String password)
The Oracle client is installed but that DLL is not present in my Oracle Home bin\ folder (C:\oracle\ora92\bin\). Where can I get this DLL?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
ODP.NET 包含此 DLL，并且是特定客户端软件安装程序的一部分。据推测，客户端无需 ODP.NET 即可使用，这就是为什么我安装并运行了客户端，但没有安装特定的 DLL。
ODP.NET 客户端可在此处获取：
http://www.oracle.com/technology/software/ tech/windows/odpnet/utilsoft.html
特别是 9.2 的链接位于页面底部，或者直接下载链接：
http://download.oracle.com/otn/other/ole- oo4o/ODAC92070.exe (80MB)
下载并解压 80MB 客户端后，为了节省冗长的重新安装过程，请查找路径：
Disk1\stage\Components\ODP.NET\9.2.0.7.0\1\DataFiles将OraHomeBin.1.1.jar重命名为OraHomeBin.1.1.zip并解压。将内容复制到 Oracle Home
bin\目录并运行ODPReg.exe。应用程序现在应该能够正常连接。
您可以运行安装程序并仅在客户端上安装 ODP.NET。即使在手动安装/注册 DLL 之后，这也为我解决了挥之不去的连接问题。
ODP.NET contains this DLL and is part of a specific client software installer. Presumably the client is available without ODP.NET which is why I had the client installed and working but not that particular DLL.
The client with ODP.NET is available here:
http://www.oracle.com/technology/software/tech/windows/odpnet/utilsoft.html
Link for 9.2 in particular is all the way at the bottom of the page, or direct download link here:
http://download.oracle.com/otn/other/ole-oo4o/ODAC92070.exe (80MB)
After downloading and extracting the 80MB client, to save a lengthy reinstall process look for the path:
Disk1\stage\Components\ODP.NET\9.2.0.7.0\1\DataFilesRenameOraHomeBin.1.1.jartoOraHomeBin.1.1.zipand extract.Copy the contents to your Oracle Home
bin\directory and runODPReg.exe.Application should now be able to connect fine.
You can run the installer and install only ODP.NET over the top of the client. This fixed lingering connection issues for me even after manually installing/registering the DLL.
需要先注册一个Oracle账户。 （自由的）
然后转到：
http://www.oracle.com/technology/software/tech /windows/odpnet/utilsoft.html
向下滚动并在驱动程序下查找“Oracle Data Access Components for Windows（ODP.NET、ODBC、OLE、Dev Tools for Visual Studio）”
向下滚动并查找 Oracle9i Release 2 ODAC 9.2.0.7.0
接受许可协议
Need to register an Oracle account first. (Free)
Then go to:
http://www.oracle.com/technology/software/tech/windows/odpnet/utilsoft.html
Scroll down and look for "Oracle Data Access Components for Windows (ODP.NET, ODBC, OLE, Dev Tools for Visual Studio)" under Drivers
Scroll down and look for Oracle9i Release 2 ODAC 9.2.0.7.0
Accept License Agreement