That's exactly what I meant!
Thanks.
HJR
"Knut Talman" <knut.talman_at_mytoys.de> wrote in message
news:3CBD743B.9A2A82AC_at_mytoys.de...
> > > If you take the second approach, don't forget that the wizard tends to
> > > create 9i database with an SPFILE as well as a PFILE. Therefore, you
> > > edit the PFILE to get the memory components smaller, but if you just
say
> > > 'startup' afterwards, nothing changes -because Oracle's using the
SPFILE
> > > to build the instance, not the freshly-edited pfile. Therefore, you
have
> > > to force startup to use the pfile by including the "pfile=" parameter,
> > > and then use the 'create spfile from pfile' command to make sure all
> > > subsequent startups use the smaller parameters.
>
> > I'm still playing with 9i but I don't think you need to start the
database to
> > issue the create spfile command. So you can edit, shutdown, convert,
> > startup.
>
> What Howard meant was:
>
> - dbca creates a database with a spfile and a pfile
> - instance starts with spfile
> - user edits pfile and restarts the database
> - user is astonished that no parameters have changed
>
> Explanation:
> - if there is a spfile the instance starts with it unless you explicitly
start
> with the command: startup using pfile=...
>
> Solution:
> - edit the pfile, start the instance with "startup using pfile=<your
pfile>",
> issue the command "create spfile from pfile"
>
> Regards,
>
> Knut
Received on Wed Apr 17 2002 - 19:01:55 CDT
