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: Mon, 14 Aug 2006 20:54:10 GMT
Message-ID: <pan.2006.08.14.20.54.11.230223@sbcglobal.net>


On Mon, 14 Aug 2006 11:54:31 -0700, NitelyJoy wrote:

> If the instance was started by pfile, you see nothing here, I'm
> afraid...

That is perfectly correct. That means that you have a homeless instance, without a job or health insurance. I start all of my instances by using spfile, so that I can institute "no instance left behind" policy".

-- 
http://www.mgogala.com
Received on Mon Aug 14 2006 - 15:54:10 CDT

Original text of this message

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