Re: One or more Databases

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 - 09:26:15 CST