Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: OEM - 9i Windows XP -

Re: OEM - 9i Windows XP -

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Fri, 18 Jun 2004 13:43:43 +0100
Message-ID: <MPG.1b3cf3dd505b9efd989c70@news.individual.net>


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

-- 

jeremy
Received on Fri Jun 18 2004 - 07:43:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US