ORA-12557 TNS:协议适配器不可加载 [英] ORA-12557 TNS:protocol adapter not loadable
问题描述
我试图开发一个针对.net 4框架的C#Windows窗体应用程序。该程序将针对Oracle数据库执行一个存储过程,当我尝试打开与数据库的连接时,我收到以下错误。
ORA-12557 TNS:协议适配器不能加载
我在Visual Studio 2012中进行开发,并成功地使服务器资源管理器连接到数据库,但是我通过我的应用程序不断收到这个错误。 / p>
我的机器上有两个Oracle 11g客户端。一个是32位,另一个是64位。我需要两个不同的应用程序,所以它是不可能删除一个。我还尝试改变PATH变量中Oracle主目录的顺序。目前我有64bit一个第一,这是一个我想连接。
我使用ODP.NET将我的应用程序连接到数据库,并引用了64位应用程序的dll。
至于我可以告诉我已经做了什么建议,并没有设法得到它的工作。
ORA-12577错误与Windows环境或Oracle Home PATH相关,因为sqlplus命令工作顺利,当我执行它在ORACLE_HOME \bin。
由于在该机器上单独的ORACLE_HOME中有两个或更多的oracle安装(比如数据库和协同工作),在你的窗口中取消了ORACLE_HOME的值
有关详细信息,请按照以下步骤操作,希望你能得到解决方案中。
http://www.dba-oracle.com/t_ora_12577.htm
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:protocol adapter not loadable
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.
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.
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.
The ORA-12577 error is related to Windows Environment or Oracle Home PATH because sqlplus command works smoothly when I execute it inside ORACLE_HOME\bin . 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屋!