> Doesn't running a command prompt and issuing SET ORACLE_HOME=<HOMENAME>
> before using oradim to create the service have the desired results?

Maybe it doesn't, as unless you are in %ORACLE_HOME%\bin, the oradim
that will be used will be the one found first in your PATH, which may,
or may not, be from the proper %ORACLE_HOME%.

HTH,
Brian


--
================================================== =================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

hence my second suggestion...

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Brian Peasland" <dba@remove_spam.peasland.com> wrote in message
news:4022732B.76BF7BB8@remove_spam.peasland.com...
> > Doesn't running a command prompt and issuing SET ORACLE_HOME=<HOMENAME>
> > before using oradim to create the service have the desired results?
>
> Maybe it doesn't, as unless you are in %ORACLE_HOME%\bin, the oradim
> that will be used will be the one found first in your PATH, which may,
> or may not, be from the proper %ORACLE_HOME%.
>
> HTH,
> Brian
>
>
> --
> ================================================== =================
>
> Brian Peasland
> dba@remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"

Chuck wrote:
>
> ilaletin@usa.net (Igor Laletin) wrote in
> news:f9226414.0402032105.122e6e16@posting.google.c om:
>
> > Chuck <chuckh_nospam@softhome.net> wrote in message
> > news:<Xns94805C12D6AABchuckhsofthomenet@130.133.1. 4>... ...
> >> The only references to oradim in the 8i docs are in 8i the Migration
> >> Guide pages 4-15, 7-16, and 13-5.
> >
> > Try "Oracle8i Administrator's Guide for Windows NT" -> Chapter 6
> > "Post-Installation Database Creation" -> "Using ORADIM to Administer
> > an Oracle Instance".
> >
> > Regards,
> > Igor
> >
>
> Been there, read that. There is nothing in this manual (or any other
> Oracle manual that I've found) that explains how to get oradim to specify
> which oracle home to use to start an instance with. Keep in mind that the
> goal here is to have two services, each starting an instance using a
> different oracle home (i.e. a different set of executables), each at a
> different patch level of 8.1.7.4.
> --

I believe your question is answered in Chapter 3, which discusses
Multiple Home, specifically the section about "Changing the value of
your Path", followed by the reference above to Chapter 6.

Once all of that is absorbed, the final step is to reread the Chapter 3
parts about "Setting variables in Environment" to get your final answer.

Admittedly this is not straight forward and requires some thinking,
reflection and logic. For example, you have to realize that oradim is
an executable, and that you want to match the executable to a patch
level, and that the PATH determines which executable will be run. (But
I'm sure you knew that.) However, the doc does explicitly state that
the ORACLE_HOME being used matches the PATH to the executable - the
reference is:

http://download-east.oracle.com/docs...17EE/index.htm
> Chapter 3
> Section "Setting Variables in the Environment or the Registry"
> Subsection "ORACLE_HOME"
> List element 2, which starts with

"For example, if you run C:\ORACLE\ORA81\BIN\SQLPLUS.EXE, SQLPLUS.EXE
looks in C:\ORACLE\ORA81\BIN\ORACLE.KEY to find out where to look for
its registry variables."


I suspect the final answer is pretty simple - set PATH before running
ORADIM.exe to make sure you get the ORADIM that matches the patch (just
in case ORADIM itself was updated by the patch).

/Hans

Daniel Morgan <damorgan@x.washington.edu> wrote in
news:1075997381.189583@yasure:

> Chuck wrote:
>
>> Been there, read that. There is nothing in this manual (or any other
>> Oracle manual that I've found) that explains how to get oradim to
>> specify which oracle home to use to start an instance with. Keep in
>> mind that the goal here is to have two services, each starting an
>> instance using a different oracle home (i.e. a different set of
>> executables), each at a different patch level of 8.1.7.4.
>
> With oradim you specify the PFILE ... the init.ora. You also have
> values for ORACLE_HOME and ORACLE_SID set in the environment.
>
> That is all the information required.
>

That is all the information that is required *if* there is only one
instance. I am trying to create two services that start two instances
automatically, but each using a different home. I want these two
instances to start up whenever the server is rebooted. From what I am
reading, it does not appear that oradim can handle that on it's own.

In essence I want to be able to the same thing on Windows that dbstart
does on Unix - the ability to specify for each instance, what home to use
when it starts up.
--
Chuck
Remove "_nospam" to reply by email

Chuck wrote:
>
> Daniel Morgan <damorgan@x.washington.edu> wrote in
> news:1075997381.189583@yasure:
>
> > Chuck wrote:
> >
> >> Been there, read that. There is nothing in this manual (or any other
> >> Oracle manual that I've found) that explains how to get oradim to
> >> specify which oracle home to use to start an instance with. Keep in
> >> mind that the goal here is to have two services, each starting an
> >> instance using a different oracle home (i.e. a different set of
> >> executables), each at a different patch level of 8.1.7.4.
> >
> > With oradim you specify the PFILE ... the init.ora. You also have
> > values for ORACLE_HOME and ORACLE_SID set in the environment.
> >
> > That is all the information required.
> >
>
> That is all the information that is required *if* there is only one
> instance. I am trying to create two services that start two instances
> automatically, but each using a different home. I want these two
> instances to start up whenever the server is rebooted. From what I am
> reading, it does not appear that oradim can handle that on it's own.
>
> In essence I want to be able to the same thing on Windows that dbstart
> does on Unix - the ability to specify for each instance, what home to use
> when it starts up.
> --
> Chuck
> Remove "_nospam" to reply by email

See my reply - it references the docco sections that should clear up the
confusion. If not email me at forbrich at telusplanet dot net

Quick summary - use absolute path referencing to the oradim and that
will automatically determine the appropriate home.

/Hans

Chuck wrote:
> ilaletin@usa.net (Igor Laletin) wrote in
> news:f9226414.0402032105.122e6e16@posting.google.c om:
>
>
>>Chuck <chuckh_nospam@softhome.net> wrote in message
>>news:<Xns94805C12D6AABchuckhsofthomenet@130.133. 1.4>... ...
>>
>>>The only references to oradim in the 8i docs are in 8i the Migration
>>>Guide pages 4-15, 7-16, and 13-5.
>>
>>Try "Oracle8i Administrator's Guide for Windows NT" -> Chapter 6
>>"Post-Installation Database Creation" -> "Using ORADIM to Administer
>>an Oracle Instance".
>>
>>Regards,
>>Igor
>>
>
>
> Been there, read that. There is nothing in this manual (or any other
> Oracle manual that I've found) that explains how to get oradim to specify
> which oracle home to use to start an instance with. Keep in mind that the
> goal here is to have two services, each starting an instance using a
> different oracle home (i.e. a different set of executables), each at a
> different patch level of 8.1.7.4.

Peeking in the registry, there's an entry RDBMS_CONTROL.
Adding a dummy TEST1 instance results in:
Path starts with PATH=D:\oracle\ora92\bin;
Command used:
D:\>oradim -new -sid test1 -startmode a -pfile
d:\oracle\admin\test1\init.ora

D:\oracle\ora92\database\oradim.log shows:
Fri Feb 06 09:54:28 2004
ORA-01078: failure in processing system parameters

Fri Feb 06 09:54:30 2004
Instance created.

In the registry, it's under HOME0 (which has D:\oracle\ora92\ as OH).

I also have a 817 OH, let's see:
D:\>D:\oracle\817\bin\oradim -new -sid test2 -startmode a -pfile
D:\oracle\admin\test2\init.ora

In the registry, this ends up in HOME6 (which is the home, that
D:\oracle\817\bin\oradim belongs to: D:\oracle\817\)
Surprisingly, there's also an entry ORA_test2_PFILE; this
did not appear with the 9.2 oradim.

D:\oracle\817\database\oradim.log:
Fri Feb 06 10:02:08 2004
Message 51 not found; product=RDBMS; facility=ORADIM

Fri Feb 06 10:02:09 2004
ORA-01078: failure in processing system parameters

In both cases, the services were created.

So, using the correct oradim ensures which OH is used.
I did not have ORACLE_HOME set during this simple test.
--

Regards,
Frank van Bortel