Re: How to find out concrete ORACLE_HOME via SQL?

"Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message news:pan.2006.08.13.23.29.04.865393_at_sbcglobal.net...
> On Sun, 13 Aug 2006 23:13:56 +0000, Bob Jones wrote:
>
>> That works only if the spfile at default location is used.
>
> Yes, of course. In 99% of the cases you will get the correct result,
> though. In case of some RAC instances, you'll find spfile on raw devices.
> Oracle instance doesn't record ORACLE_HOME in any of the virtual tables
> that I know of. It is likely that this trick will help, but it is not
> guaranteed.
>
> --
> http://www.mgogala.com
>

Actually it is quite common for the spfile to be placed outside of $ORACLE_HOME directory, such as /u01/admin. Received on Sun Aug 13 2006 - 19:18:54 CDT