| 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?
Sorry, but it isn't - my oracle_home is d:\orant, and the other 9 instances on the server are reading the init<sid>.ora files in the folder d:\orant\database. On the F: drive, there is only one init<sid>.ora file, and that is for the one SID I was working on. So 9 are in the default, oracle_home, location, and one isn't, and I'm trying to figure out how Oracle knows how to find just this one file. I searched the registry for a reference to f:\orant\database, and none existed. So I'm still stumped.
On Thu, 22 Feb 2001 14:25:21 -0600, "Yong Huang" <yhuang_at_indigopool.com> wrote:
>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
>
 |
 |