Re: Retrieve ORACLE_HOME setting from PL/SQL

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Mon, 25 Oct 2004 16:08:50 +0200
Message-ID: <clj1dj$fu7$1@news.BelWue.DE>

Stephan Bressler wrote:
>

>> 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

I assume that you don't have OEM in place? In that case SMP_VIEW_TARGET_PROPERTIES could help you:

select target_name, value
from SMP_VIEW_TARGET_PROPERTIES
WHERE name = 'oracle_home';

Sorry, but that's all I can offer.

Holger Received on Mon Oct 25 2004 - 09:08:50 CDT