Re: Retrieve ORACLE_HOME setting from PL/SQL

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Mon, 25 Oct 2004 13:51:40 GMT
Message-ID: <Xns958D45CD1D7B8SunnySD@68.6.19.6>

Stephan Bressler <sbresslerx_no_spam_at_arcor.de> wrote in news:clish7$j50$1_at_news.mch.sbs.de:

>

>> Maybe you'd care to elaborate why you'd want to do that? I'm having a
>> hard time figuring out what good it'd do you.

> Hi,
> we're running hundreds of oracle instances of various versions and
> platform. To keep track of the versions, settings, etc. we've
> developed a pl/sql package, which runs on each instance an collects a
> bunch of data (e.g. version, datafile usage, downtimes, etc).
> Now we'd like to collect the actual ORACLE_HOME, too.
>
> Oratab is not really an option for we have a lot of instances on
> windows. Beside that, utl_file_dir would required a change on every
> singel instance plus a reboot.
>
> Therefor I'd prefer that is accessible within the instance, a view,
> (hidden) parameter, etc.
>
> I hope this information is sufficient.
>
> Stephan
>

query V$INSTANCE or V$DATABASE Received on Mon Oct 25 2004 - 08:51:40 CDT