Re: How does Oracle decide what init<sid>.ora to use?

Hi Chris.

A couple of things:

1. The sid is governed by the environment_variable ORACLE_SID (settable in many places). The easiest place to set it is:

RightClick->MyComputer, Select Properties Page->Environment Tab, Set it in the bottom box.

2. Don't shut a database down by stopping the service. That's BAD. It's effectively a shutdown abort (unless the proper registry setting has been applied, which changes with every release). After you shut down like that, you might as well bounce the box because the memory that Oracle was using is NOT properly released back to the OS.

3. It's the Database Creation Assistant that creates those batch files. If you create a database manually, you have to do it yourself (if you want to, it's not required).

HTH Dave Haas

"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 21 2001 - 19:39:06 CST