Re: FInd Oracle_Home using SQL

From: eugenep <eugene_at_mail.gsfc.state.ga.us>
Date: 2 Oct 2002 08:04:25 -0700
Message-ID: <f57221ec.0210020704.4eea5364@posting.google.com>

>
> I need a way to find the value of $ORACLE_HOME on a remote
> database/server using sql or plsql. I have looked at every sys $ table
> and cannot find any table with the actual location of $ORACLE_HOME.
>
> Is there any way to create a procedure/function that will shell out on
> the server and record the value of $ORACLE_HOME to variable that can
> be retrived using a query, procedure or function.
>
> Any hints would be appreciated.

This may be a good place to start: http://osi.oracle.com/~tkyte/plex/

We have been using the PLEX product here for years to execute HP-UX commands from our Windows-based applications.

Regards,

Eugene Pokopac (Oracle DBA - Tucker, GA) Received on Wed Oct 02 2002 - 10:04:25 CDT