We don't have any production Oracle instances on VMWare but we have some test and development instances. We have a lot of SQL Server on VM's. Oracle licensing is pretty obtuse about VMWare and I don't see any way to leverage our Enterprise VMWare license to do anything more with Oracle. My understanding is that in regard to VMWare that Oracle wants paid for every CPU on the VM host whether or not you are using them. Not so for the Oracle VM. What is hard to determine, at least for me, is trying to determine beforehand if there will be any problems with moving a database to VM. We don't have any astonishingly large or high-transaction volume systems. When confronted with the organizations intent to put as much as possible on VM's I started with less risky systems and moved to more challenging. One thing to be considered up front is that if the system you want to deploy on a VM already is going to take up more than half of the VM boxes resources based on its existing needs you will make it pretty hard to fit into the VM. If the system needs to failover it needs to move to a box with some reserve capacity. All of our ESX servers have only 4CPU's. We had a lot of servers that were grossly overpowered for the databases they supported. It's a lot easier to dial it down on a VM and match the actual system requirements. We also experienced a successful failover. One of the ESX servers failed and the four test/uat database servers on it moved and restarted successfully. They were all back up within 15 minutes. Donald Freeman Database Administrator II Commonwealth of Pennsylvania Department of Health Bureau of Information Technology 2150 Herr Street Harrisburg, PA 17103 dofreeman@xxxxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Robert Freeman Sent: Thursday, May 21, 2009 12:44 PM To: Allen, Brandon; mzito@xxxxxxxxxxx; Oracle-L Freelists Subject: Re: Your experience - positive or negative - with Oracle on VMWare... Now I must admit, that *is* cool.... :-) RF Robert G. Freeman Author: Oracle ACE OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press) Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press) Other various titles out of print now... Blog: http://robertgfreeman.blogspot.com The LDS Church is looking for DBA's. You do have to be a Church member in good standing. A lot of kind people write me, concerned I may be breaking the law by saying you have to be a Church member. It's legal I promise! :-) http://pages.sssnet.com/messndal/church/parachurch.pdf ----- Original Message ---- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx> To: "mzito@xxxxxxxxxxx" <mzito@xxxxxxxxxxx>; "robertgfreeman@xxxxxxxxx" <robertgfreeman@xxxxxxxxx>; Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx> Sent: Thursday, May 21, 2009 10:38:19 AM Subject: RE: Your experience - positive or negative - with Oracle on VMWare... One more thing I'll add to the previous discussion that I don't think I mentioned before - I have actually witnessed a live transfer of an Oracle database (and its underlying virtual/guest host) from one physical host to another via VMotion (http://www.vmware.com/pdf/vmotion_datasheet.pdf) and database connections/sessions were kept intact, so I can confirm it works as advertised - at least in the one case where I tested it. Regards, Brandon -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Matthew Zito There was just a pretty good thread on this a few weeks back: //www.freelists.org/post/oracle-l/Oracle-products-on-vmware Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l