Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can NT run multiple instances of Oracle7?

Re: Can NT run multiple instances of Oracle7?

From: Vittorio Turchetti <vturchetti_at_infostrada.olivetti.it>
Date: 1996/12/13
Message-ID: <01bbe8df$0c3bfe70$22581ba1@dbsi>#1/1

Sure it can!
You have to create another set of services via the ORADIM (a.k.a. Instance Manager) command.
When you use ORADIM you have to create a new initXXX.ora file choosing a new SID.
For example, to create a TEST instance with the char mode interface (in a DOS prompt window):
oradim73 -new -sid TEST -intpwd MYPWD -startmode auto -pfile initTEST.ora This will create the services, not the database, so you have to create it via standard SQL commands.
This is the best choice to fully customise your new DB. P.S.: remember to reconfigure the listener so as to service the new instance too.
Bye
VT

Eddy Setiawan <setiawan_at_merlion.singnet.com.sg> wrote in article <58qjo9$fk8_at_lantana.singnet.com.sg>...
> Hi,
>
> Can Windows NT run multiple instances of Oracle? That is I want to have
> more than one database running on the same NT server. Something like
> Development and Test databases to be in the same server.
>
> I've done this with Unix, which is just a seperate processes for each
> database. But I'm not very sure with NT. Can some one shed some light
> here. I would like to test this myself, but haven't got the needed
 resources.
>
> Thanks in advanced.
>
> Eddy
>
  Received on Fri Dec 13 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US