Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How does Oracle decide what init<sid>.ora to use?
There have been several excellent responses on what's happening but
if I were you, I would edit all of the inits on d: to be one liners:
ifile=f:\orant\database\init<sid>.ora. That way the next person
won't be burned by the same mistake.
Chris S <cschofie_at_nospam.slip.net> wrote in message
news:59p89t8mhmt7ncf57ma0cccabrk22sk4pj_at_4ax.com...
> I have an NT server running many instances of oracle (8.0.5). The
> oracle 'home' is d:\orant\, and in d:\orant\database, there are a lot
> of init<sid>.ora files.
>
> Today, I was asked to increase a paramater in the init file. I went
> into the above directory, found the init<sid>.ora file, made the
> change, bounced the instance, and ... no change.
>
> I then used the (excellent!) utility 'Filemon' to see what file was
> being read on startup, and it turned out to be
> F:\orant\database\init<sid>.ora.
>
> I edited this file, bounced the instance (stop/start services in NT),
> and my change was reflected.
>
> SO - I looked in the registry at the service definition
> OracleStart<sid>, but no location there.
>
> Later - may have answered my own question (thus posting for
> confirmation and/or benefit of others with same question!)
>
> I finally saw a file 'strt<sid>.cmd' in the d:\orant\database folder.
> This batch file had the location F:\orant\database in it. So does
> Oracle create a simple dos batch program that is used by the service
> startup?
Received on Wed Feb 28 2001 - 18:38:16 CST