Re: Where To Find INIT.ORA?

On Fri, 07 Mar 2003 22:28:53 +0000, Phil Hoggins wrote:

> 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.

Absolutely correct. But the original poster was asking if there is a way to tell from within the database which pfile had been used to start the instance -and as you yourself point out, it is perfectly possible to have several, and to specify a particular one at startup time.

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

Not so, unfortunately. In 9i, there's one for SPFILE, but there's no equivalent for the PFILE. And there isn't one in 8i either.

Regards
HJR
>
> 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