Re: ORACLE_HOME

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: wellmetus@xxxxxxxxx
  • Date: Tue, 19 Jan 2010 09:09:21 -0800

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

Other related posts: