Re: Are 5 Ora 7.3.3 Instances on 1 NT Box a good practice ?

Yes, running 5 nearly identical database instances on one small NT machine is a really dumb idea, but here is how it happened.

The client, a medium sized engineering company developed a PowerBuilder / Oracle application for internal use. Apparently the data model did not allow for multiple sites, so that every time they added an office, they installed a local Oracle server (one instance). Well, because the company had only 3 DBAs (at one office!) and more than 10 installations, the care and feeding of Oracle became difficult. This resulted in the first consolidation of multiple instances of nearly identical databases. Then the company got bought by a bigger company and they laid off all the IT staff in the central office (Dilbert Management!). So as a last resort, the PowerBuilder developers started packing more and more instances onto fewer and fewer NT boxes. Then they called me in to fix up their mess !

Moral of the Story: Do a better job with data modeling !

Rock Cogar.
Radian International LLC.
Oak Ridge, TN. USA.

In article <hEVb4.114$qe2.7424_at_nnrp2.rcsntx.swbell.net>,   "spencer" <spencerp_at_swbell.net> wrote:
> I can think of a scenario in which you might want to run more
> than one instance of Oracle on a single machine. You might want
> to use one instance for 7x24 OLTP, and use the other instance as
> a "read only" data warehouse.
>
> By running two instances (two databases), you could administer
> each one independently. For example, using ARCHIVELOG mode for
> the active 7x24 online transaction database (where you don't
> want to lose any data) and NOARCHIVELOG mode for the "warehouse"
> database that is only loaded (updated) in batch.
>
> But running 5 nearly identical database instances on one small
> NT machine? I'm racking my brain, but I can't fathom the
> business goals, issues, constraints or requirements which led to
> that solution. I'm intrigued ! Availability? Security?
> Performance? Maybe someone else has an idea why you would need
> to run 5 instances on a single NT machine.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 04 2000 - 06:48:16 CST