尝试为错误 ORA-01019 检索文本时出错 [英] Error while trying to retrieve text for error ORA-01019

问题描述

我有一个关于 oracle 的问题.我有一台机器，之前安装了 Oracle 客户端.我能够使用客户端连接到我的 oracle 服务器.

I have a question related to oracle. I have a machine which earlier had Oracle client installed on it. I was able to connect to my oracle server using the client.

现在我最近在同一台机器上安装了 oracle 11g DB.现在我安装了一个客户端和 Oracle 11g DB.但是有些我无法再连接到 oracle 服务器.这似乎有点问题，因为我在路径和注册表项中得到了两个 oracle home 和内容.

Now I recently installed oracle 11g DB on the same machine. Now I have one client and Oracle 11g DB installed. But some how I am not able to connect to oracle servers anymore. This seems a bit problem because I am getting two oracle homes and stuff in path and registry entry.

我在连接时遇到的错误是[Microsoft][ODBC driver for Oracle][Oracle]尝试检索文本时出错 ORA-01019

The error that I am getting while connecting is [Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve text for error ORA-01019

注意:我曾经遇到过类似的问题，但是一旦我卸载了 oracle DB 服务器并且删除了 ORACLE_HOME 条目，一切开始正常.

Note: I had a similar problem once but once I uninstalled the oracle DB server and removed the ORACLE_HOME entries things started working fine.

你能帮我解决这个问题吗?如果您需要更多信息，请告诉我

Could you please help me fix this problem. Do let me know if you need more information

推荐答案

嗯，

刚刚解决了.虽然有两个安装，但我们有两个 ORACLE_HOME 目录，并且都有 SQAORA32.dll 文件.在查找 ORACLE_HOME 时，我的应用程序变得很困惑..我刚刚删除了客户端 oracle home 条目，因为 oracle 客户端默认存在于 oracle DB 中现在它可以工作了...谢谢！！

Just worked it out. While having both installations we have two ORACLE_HOME directories and both have SQAORA32.dll files. While looking up for ORACLE_HOMe my app was getting confused..I just removed the Client oracle home entry as oracle client is by default present in oracle DB Now its working...Thanks!!

这篇关于尝试为错误 ORA-01019 检索文本时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！