Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to configure single tnsnames.ora file for RAC

sidneysFeb 25 2014 — edited Feb 26 2014

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 26 2014
Added on Feb 25 2014
1 comment
820 views