ora-12154无法解决...使用Oracle Instant Client [英] ora-12154 could not resolve... with oracle instant client
问题描述
以下是详细信息:
- I installed the oracle instant client 11.2.0.2.0 from the OTN download page on a windows 7 64 bit vm (vmware).
- I am trying to to connect to a remote oracle database, and I can successfully connect with one program using TNS, but not with SQL*Plus and other applications.
- Trying to connect with SQL*Plus, using schema@servicename, password, etc, gives the above error.
- To connect via SQL Developer, normally I would use the basic connection info and not rely on tnsnames, but trying a normal connection gives me:
io error: unknown host specified. SQL Developer can successfully connect and query database if i use the TNS protocol. - Trying from other programs gives me the same error I got with SQL*Plus. Same when trying with the service name from tnsnames.
以一种方式而不是另一种方式工作显然很令人沮丧.我遵循了有关使用即时客户端的所有常规说明，将带有即时客户端的目录添加到PATH，还创建了TNS_ADMIN条目，并将目录添加到tnsnames.ora文件
This is obviously quite frustrating for it to work one way and not the other. I followed all the normal instructions for using the instant client, the directory with instantclient has been addded to the PATH, a TNS_ADMIN entry has also been created, with the directory to the tnsnames.ora file
推荐答案
好吧，一时兴起，我去更改了安装程序中的所有内容，以匹配以前使用即时客户端安装的Windows 2003 Server.主要更改是将即时客户端放在驱动器根目录下的文件夹中(而不是程序文件/oracle/etc)，但在c:/oracle中，我知道ive见过其他帖子，说oracle是关于目录路径中的字符的. ，也许空格也不行吗?
Well, on a whim, I went to changing everything in my setup to match an windows 2003 server that i had setup with instant client before. The main changes were putting the instant client in a folder at the root of the drive (not program files/oracle/etc), but c:/oracle, i know ive seen other posts saying that oracle was particular about characters in the directory path, maybe spaces are a no-no too?
我还添加了一堆其他环境变量，这是另一台计算机上的所有变量，ORACLE_HOME(到实例的根)，SQL_PATH(相同)，并将目录的根添加到PATH系统变量，而不仅仅是文件夹与InstantClient文件.无论如何，我很高兴它能正常工作，尽管其中任何一项更改都可以实现-
I also add a bunch more environmental variables, anythign that was on the other machine, ORACLE_HOME (to root of instance), SQL_PATH (same), and added the root of the directory to the PATH system variable, not just the folder with the instantclient files. Anyways, I'm happy its working, anyone one of these changes could have been it though-
这篇关于ora-12154无法解决...使用Oracle Instant Client的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
