Configure TNSNAMES:ORA

[reignman]

I have a valid tnsnames.ora on my system, yet the newly installed plsql-developer won't use it.
How can I configure the path?

Thanks for any ideas,
rk

 

[Marco Kalter]

You can select an Oracle Home (and implicitly a tnsnames.ora file) through Tools > Preferences > Oracle / Connection. Each home can have its own tnsnames.ora file, as configured in the Oracle Registry.

 

[rbrooker]

hi,

this doesnt work as it should.

i have started a new job with far less control over my machine, which has 4 oracle homes installed. i have one application that must use an 817 client, so that is my defaut home. i have plsql developer using a 9i client, as specified in Preferences -> Oracle -> Oracle Home, but when i look at the support info, it still says version 817.

am i doing something wrong?

 

[Marco Kalter]

You have to restart PL/SQL Developer after making this change.

 

[rbrooker]

yep, i followed all instructions.

with the default oracle home set to 817, the home in plsql developer set to 9i, i end up using the 817 home even after a restart...

 

[Marco Kalter]

This would indicate that the Oracle Client library (oci.dll) from the 9i home could not be initialized.

What happens if you use the Oracle Home Selector and change your Primary Oracle Home to 9i?

 

[rbrooker]

using the oracle home selector to change to a 9i home, results in the oci library for the 9i home being used. got this from the bottom of the first support info page.

thanks.