Re: ORACLE_HOME

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 19 Jan 2010 09:09:21 -0800
Message-ID: <bf46381001190909h15636203o14457e97c0c78041_at_mail.gmail.com>

On Mon, Jan 18, 2010 at 2:03 PM, Roger Xu <wellmetus_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 19 2010 - 11:09:21 CST