Re: Oracle 9i DB creation

> > 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 - 08:10:19 CDT