Re: One Oracle DB with Multi Instances?

From: MyTwoBits <nighr_at_hotmail.com>
Date: 2000/05/16
Message-ID: <aE3U4.65444$fF5.2263754_at_news1.rdc1.il.home.com>#1/1


Oracle Parallel server supports that configuration. But you will have to plan you application carefully to make use of it. You can have multiple instances pointing to one set of database tables. This provides protection against instance failure on one of the nodes. However, the complexity in setting it up may not make it worth it. I certainly wouldn't set up two instances on one machine.

There was an article that came out in the Oracle magazine which described the various scenarios of running fault-tolerant Oracle databases. I wish I had it handy. Depending on you needs, you might want to take a look at replication and a stand-by database. If you're worried about supporting a lot of connections into one database, consider looking at setting up Mulit-threaded server.

My25/c.

"Tiaw Wee Lim" <wltiaw_at_ecssin.com.sg> wrote in message news:38F2B977.4A3BB095_at_ecssin.com.sg...
> Dear Oracle Guys,
>
> Is it possible to setup multi instances in one oracle db(one unix box)?
 How to
> setup and what's the benefits of it?
>
> thanks for the info.
>
> Regards.
>
Received on Tue May 16 2000 - 00:00:00 CEST

Original text of this message