Re: Multiple Oracle Instances on NT

Copy the initorcl.ora file and gave it the proper name for the new instance, eg initprod.ora.
Run oradim73 to create a new instance:
oradim73 -new -sid PROD -usrpwd xxx -startmode auto -pfile c:\orant\database\initprod.ora

create a .cmd file to run server manager and set the oracle_sid environment variable:
set oracle_sid=PROD
svrmgr23.exe

now you can connect internal and start building a database

don't forget to configure the listener and tnsnames.ora

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
Vincent Birlouez wrote in message <354700A9.B83E5082_at_logica.com>...


>How do you manage to run more than 2 Oracle 7.3 instances at the same time

 on a


>NT4.0 server ?

>

>Thanks !!!

>

>JRStern wrote:

>

>> On Sun, 26 Apr 1998 12:15:20 -0600, RJLTitus_at_msn.com wrote:

>> >I'm looking for feedback from anyone who has multiple Oracle instances

>> >running on NT 4.0. Specifically, I'd like information on how many

 instances,


>> >the version(s) of Oracle, size of the databases, number of users, and

 the NT


>> >configuration -- number of processors, RAM, etc.

>>

>> We have three instances running on a Dell server with 128mb RAM, but

>> they're only very lightly used for development.

>>

>> And the only reason we have three instances, is a belief about which I

>> am quite uncertain, that this is necessary and/or desirable to best

>> support three development projects -- to avoid conflict over global

>> synonyms.

>>

>> Joshua Stern

>> JRStern_at_gte.net

>

>

>