Re: Getting Oracle to tell me why it's unhappy

The init.ora parameter 'ifile' stands for 'include file'. A convenient way of isolating the 'mandatory, non changeable parameters' so you can have mutiple init.ora config files and still keep the core database requirements up.

Why would you want multiple config files? Examples - change process count, change rollback segments, other things that might impact performance.

Stan Brown wrote:

> In <3AFECBFC.C7A682DF_at_more.net> Ricky Sanchez <rsanchez_at_more.net> writes:
>
> >That you wrote "one of the Oracle init files, I don't..." is somewhat
> >disturbing, suggesting a potential silly boo-boo and perhaps lack of
> >rudamentary knowledge on your part.
>
> As I said, I was at home when I replied to this, and could not access the
> system at work. I have the following files in
> /oracle_home/app/oracle/admin/pwhse/pfile:
>
> configpwhse.ora initpwhse.ora initpwhse_0.ora
>
> The name of the instance is pwhse, and both initpwhse.ora and
> initpwhse_0.ora contain the line:
>
> ifile = /oracle_home/app/oracle/admin/pwhse/pfile/configpwhse.ora
>
> Si, I believe that teh init file is initpwhse.ora which "includes" the
> contents of configpwhse.ora, correct?
  Received on Mon May 14 2001 - 20:06:20 CDT