Re: Databases and Instances

Fuzzy <granta_at_nospam.student.canberra.edu.au> wrote in message news:38e3e2ac.8908680_at_newshost.interact.net.au...
> On Thu, 30 Mar 2000 22:11:00 +0200, Stefan Jahnke
> <q5665841_at_bonsai.fernuni-hagen.de> wrote:
>
> >Hi,
> >
> >I wonder wether it is possible to create one instances, but multiple
> >databases that are accessed via the one instance (on the same server)
> >like it is possible to do with DB2. As I understood, you make an entry
> >in the oratab-file to have a new instance, then connect with svrmgrl as
> >internal to that instance, start it (what actually means, there is a
> >seperated bunch of oracle processes per instance with an SGA). But there
> >is only one DB that can be mounted and opened per instance. The only
> >thing I found is the parrallel server option, but this is the other way
> >around: multiple instances accessing the same database. So, is it
> >possible to have one instance accessing mounting and opening multiple
> >databases ? Perhaps via init-file entries ? I don't want just database
> >links.
> >
> >TIA
> >Stefan
>
> No, Oracle is way behind the times on this. Informix and DB2 give you
> multiple databases (with multiple schemas therein) per instance, and
> Sybase and SQL Server give multiple databases per instance. Only
> Oracle is still stuck in the mud on this one ... and their
> architecture won't be easily changed to keep up with the others.
>
> Ciao
> Fuzzy
> :-)

Wow, what a wisdom on your side.
This architecture has been working for more than 20 years, and you call that stuck in the mud.
Maybe you should tell Larry!
But of course he'll never introduce the sql-server crap in Oracle.

Regards,

Sybrand Bakker, Oracle DBA Received on Fri Mar 31 2000 - 00:00:00 CST