Re: Instance vs. Database

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: 1997/01/03
Message-ID: <32cd83bb.1402316@newshost.us.oracle.com>#1/1

An instance is started (memory is allocated and background processes are started) and then a database (datafiles) is mounted by the instance.

There are configurations (in a clustered environment) where more than one instance may have the same database open, but the same instance can have no more than one database opened and mounted.

On Fri, 03 Jan 1997 13:49:23 -0800, Mirwais Qader <mq_at_wohl.slh.wisc.edu> wrote:

>Stupid question:
>
>Is an instance the same thing as a database?
>OR
>Can an instance contain MANY databases?
>
>I read in some book that the database name should
>correspond to the instance <sid> name so that there
>is no confusion. This would mean a one-to-one
>relationship.
>
>Thanks in advance!

Joel

Joel R. Kallman            See Oracle technology in action!
Oracle Government          http://govt.us.oracle.com

Bethesda, MD
jkallman_at_us.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Fri Jan 03 1997 - 00:00:00 CST