Re: Would you recommend having multiple instances on the same box?

"John Guthrie" <john_at_guthrie.co.za> wrote in message news:<b7luoq$1uot5$1_at_ID-156817.news.dfncis.de>...
> I know it is possible to have multiple instances running on the same box
> but:
>
> Can someone tell me if their is an official line that says Oracle does NOT
> recommend running multiple instances on the same box.
>
> AND
>
> Can someone tell me if running multiple instances on the same box is ever
> used in 'the real world'?

Used alla time.

>
> The reason for the questions above is that we have made a request to run 2
> instances on the same box and this request was denied saying that Oracle do
> not recommend running more than 1 instance on the same box and that this is
> not done in 'the real world'. (the box which we will be using is more than
> capable of handling 2 instances - spec in this case is not the issue.)

Well, there are many, many things to consider. Just off the bat, which OS? I could diss one. But more important are considerations such as backup (or it's more correct brother, restore), managerial considerations such as "don't run a development instance on a production box unless you want to be fired when something goes wrong," and technical considerations such as two particular software packages require different Oracle versions.

In the real world, this winds up translating to "we would like to have more boxes for these different things, but it's too expensive, so deal with it." Or even, shudder, "We _want_ everything to be in one instance on one box!"

On the other hand, between various clustering and parallel technologies, the limit's of "the box" may become fuzzy...

jg

--
@home.com doesn't hardly even exist.
I wandered lonely in the network cloud.