Re: How many DB's can you create on one Oracle Server?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 25 Feb 2001 07:09:49 +0100
Message-ID: <u98h9t8vlacak4rmf8bdg79d0f5ghnktp4@4ax.com>

On Sat, 24 Feb 2001 16:13:53 -0800, "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote:

>> Can anyone tell me the maximum number of databases you can create on one
>> Oracle Server? Any web-based reference to this would be good.
>
>I doubt there is a hard and fast number. But I would like to have someone
>explain to me why they would want to create more than one.
>
>One instance can have multiple tablespaces and schemas for keeping
>everything separate. Why make another SGA? To what possible end?
>
>Daniel A. Morgan

Two common reasons people use it for:
1 to separate production and development and acceptance stages 2 have the OEM repository in a separate instance, to avoid the 'chicken and egg' situation you get when you have only one production database with OEM in it too: you won't be able to shutdown that database using OEM

Hth

Sybrand Bakker, Oracle DBA Received on Sun Feb 25 2001 - 00:09:49 CST