tns
tns_names.ora文件未在pl / sql开发人员中显示(tns_names.ora file not showing in pl/sql developer)我正在使用开发Oracle 10g和pl / sql 9.0.6。 问题是一切正常，但是当我也安装开发Oracle 6i报告时，我在pl / sql开发人员数据库中看不到“tnsnames.ora”。 我在Oracle 10g中配置了与oracle 6i中相同的tnsnames.ora文件。 我已经在c：\ drive上安装了Oracle 6i，在d：\ drive上安装了oracle 10g。 它是否在配置tns文件时产生问题？ 工具>首选项中的数据库部分未显示在pl / sql开发人员中。
I am using Development Oracle 10g and pl/sql 9.0.6. The problem is that everything was working fine but since when I also installed development Oracle 6i reports I can't see "tnsnames.ora" in my pl/sql developer database. I configured the same tnsnames.ora file in oracle 6i as I configured in Oracle 10g. I've Installed Oracle 6i on c:\ drive and oracle 10g on d:\ drive. Does it creat the problem in configuration of tns files? Database part in the Tools>Preferences is not showing in pl/sql developer.
最满意答案创建一个名为TNS_ADMIN的环境变量，该变量指向您要使用的tnsnames.ora文件的目录。 在自己的家中安装另一个Oracle产品通常会使用tnsnames来混淆客户端。
Create an environment variable named TNS_ADMIN that points to the directory of the tnsnames.ora file you wish to use. Installing another Oracle product with its own home can often confuse clients using tnsnames.