Re: Oracle 9i DB creation

"Howard Rogers" <Howard.Rogers_at_oracle.com> honoured comp.databases.oracle.server on Wed 17 Apr 2002 03:45:41a with news:4c6v8.27$tV6.254_at_news.oracle.com:

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

You will need O/S permissions to read/write the files though. Received on Wed Apr 17 2002 - 07:56:01 CDT