Multiple locations of tnsnames.ora

[jlt]

Hi,

We are experimenting PL/SQL Developer on a workstation with multiples tnsnames.ora which are not included in our ORACLE_HOME directorie.

Unfortunately, that doesn't seem to work correctly : we don't manage to logon.

Can you tell me if it is possible to specify the location of our tnsnames.ora file within PL/SQL Developer (this location is set with the TNS_ADMIN environment variable and we manage to logon directly with SQL+) ?

Thanks for your assistance.

 

[Marco Kalter]

PL/SQL Developer uses the Primary Oracle Home by default. The Oracle Net installation within the Primary Oracle Home dictates which databases can be used, in accordance with the TNSNAMES.ORA file.

If you want to use a different Oracle Home, start PL/SQL Developer without connecting, go to Tools > Preferences > Oracle/Connection, and select the corresponding entry from the Oracle Home selection list. Restart PL/SQL Developer to make this change effective.

 

[jlt]

Thanks for your help.

 

[D.]

Is there any way to reload the tnsnames.ora without restarting PL/SQL Developer ? This would be a nice feature. Is this an enhancement request ?

I frequently change the tnsnames.ora file as we have around 300+ databases available to connect to. These databases change name often and it's a pain having to save off all your open windows just to make a new connection. I use the "New Instance" feature, but it doesn't reload all my open windows (which haven't been saved off).

D.

 

[Marco Kalter]

Even if the database list in the Logon dialog is not refreshed, you can still connect to the databases that were added.