Re: 30 instances on one host

"Alan" <alainrtv_at_yahoo.com> wrote in message news:fbee32ac.0206171913.70c92708_at_posting.google.com...
> Suppose I want to install 30 instances on one host?
> I decided to write up some thoughts.
>
> If any of you have some thoughts...
> Please share.

As others have said this is completely mad - except for the specialised case of training Oracle Database Administration for 30 students. There is no other reason for this many instances. This many schemas on the other hand....

> Q: Why would I want to run 20 or 30 instances on a single host?
> A: It depends. Licensing is an issue. Some licenses allow you an
> unlimited number of instances on a single host. Data separation would
> likely be another compelling reason. The need for Data separation
> comes in many varieties. For example, many shops need separate
> environments for Development, Testing, and Production. An ASP might
> separate instances as an easy method to separate its customer's data.
> Some Data separation reasons hold less water with enhanced Virtual
> Private Database functionality in Oracle9i.

Data seperation is a compelling reson to use different schemas. This applies to ASPs as well.

Dev and production should never, ever, ever be on the same machine. Ever. Development crashes machines.

Test and production adds up to 2 in my book not 30.

>
> Q: If I run 20 or 30 instances on a single host, what are some
> best practices I should follow?

Resign.

etc.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************