Tommy,

This technical reports http://media.netapp.com/documents/tr-3861.pdf provides all the information you need to run Oracle with VMware. There two different ways to approach this. One of the ways to do is how you listed below and the other way you want to do is to run oracle binaries of the VMDK and have the rest of the DB components on a flexible volume and mount it over NFS.

The answer to your question is you can create the 5 different databases you create 5 different VM with each DB can have all its VMDK in the same datastore as the OS or can also be in a different datastore. It all comes down to how you would backup the Oracle data.

Bikash

From: Tommy.Fallsen@kongsberg.com [mailto:Tommy.Fallsen@kongsberg.com]
Sent: Friday, September 23, 2011 1:50 AM
To: toasters@teaparty.net
Subject: Oracle and VMware Datastores

Hi

Im setting a new Oracle Database solution to replace a old Oracle RAC on EVA8400.

After reading Oracle Databases on VMware vSphere 4 - Essential Deployment Tips i got a few question still needs answered.

Our new storage is a FAS 3240 7-Mode

We have a SATA and SAS aggregate and 1TB Flash cache available.

SAS 1  Raid Group (16 disks)

SATA 4  Raid Group (56 disks)

Whats the recommendations for Datastores and VMDK's?

From i can gather i need to create a volume dedicated to Oracle and present(NFS) it as Datastore for Oracle only.

And create VMDK's like this:

VMDK-1 OS from another Datastore

Oracle Datastore

VMDK-2 Oracle Binaries
VMDK-3 Oracle data
VMDK-4 Oracle Redo
VMDK-5 Oracle Archivelogs

I have 5 databases so 5 VM's where i create a volume with Datastore for each?

Would like input from the list how others have done it.

-  Tommy Fallsen

                  SA/DBA Grunt

---

CONFIDENTIALITY
This e-mail and any attachment contain KONGSBERG information which may be proprietary, confidential or subject to export regulations, and is only meant for the intended recipient(s). Any disclosure, copying, distribution or use is prohibited, if not otherwise explicitly agreed with KONGSBERG. If received in error, please delete it immediately from your system and notify the sender properly.