Nikko,
If you have only one server and want to run a developer version, a qa test
version, and a production version of the database on the same machine you
can set up thre different instances on the same machine. Or if you want to
seperate your applications based on their charactistics (say, OLTP and DSS)
you can put them on different instances so that you can set the parameters
differently (in initsid.ora and configsid.ora).
You can exchange data among the instance through database link or
replication.
nikko <nikko_at_po.jaring.my> wrote in message
news:37188C28.FB1B4AA_at_po.jaring.my...
> Why and when do one use multiple instances in Oracle ? Can two different
> instance communicate(exchange data?)
>
> Thank you.
>
Received on Sat Apr 17 1999 - 12:22:31 CDT
