PLSQL Developer will not see my tnsnames file

[XJF0101]

I've installed the Oracle 64bit 11g client, and then installed PL/SQL Developer in C:/PLSQL Developer folder (not in the C:/Program Files (x86) folder). Several tnspings prove that the alias connections are good. The Oracle_Home directory is correct in the registry, and I set it in PL/SQL Developer Options menu as well.
The software still cannot see the tnsnames file. There has got to be a simple way to set this path....

Please help.

 

[Marco Kalter]

Can you start PL/SQL Developer without connecting, go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[Stian]

Have I missed 64bit support in PSD?

I do not believe you can use 64bit Oracle client with PL/SQL Developer. You need the 32bit client.

Stian

 

[XJF0101]

Thank you Stian,

I believe you are correct. I uninstalled the 64bit Oracle 11g client, and reinstalled the 32bit client. Then I reinstalled PL/SQL Developer outside the "Program Files (x86)" directory. Now, Developer sees the tnsnames file and connects to the external databases with no problem.
Case closed...thanks.

 

[ItGeek]

Hello,
I am having a similar problem and was wondering how you got oracle 32 bit client to install on a windows 64 bit system?
Im using 64 bit windows 7 enterprise edition. I had previously installed oracle client 64 bit and was able to tnsping or sqlplus into my databases without any issue, but have not been able to get pl/sql to work when I ran into this post that you have to use the 32 bit client. I have uninstalled oracle 11g 64 bit client and have tried several 32 bit clients with no luck in getting it to install. The current release is 11gR2 32bit for windows and it fails halfway though the install. Is there some tirck you could share with me to get it to sucesfully install?

 

[ItGeek]

Hello,

Ok, so I gave up on the 11g client went to a 10g 32 bit client and sucesfully got it to install. TNSping works sucesfully as does sqlplus. I uninstalled PL/SQL and reinstalled it in Program Files (Previously it was in the x86 dir). It now reads my TNS names sucesfully but gives me a blank error when ever I try to log in.

Any ideas?

 

[ItGeek]

OK, Figured out my last problem by reading another post (I guess I should appologize for posting before reading all posts) but I found out PSD tries to right to program files directly and needs to be run as administrator on win 7. This resolved all problems.

Thanks

 

[juanian]

One other note: If the tnsnames.ora file has multiple entries with the same TNS name, the list may not display in the Database dropdown (at least that is what I have seen with version 7.1.5.1398)