Re: Where To Find INIT.ORA?

From: Phil Hoggins <phil_hoggins_at_spamyahoo.co.uk>
Date: Fri, 07 Mar 2003 22:28:53 +0000
Message-ID: <3E691D25.3060707@spamyahoo.co.uk>

I'm a little rusty these days but it starts up withh an init<SID>.ora found in the ORACLE_HOME/dbs directory unless a pfile is explicently specified at startup.

not 100% sure but I think if you query the V$PARAMETERS table one of the entries is for pfile

Phil

Howard J. Rogers wrote:

> On Fri, 07 Mar 2003 21:50:07 +0000, Carl Sawyer wrote:
> 
> 

>>Hi All,
>>
>>Does 8i offer a way to query the running instance for the location of
>>the INIT.ORA file that was used to start the instance? I searched the
>>Google archives and found one question (from 2000) to this effect but
>>no one seemed to know.
>>
>>Any Ideas?
>>
>>Thanks Already!
>>Carl S.

> 
> 
> Short answer: no.
> 
> Regards
> HJR

Received on Fri Mar 07 2003 - 16:28:53 CST