Re: One or more Databases

Many thanks for taking the time to clarify this it is greatly appreciated

Regards,
Harry

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:ttqtqj4ulm7654_at_corp.supernews.com...
>
> No, that's not what I was saying.
> I was saying:
> if you have a production/test/development version of your applications
> you might want to have a production instance for the production version of
> all your applications, a test instance for the test version of all your
> applications and a development for the development version of all your
> applications
>
> Depending on the size and the number of concurrent users, these three
> databases can reside on one server or on more than one server.
>
> However, typically you also need one Oracle instance for maintenance
> purposes, containing the OEM repository, the RMAN catalog and so on.
>
> As to your last remark: at least you are asking.
> Many of your colleagues just go ahead creating numerous 'databases'
>
> Hth,
>
> Sybrand Bakker
> Senior Oracle DBA
>
>
>
>
> "harry informed-direct.com>" <harry.parkinson@<nospam> wrote in message
> news:3bdd6a64$0$227$ed9e5944_at_reading.news.pipex.net...
> > So a production server would typically run a different database for each
> > application say accounts, inventory, helpdesk etc (if they were
developed
> > separately).
> >
> > If the management server was also installed on the same machine would it
> > also utilise a dedicated database?
> >
> > Apologies for the basic questions! I am just trying to make sure that I
> > don't start on the wrong note.
> >
> > Regards,
> > Harry
> >
> >
> > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > news:ttqijetkseph0b_at_corp.supernews.com...
> > >
> > > "harry" <harry_at_home.com> wrote in message
> > > news:3bdd2648$0$232$ed9e5944_at_reading.news.pipex.net...
> > > > Hi,
> > > >
> > > > I am new to the world of Oracle though have experience of developing
> for
> > > > MSSQL. I am wondering what the preferred method of segregating data
> for
> > > > different systems, apps etc is.
> > > >
> > > > Under MSSQL I would normally have different databases for different
> > > > applications or testing etc. Oracle, from what I can gather normally
> has
> > > one
> > > > instance running due to the overhead? Therefore I presume you would
> > > > segregate data using different schemas?
> > > >
> > > > Is it typical to create more than one database but only run one at a
> > time?
> > > > Any tips or pointers would be gladly appreciated.
> > > >
> > > > Regards,
> > > > Harry
> > > >
> > > >
> > >
> > > In Oracle 1 application is preferably one schema, multiple schemas in
> > *one*
> > > database. This also reduces the need for distributed features.
> > > As Oracle is around since 1979, it implemented the methodology
> conceptual
> > > database, logical database physical database.
> > > In that era one typically created one database for a complete company,
> to
> > > share as much data as possible. Creating different databases will make
> the
> > > sharing much more difficult (there is no such thing as remote
integrity
> > > check, but then most people switching from sqlserver to oracle don't
> > > implement RI at all)
> > >
> > > The only real reason for having multiple databases, as far as I am
> > > concerned, is the development, test, production scenario.
> > > If you do create multiple databases it is typical to have them all
> > running.
> > > Running one at time is to say the least *very* strange.
> > >
> > > Regards,
> > >
> > > Sybrand Bakker,
> > > Senior Oracle DBA
> > >
> > >
> > >
> >
> >
>
>
Received on Mon Oct 29 2001 - 11:34:12 CST