Re: Multiple database in one instance

Howard is absolutely correct. Everyone needs to remember this is an Oracle newsgroup. I work with multiple DBMS products and I need to be aware that the terminology can change for each one. In this newsgroup everyone should use the Oracle definition of a database.

Big Al

"Howard J. Rogers" wrote:
>
> "David Grzebien" <dgrzebie_at_columbus.rr.com> wrote in message
> news:39A1E049.F7FFBA0E_at_columbus.rr.com...
> > Let's define what a database is and an instance.
> >
> > A database is a collection of related data.
> > An instance (in Oracle) are the background process that run Oracle (ie.
> > SMON, PMON, etc).
> >
> > With this in mind, it is possible to create many databases in one
> instance.
>
> With regret, entirely untrue.
>
> An Instance is a structure in memory that manages a database. It comprises
> the SGA and the Background processes. You will have one SMON, and one PMON,
> per database. Without exception.
>
> A Database is composed of Control Files, Data Files, and Redo Logs.
>
> It is a cast iron rule in Oracle that an Instance can manage precisely one,
> and only one, database -and that rule applies whether you dabble in exotic
> configurations such as MTS or Parallel Server, or not.
>
> You are about as wrong as it is possible to be, though perhaps this is
> because of unfamiliarity with Oracle terminology.
>
> > I would probably create them in separate schemas as well.
> >
>
> And a schema means something entirely different in Oracle (in Oracle, it
> means the collection of objects created by a User).
>
> Regards
> HJR
>
> > Dave
> > dave_at_etci.net
> >
> > woods_john_at_crane.navy.mil wrote:
> >
> > > Is it possible to have more than one database per instance. If so, how?
> > >
> > > Thanks,
> > >
> > > John Woods
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
Received on Tue Aug 22 2000 - 16:50:24 CDT