Re: Running two databases on one server

From: <alcyone82_at_hotmail.com>
Date: Wed, 17 Feb 1999 19:59:19 GMT
Message-ID: <7af72g$ja1$1@nnrp1.dejanews.com>

There is really no problem with running multiple Oracle instances on one box. They'll have separate init.ora files, different ORACLE_SID values, etc. A while ago I was involved with a project where we were running four instances on a single-processor RS/6000 (stupid architecture, but that's besides the point).

You don't *need* SMP to run multiple instances, but it will sure help. Just make sure you have enough RAM to handle both instances' SGAs.

Personally, I'm not a big fan of multiple instances on one box. I'd rather see them kept on separate boxes. It's an 'all your eggs in one basket' thing.

-Dave
DB Development Consultant

In article <36C9EB3C.1020B17D_at_domain.com>, default <defaultuser_at_domain.com> wrote:
>
> We currently have two Oracle database running on two servers and intend
> to upgrade the servers to one server with multiple processors. Has
> anyone had
> any problems running two databases on the same server? Any advice or
> do's and
> don'ts? Thanks.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 17 1999 - 13:59:19 CST