ODBC管理员找不到Oracle TNS名称文件 [英] ODBC Administrator Can't Find Oracle TNS Names File

问题描述

对于新安装的Oracle，当我进入Configuration Management Tools > Microsoft ODBC Administrator > System DSN > Add > [new installation]时，下拉菜单中没有TNSNAMES.ora连接名称.在旧的安装中，此方法已奏效.

With a new Oracle Installation when I go to Configuration Management Tools > Microsoft ODBC Administrator > System DSN > Add > [new installation] it does not have the TNSNAMES.ora connection name in the drop down. With the old installation, this had worked.

我尝试更新环境路径和注册表项，但仍然找不到让ODBC在下拉列表中查看它的方法.

I've tried updating Environment Paths and Registry keys but still can't find a way to get ODBC to see it in the drop down.

以前在Windows Server上安装了Oracle Client.我试图删除大多数文件，但是Oracle DBA表示我们可以再次安装并使用新位置更新环境路径.

There was a previous installation of Oracle Client on the Windows Server. I tried to remove most of the files but our Oracle DBA said we could just do another install and update the Environment Paths with the new location.

我了解在> 此处 和 此处 关于此问题.但是，我不确定TNS PING是否会有所帮助，因为这似乎与环境路径和ODBC能够找到.ora文件有关.

I understand there are two other posts on SO here and here regarding this issue. However, I'm not sure TNS PING will help yet because it seems to be an issue regarding Environment Paths and ODBC being able to locate the .ora file.

TNSNAMES.ORA位置

TNS_Admin = E:\app\[username]\product\11.2.0\client_1\network\admin\TNSNAMES.ora

环境变量

TNS_Admin = E:\app\[username]\product\11.2.0\client_1  
Path = E:\app\[username]\product\11.2.0\client_1

注册表项
home3是新安装.我应该删除旧的注册表项(home2)吗? HKLM\SOFTWARE\ORACLE\KEY_OraClient11g_home2和\..._home3

此外，如果我在创建新数据源"屏幕中选择"OraClient11g_home2"，则下拉列表中将显示以下内容:

Also, if I select "OraClient11g_home2" in the Create New Data Source screen here is what is displayed in the drop down:

推荐答案

这似乎是风滚草，但只针对可能遇到相同问题的每个人；我可以通过使用 Net来解决此问题配置助手 向导，并提供正确的信息.它以正确的格式 AND 生成了tnsnames.ora，并且应注意，给我的文件名是tsnames.ora！

It appears the tumbleweed rolled by on this one but just for everyone who may be experiencing the same issue; I was able to fix this by using the Net Configuration Assistant wizard and providing the right information. It generated tnsnames.ora in proper format AND it should be noted that the filename given to me was tsnames.ora!

这篇关于ODBC管理员找不到Oracle TNS名称文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！