Re: Can I create two DB instance in one NT 4.0 box

U95NKM wrote:
>
> Hi,
>
> I am very new in Oracle, please forget my about some fundmental
> question.
>
> I would like to create two database in Oracle 7, one is called
> personnel and another is called sales, but I cannot find any way to do
> this. When I create the other instance, the other will be stopped
> automatically or vice versa.
>
> I would like to know is there any way to create two separately
> instance in Oracle 7 and 8 as I will migrate to v.8 very soon.
>
> Thank you for your attention
>
> Kevin

It is done all the time.
The only issue is when to start the instances. Generally, you use the services of NT to start the database. I am aware there is a tool that allows you to setup if the database/instances are started automatically or manually. Each instance can have a different or same setting.

I presume that you used different control files and database instance names and different table spaces.....

You could of course create two different roles in the same database -- each with their own set of tables. If they share any data or they are small, this may be the simpler way.

Mike Krolewski mikkro_at_hbsi.com Received on Mon Dec 01 1997 - 00:00:00 CET