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

Simple. Your ORACLE_HOME points to F not D drive. This ORACLE_HOME setting is in registry and can be overruled by DOS command: set oracle_home=f:\orant

Yong Huang
yhuang_at_indigopool.com

Chris S <cschofie_at_nospam.home.com> wrote in message news:3a974d88.1240007025_at_192.168.0.10...
> Thanks - I do have a question still.
>
> This box has about 10 different instances (SIDs) on it. All 10
> instances have a corresponding init<sid>.ora file in
> D:\orant\database\. However, as I mentioned below, changes made to
> the init<sid>.ora file in this directory did not have any effect, and
> after snooping around, I found that there was an identically named
> 'init<sid>.ora' file on the "F:" drive, and when I made changes there,
> the changes took effect.
>
> So my question is - when I reboot the server, and all the Oracle
> instaces startup, what tells Oracle to use the init file on the F:
> drive in this case, rather than the more obvious d:\orant\database
> version (d:\orant is the 'oracle home')? The only specific reference
> to the F: drive version of the init file was in the strt<sid>.cmd
> file, which you say is optional.
>
> Thanks for the tip on bouncing the instance; I will start using oradim
> now!
>
> Thanks, Chris
>
> On Thu, 22 Feb 2001 01:39:06 GMT, "Dave Haas"
> <davidh_at_--nospam--hotmail.com> wrote:
>
> >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?
> >
>
> ===========
> Remove 'nospam' from email to reply - Thanks
Received on Thu Feb 22 2001 - 14:25:21 CST