在Oracle SQL Developer中使用tnsnames.ora [英] Use tnsnames.ora in Oracle SQL Developer

问题描述

我正在评估 Oracle SQL Developer .

已填充我的tnsnames.ora，并且对tnsnames.ora中定义的连接的tnsping正常工作.不过，SQL Developer不会显示任何连接.

My tnsnames.ora is populated, and a tnsping to a connection defined in tnsnames.ora works fine. Still, SQL Developer does not display any connections.

Oracle SQL Developer Soars 提到，如果

您已经在计算机上安装了Oracle客户端软件和tnsnames.ora文件，Oracle SQL Developer将自动从tnsnames.ora中定义的网络服务名称填充Connections导航器.

you have Oracle client software and a tnsnames.ora file already installed on your machine, Oracle SQL Developer will automatically populate the Connections navigator from the net service names defined in tnsnames.ora.

我还尝试设置我的TNS_ADMIN环境变量，但是在重新启动SQL Developer之后，仍然没有显示连接.

I also tried to set my TNS_ADMIN environment variable, but after restarting SQL Developer there are still no connections displayed.

有什么想法吗?
有人成功使用SQL Developer和tnsnames.ora吗?

Any ideas?
Anyone successfully working with SQL Developer and tnsnames.ora?

推荐答案

• 在 SQLDeveloper 中，浏览 Tools --> Preferences ，如下图所示.
  
  
  
  
• 在首选项选项 expand Database --> select Advanced --> under "Tnsnames Directory" --> Browse the directory 中，其中存在 tnsnames.ora .
  
• 然后单击确定， 如下图所示.
  tnsnames.ora 可从 Drive:\oracle\product\10x.x.x\client_x\NETWORK\ADMIN
  
  获得
• In SQLDeveloper browse Tools --> Preferences, as shown in below image.
  
  
  
  
• In the Preferences options expand Database --> select Advanced --> under "Tnsnames Directory" --> Browse the directory where tnsnames.ora present.
  
• Then click on Ok, as shown in below diagram.
  tnsnames.ora available at Drive:\oracle\product\10x.x.x\client_x\NETWORK\ADMIN
  
  

现在，您可以通过 TNSnames 选项进行连接.

Now you can connect via the TNSnames options.

这篇关于在Oracle SQL Developer中使用tnsnames.ora的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！