Re: Multiple 10g instances (standard edition) one machine / resource allocation

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 5 Sep 2007 18:26:37 +0200
Message-ID: <46ded8d9$0$230$e4fe514c@news.xs4all.nl>

"DA Morgan" <damorgan_at_psoug.org> schreef in bericht news:1189004915.590055_at_bubbleator.drizzle.com...

> Shakespeare wrote:
>> "jeremy" <jeremy0505_at_gmail.com> schreef in bericht 
>> news:1188918123.470027.6110_at_57g2000hsv.googlegroups.com...

>>> It has been suggested that we could set-up a new production
>>> environment on 10gR2 (2 instances) using VMWARE. This would enable us,
>>> as I understand it, to allocate the resources of the server in the
>>> ratio we choose between the different databases as each would
>>> effectively be running on its own machine.
>>>
>>> I can see that Oracle does not support installation of its products on
>>> VMWARE
>>> (see
>>> https://metalink.oracle.com/metalink/plsql/f?p=130:14:8993822913808118385::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,249212.1,1,1,0,helvetica
>>> )
>>>
>>> So to me it would seem foolhardy to progress with that idea.
>>>
>>> Is there any technology in 10gR2 (Standard Edition) that enables the
>>> allocation of a finite set of resources that may not be exceeded?
>>>
>>> Thanks
>>> --
>>> jeremy
>>>

>>
>> Apart from all the licensing issues etc, I know by experience that some 
>> Oracle products run on VMWare very well, but other DO have problems (at 
>> least on VMWare Workstation, not sure about ESX) Oracle 10g Application 
>> Server Infrastructure for example causes masses of Page Faults, and keeps 
>> using 5 to 10% CPU while doing nothing (except page faults). It's a known 
>> issue, but right: unsupported, so.....
>>
>> But under ESX we have seen different behaviour as well. Configs running 
>> perfectly under 'real iron' started to show faulty behaviour when ported 
>> to VM. (In this case, Win2003 server).
>>
>> So you may be replacing one problem with an other.....
>>
>> Shakespeare
>
> Lets take as one example Oracle RAC. Oracle uses a VMWare environment to
> teach their RAC classes. I find that horrifying as I don't think people
> learn real-world skills in unreal environments. But obviously RAC is
> stable running on VMWare. That does not mean it will scale and that does
> not mean it is easy to support when configured creatively which is the
> point of most VM environments.
> -- 
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Teaching on VM is ok, you can't expect all students to buy multiple servers. This does not mean one should use it as a production environment....

I'm glad you don't teach Life Saving ..... which is usally taught in unreal environments (we can't kill em all, can we?)

Shakespeare
(And I'm still glad you don't sell cars too ;-))) Received on Wed Sep 05 2007 - 11:26:37 CDT