is there a way to use single file instead of multiple TNS name files

[denevge]

If the problem is that you have multiple ORACLE_HOME's and you just want to use 1 tnsnames.ora file.

I think you can define the variable TNS_ADMIN= ( not sure, so sorry if wrong )

Hope this helps
Gert