Re: Is it a good idea, dev/test/production on one box

Joe Bayerii wrote:
> One of my client has only one database box, and they put all their
> development/test/production on one linux box, I was trying to persuade them
> to seperate production from development, but they seem to be concerned with
> Oracle Licence cost.
>
> Any good reason why they should buy another box and pay some extra money to
> Oracle?

Depends on factors you haven't mentioned.

1. What is the hardware platform and operating system
2. Storage subsystem
3. What is the Oracle edition and version
4. What is the load on each of the 3 instances
5. What kind of development is going on
6. What is the SLA for the production database.

So, for example, if they are on 8i running on Windows and the production load is coming from the internet serving up dynamic web pages, and the development is low-level C++, and management expects the server to have a 99.999999+% uptime it isn't going to work.

I mean why not one database instance and 3 schemas?

Your advice is good and they would be wise to follow it. I can't imagine how they can afford Oracle licenses and not a few hundred/thousand dollars for more hardware. My Grid Control machine, for example, is a used IBM ThinkPad obtained from eBay for hardly any money at all.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)