On Mon, Jan 18, 2010 at 2:03 PM, Roger Xu <wellmetus@xxxxxxxxx> wrote: > In my case below, I just want to know which tnsnames.ora file I am using. > There are many tnsnames.ora files in this server and I was able to try each > to figure out the one I am using. But this is not the right way to get the > answer ... (I feel home when running Oracle in UNIX :) > > I often use this tool for when using multiple Oracle homes on a Windows server. http://www.dbmotive.com/ole/ole.php It is particularly useful as Oracle no longer supplies such a utility. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com