4 Replies Latest reply: Sep 24, 2013 4:55 AM by user582451 RSS

    SQL Developer can't see tnsnames.ora

    756660
      Hiya. I hope someone can help with this. I installed Oracle instant client (basic lite) on my new Windows 7 machine (32 bit) - yeah, I know Windows 7 is not supported, but my gut feeling is that this isn't the issue I'm having.

      I've put my tnsnames.ora file in the same folder as instant client (C:\program files\oracle\instantclient), have created a system environment variable TNS_ADMIN which points to that folder, and have added that folder to the system "path" environment variable. That should do it, right?

      When I try to create a new connection in SQL Developer 2.1.0.63, and change my connection type to "tns", I don't see any database connections.

      Troubleshooting ideas? Other ways to test that the needed Oracle files are installed properly?

      Thanks!