Experts

Origin's managers are recognized leaders in the industry and bring years of business consulting experience to their work.

Technological, industry, and specific application product knowledge is continually analyzed and considered when delivering our clients the most informed strategic and high impact advice possible.

Meet our principals »

#5: Where is the latest TNSNAMES.ORA file?

Posted on June 18, 2008.

If you are using query tools or other applications that rely on the tnsnames.ora file, it should normally reside in your %ORACLE_HOME%\NETWORK\ADMIN directory. However, as new environments are being created, or moved to different servers, it can be a hassle for your team to keep up with the latest tnsnames.ora file. The TNS_ADMIN environment variable offers a solution to this problem. Place the latest and greatest copy of the tnsnames.ora file on a shared folder, and have the users create a TNS_ADMIN environment variable referencing this location. From this point forward, changes to tnsnames.ora do not have to be distributed to the user community.

Select from the last three tips on the right, or go back to the complete overview of expert tips »

Last Three Tips