Database vs. Instance ?

From: Leo Salminen <leo.salminen_at_ntc.nokia.com>
Date: 1998/02/25
Message-ID: <34F3FEBC.8FB@ntc.nokia.com>#1/1

All Oracle books and manuals I've read, define the concepts of database and server as following:
The server (= Instance = SID ?) consists of background processes and memory areas. Users and their objects are defined as part of database.

But "in real life" when I have multiple instances, each of them have the users and the objects of their own. In SID1 there may be a user SCOTT and in SID2 another perfectly independent user SCOTT with its own objects.

If we follow that Oracle concept, there is two SCOTT users in one database or have I misunderstood some very basic idea ?

Does anyone know, why do Oracle define users and schema objects as parts of database, not as parts of an instance ?

Received on Wed Feb 25 1998 - 00:00:00 CST