oracle 让 Toad 9.7 在 Windows 7 x64 上运行
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5461810/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Getting Toad 9.7 to work on Windows 7 x64
提问by Pedram
I'm trying to get Toad 9.7 to work on a new installation of Windows 7 x64. I installed a 64-bit Oracle instant client (manually by extracting to a folder and setting some environment variables). Things seemed to be OK (SQL Developer worked, SQL*Plus worked), but Toad was having problems.
我正在尝试让 Toad 9.7 在新安装的 Windows 7 x64 上工作。我安装了一个 64 位 Oracle 即时客户端（通过解压缩到一个文件夹并设置一些环境变量来手动）。事情似乎没问题（SQL Developer 工作，SQL*Plus 工作），但 Toad 有问题。
I then read that Toad needs a 32-bit client, so I "installed" that using the same method, but it still wasn't happy. It kept giving me an error saying that I didn't have an Oracle client installed. I tried many different things like setting different environment variables (LD_LIBRARY_PATH, ORACLE_HOME etc.) and nothing worked. I then scrapped the manual method and downloaded the full Oracle client but only checked the "instant client" option when I ran the setup, and that finally worked. Toad recognized the client and I got rid of those env. variables I had set, and only had TNS_ADMIN set, in addition to the oracle home folder in the system path.
然后我读到 Toad 需要一个 32 位客户端，所以我使用相同的方法“安装”了它，但它仍然不满意。它一直给我一个错误，说我没有安装 Oracle 客户端。我尝试了很多不同的事情，比如设置不同的环境变量（LD_LIBRARY_PATH、ORACLE_HOME 等），但没有任何效果。然后，我放弃了手动方法并下载了完整的 Oracle 客户端，但在运行安装程序时只检查了“即时客户端”选项，这终于奏效了。Toad 认出了客户，我摆脱了那些环境。除了系统路径中的 oracle 主文件夹之外，我已经设置了变量，并且只设置了 TNS_ADMIN。
There was still one problem. Toad didn't know the version of my oracle client and kept giving me error messages saying that the oracle home was invalid. I could ignore those messages and everything seemed to work, but I just didn't like the fact that the home it was using was coloured red and I had to tell it to ignore those error messages.
还有一个问题。Toad 不知道我的 oracle 客户端的版本，并不断给我错误消息，说 oracle home 无效。我可以忽略这些消息，一切似乎都有效，但我只是不喜欢它使用的家是红色的事实，我不得不告诉它忽略这些错误消息。
So after a little more digging and some guesses on my part, I got a kludge-ey method to work. I copied the oci.dll file into the bin folder under the oracle home, and I also made anothercopy of that file in the bin folder and called it oraclient11.dll. The combination of those two things got Toad to stop complaining.
因此，在我进行了更多挖掘和一些猜测之后，我得到了一种有效的方法。我复制了OCI.DLL文件到bin文件夹的Oracle主目录下，我也做了另一个在bin文件夹中的文件副本，并把它称为oraclient11.dll。这两件事的结合让蟾蜍停止抱怨。
However, that doesn't seem like a very clean method, so I was wondering if anyone else has come across this issue and used a cleaner method to get it working.
然而，这似乎不是一个非常干净的方法，所以我想知道是否有其他人遇到过这个问题并使用了一种更干净的方法来让它工作。
回答by Jon Heller
After you install the 32-bit client by extracting the files, set the PATH to point to the 32-bit directory. And make sure that the 32-bit directory is in the path BEFORE the 64-bit directories.
通过解压缩文件安装 32 位客户端后，将 PATH 设置为指向 32 位目录。并确保 32 位目录位于 64 位目录之前的路径中。
I think that's what worked for me but I'm not 100% positive.
我认为这对我有用，但我不是 100% 积极。
