Re: Oracle Instance vs Oracle Database

From: Daniel Dai <daijy_at_portal.com>
Date: Sat, 3 Mar 2001 12:39:58 +0800
Message-ID: <97pskk$2gen$1@news.cz.js.cn>

One oracle instance can serves only one oracle database. In contrast, one oracle database can be opened by several oracle instance which means a parallel server.
The meaning of database if different in Oracle and SQL Server. A database in SQL Server is somewhat like a schema in Oracle. And one Oracle database can has several schemas.

"Charles Davis" <Stratford2000_at_home.net> wrote in message news:3AA04B5F.A5AD09BF_at_home.net...
> I have a basic question about instances and databases.
>
> Does one Oracle Instance equate to only one Oracle database?
>
> In other words, can I have separate databases running within one Oracle
> instance??
>
> I corelate this to having many separate MS SQL Server databases running
> within one SQL Server instance (service).
>
> I am a new Oracle DBA working with Oracle NT and Oracle Unix and my
> question applies to both.
>
> Can someone clarify this for me? Many thanks.
>
> Charlie
Received on Fri Mar 02 2001 - 22:39:58 CST