Re: Can NT run multiple instances of Oracle7?

Eddy Setiawan wrote:
>
> 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

Yes, it seems to be able to, but the design is not really very good. Oracle expects the registry to contain entries to tell it about the instance. So, you change the registry entry to switch instance. As you might expect, it is for you (and Oracle) to get confused/screwed up.

We are just beginning to play with this. However, stuff like this tells us that Oracle/NT is not really ready for a more complex production environment. We intend to use it primarily for single instance application, and then only for development.

Oracle hasn't seemed to port its useful OFA structure to NT either.

And, we've had problems with the hot backup procedure.

If you find out how to deal with this stuff effectively in NT, it would be nice to share your success with this newsgroup.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com