Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can NT run multiple instances of Oracle7?
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
![]() |
![]() |