About oracle path for configure file

转载于 2011-11-29 16:15:00 发布 · 153 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/cquccy/archive/2011/11/29/2267783.html

文章标签：

#数据库

本文讨论了在配置Oracle客户端程序时遇到的问题，包括使用不同配置文件导致的连接失败，通过修改PATH和NLS_LANG设置成功解决问题的过程。解释了为何在某些情况下修改配置可以解决问题，可能涉及驱动程序的兼容性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

first,
tnsping dev02, test configure in tnsnames.ora file,it's ok
secod
sqlplus username/password@dev02, is also work

but when i start the program, it return an exception
"Server did not respond within the specified timeout interval"

after contrast above two case,

i thinck it may be the configure has some problem, so i copy another program configure file to the machine, so i update the configure file.such as
before:
    <add key="Set.NLS_LANG" value="GERMAN_GERMANY.WE8MSWIN1252"/>
    <add key="Set.PATH.x32" value="%HOME%\Oracle.x32;%PATH%"/>
    <add key="Set.PATH.x64" value="%HOME%\Oracle.x64;%PATH%"/>
    <add key="Set.TNS_ADMIN" value="%HOME%"/>
after:
    <add key="Set.NLS_LANG" value="GERMAN_GERMANY.WE8MSWIN1252"/>
    <add key="Set.PATH" value="%HOME%;%PATH%"/>
    <add key="Set.TNS_ADMIN" value="%HOME%"/>
Then it works. but i not very clear why it happen ? may be by the driver

转载于:https://www.cnblogs.com/cquccy/archive/2011/11/29/2267783.html