A question I keep running into is this:
In several 11Gr2 RAC databases, I would like to have just one tnsnames.ora file, and I would like to place this under the Grid Home Network Admin. I would prefer not having to maintain multiple copies of tnsnames.ora for each instance and each node as well. I find that if I have TNS_ADMIN set to this location, that for most functions this works fine, but when developers use DB LINKS in views, procedures or queries from SQL Developer and in some cases from the Oracle Scheduler, it doesn't work and they get an ORA-12154. I can resolve this by putting the tnsnames.ora file in the default location for each instance and database ($ORACLE_HOME/network/admin) but I would prefer not to handle it this way. Is there another solution that will work in all cases to have a single tnsnames.ora for each node in the RAC cluster?
Thanks!
Sandra