tnsnames.ora

[new_developer]

Hi,

I currently have an Oracle Express database loaded. I want to remove it and install a net8 client (or is it net9 now?) instead. If I do so, how will PL/SQL developer know where the new tnsnames.ora is? Can you "point" to it somehow? I have never done it this way. The only way I have installed is with the tnsnames already in place and PL/SQL developer picked it up on install.

any help is greatly appreciated.

Thanks,
new_developer

 

[CTzen]

You can either select ORACLE_HOME you need in
Tools->Preferences->Connection->Oracle Home
or use command line parameter, e.g.
plsqldev.exe oraclehome=xe

 

[onerad]

I had similar problem and I solved it by removing line:
NAMES.DEFAULT_DOMAIN =
from file SQLNET.ORA
Olda