blocks|key|4668568|text|ORA-12577错误与Windows+Environment或Oracle+Home+PATH有关，因为当我在ORACLE_HOME\bin中执行sqlplus命令时，它可以顺利地工作。这是因为两个或更多oracle安装(比如数据库和配套)安装在计算机上单独ORACLE_HOMEs中。有关详细信息，请在您的窗口中取消设置Oracle值。有关详细信息，请按照以下步骤操作，希望您能得到解决方案。http://www.dba-oracle.com/t_ora_12577.htm|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4668569|entityMap|0|LINK|mutability|MUTABLE|url|http://www.dba-oracle.com/t_ora_12577.htm^0|5I|15|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

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.
<a href="http://www.dba-oracle.com/t_ora_12577.htm">http://www.dba-oracle.com/t_ora_12577.htm</a>

blocks|key|4668588|text|基本问题是Oracle即时客户端安装中缺少应用程序所需的RDBMS服务器安装中存在的DLL。这就是为什么将Oracle+home从client_1切换到db_1是可行的，而不是纯粹的路径问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4668589|sqlplus在这两种情况下都可以使用，因为它使用的DLL集最小，这两种Oracle安装都存在。|4668590|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

The base problem is that there are DLLs missing in the Oracle instant client installation that exist in the RDBMS server installation that the application requires. This is why switching Oracle homes from client_1 to db_1 works, rather than it being a purely a PATH problem.

sqlplus works in either situation because it uses the minimal set of DLLs which exist in both Oracle installations.

blocks|key|4668632|text|对于我来说，我使用的是IIS+.net提供程序。通过在路径中将oracle64放在oracle32之前，我能够用sqlplus解决这个问题。这并没有解决.net的问题。我有使用oracle32和oracle64的应用程序。要解决这个问题，注册表项HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE必须指向\oracle32主目录，而HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE必须指向\oracle(64)主目录。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4668633|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

For me I am using IIS .net provider. I was able to fix the problem with sqlplus by putting oracle64 before oracle32 in the path. This did not fix problems with .net. I have apps that use oracle32 and oracle64. To solve this problem registry keys HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE must point to \oracle32 home and HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE must point to the \oracle(64) home.

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.

ORA-12557 TNS:protocol adapter not loadable

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在尝试开发一个针对.net 4框架的C# Windows Forms应用程序。该程序将对Oracle数据库执行存储过程，当我尝试打开到数据库的连接时，我得到以下错误。ORA-12557 TNS:协议适配器不可加载我是在Visual Studio 2012中开发的，并且已经设法使服务器资源管理器成功地连接到数据库，但...

问ORA-12557 TNS:协议适配器不可加载
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ORA-12557 TNS:协议适配器不可加载EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ORA-12557 TNS:协议适配器不可加载
EN