Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OEM - 9i Windows XP -
In article <40d2ddfa$0$18669$afc38c87_at_news.optusnet.com.au>, Howard J.
Rogers says...
>
> "Jeremy" <newspostings_at_hazelweb.co.uk> wrote in message
> news:MPG.1b3cd68af4adecb6989c6f_at_news.individual.net...
> >
> > I assume there is a way of editing a file and then forcing oracle to
> > read it when it starts the instance?
>
> Chapter 6 of the ebook deals with nearly every aspect of working with the
> spfile. Including how you create an init.ora from one, which is what you'll
> need to do. Basically: create pfile from spfile; and then run off to
> ORACLE_HOME\database. With an edited init.ora, you then force startup to use
> it if you like: startup pfile='c:\wherever\whatever.ora'. Or, create spfile
> from pfile, followed by just pain old startup -because if an spfile exists,
> it gets used in preference to an init.ora.
>
Thanks for taking the time to explain that - honestly I'd have been
quite happy with 'RTFeB' :)
cheers
-- jeremyReceived on Fri Jun 18 2004 - 07:43:43 CDT