Re: Oracle Instance vs Oracle Database

From: PenguinDBA <spaceboy_one_at_NOSPAMHOTmail.com>
Date: Tue, 6 Mar 2001 15:24:15 +0100
Message-ID: <3aa4f32e$0$5731$4d4eb98e@news.dk.uu.net>

You don't need OPS to run several instances, when the instances are located on the same host. Ie. one OLTP instance and one DDS instance for reporting.

/penguinDBA

"Daniel Dai" <daijy_at_portal.com> skrev i en meddelelse news:97pskk$2gen$1_at_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 Tue Mar 06 2001 - 08:24:15 CST