Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out concrete ORACLE_HOME via SQL?

Re: How to find out concrete ORACLE_HOME via SQL?

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sun, 13 Aug 2006 23:29:05 GMT
Message-Id: <pan.2006.08.13.23.29.04.865393@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


Received on Sun Aug 13 2006 - 18:29:05 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US