Best practices for generating a tnsnames.ora entry
Rather than using tnsnames, I have used openLDAP to do the names resolution.
You can replicate across two nodes if you want. As soon as you change the entry in openLDAP every server has the new information. You can even get the resolution from an ssl encrypted port if you want.
using openLDAP the name resolution