| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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?
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?
>
 |
 |