ORA-12557 TNS:无法加载协议适配器 [英] ORA-12557 TNS:protocol adapter not loadable

问题描述

我正在尝试开发一个面向 .net 4 框架的 C# Windows 窗体应用程序.该程序将对 Oracle 数据库执行存储过程，当我尝试打开与数据库的连接时出现以下错误.

I am trying to develop a C# Windows Forms Application targeting the .net 4 framework. The program will execute a stored procedure against an Oracle Database and I get the following error when I try to open the connection to the database.

ORA-12557 TNS:无法加载协议适配器

ORA-12557 TNS:protocol adapter not loadable

我正在 Visual Studio 2012 中开发它，并设法使服务器资源管理器成功连接到数据库，但是我的应用程序不断收到此错误.

I am developing this in Visual Studio 2012 and have managed to make the Server Explorer connect to the database successfully, however I keep getting this error through my application.

我的机器上有两个 Oracle 11g 客户端.一个是32位的，另一个是64位的.对于不同的应用程序，我确实需要两者，因此无法删除一个.我还尝试更改 PATH 变量中 Oracle 主目录的顺序.目前我有第一个 64 位，这是我想连接的那个.

I have two Oracle 11g clients on my machine. One is 32bit and the other is 64bit. I do need both for different applications so it is not possible to remove one. I have also tried changing the order of the Oracle home directories in the PATH variable. Currently I have the 64bit one first which is the one I would like to connect with.

我正在使用 ODP.NET 将我的应用程序连接到数据库，并从 64 位应用程序中引用了 dll.

I am connecting my application to the Database using ODP.NET and have referenced the dll from the 64bit application.

据我所知，我已经完成了建议的工作，但没有设法让它发挥作用.如果有人可以提供帮助，将不胜感激.

As far as I can tell I have done what has been suggested and have not managed to get it working. If anyone could help it would be appreciated.

推荐答案

ORA-12577 错误与 Windows Environment 或 Oracle Home PATH 相关，因为当我在 ORACLE_HOMEin 中执行 sqlplus 命令时，它可以顺利运行.这是因为在该机器上的单独 ORACLE_HOME 中安装了两个或多个 oracle(例如数据库和配套)，在您的窗口中取消设置 ORACLE_HOME 值有关详细信息，请按照以下步骤操作，希望您能得到解决方案.http://www.dba-oracle.com/t_ora_12577.htm

The ORA-12577 error is related to Windows Environment or Oracle Home PATH because sqlplus command works smoothly when I execute it inside ORACLE_HOMEin . Its because of two or more oracle installs (say database and companion) in separate ORACLE_HOMEs on that machine unset the ORACLE_HOME value in your window For Details please follow the following steps and hope so you will get the solution. http://www.dba-oracle.com/t_ora_12577.htm

这篇关于ORA-12557 TNS:无法加载协议适配器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！