Re: oradim

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 06 Feb 2004 10:09:58 +0100
Message-ID: <bvvl1i$3el$1@news4.tilbu1.nb.home.nl>

Chuck wrote:
> ilaletin_at_usa.net (Igor Laletin) wrote in
> news:f9226414.0402032105.122e6e16_at_posting.google.com:
>
>

>>Chuck <chuckh_nospam_at_softhome.net> wrote in message
>>news:<Xns94805C12D6AABchuckhsofthomenet_at_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

Received on Fri Feb 06 2004 - 03:09:58 CST