What is the best architecture to run Oracle sucessfully run on VMWare?
You can run Oracle under VMware just fine.  The big question is what is the current hardware spec and what VMware version and edition will be hosting the database?