Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out concrete ORACLE_HOME via SQL?
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.comReceived on Mon Aug 14 2006 - 15:54:10 CDT