WIXLIB

Oracle 12c Databases onHyper Converged Infrastructureusing VMware vSphere 6TECHNICAL WHITE PAPER

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Executive summary.3Introduction .3HPE Hyper Converged 380 family .4Solution overview .4Solution components .6Hardware .6Software .7Application software .8Test configuration and test scenarios .8Capacity and sizing . 10Scale-up scenario . 11Scale-out scenario . 13Consolidation scenario . 14Live migration of Oracle database using VMware vMotion . 14Best practices and configuration guidance for the solution . 15Analysis and recommendations . 17Summary . 18Appendix A: Oracle Virtual machine configuration . 18Resources and additional links . 25About the Authors . 26Acknowledgements . 26VMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Executive summaryTarget audience:Document purpose:IntroductionVMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6HPE Hyper Converged 380 familySolution overviewFigure 1.VMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Oracle VMNetworkOracleVM1HPE HyperConverged 380ClusterVMwarevSphere6ManagemntVMOracleVM2HPE HyperConverged 380ClusterOracleVM3HPE HyperConverged 380ClusterOracleVM4HPE HyperConverged 380ClusterOracle LoadGeneratorServersStorageNetworkHPE StoreVirtual VSAHPE Hyper Converged 380 ClusterHC 380 NodesESXi NetworkESXi Node1ESXi Node2ESXi Node3ESXi Node4Figure 2.VMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Figure 3.Solution componentsHardwareFigure 4.VMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Figure 5.Figure 6.SoftwareVMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Application softwareTable 1.SoftwareVersionTest configuration and test scenariosTable 2.DatastoreVSA volume nameAdaptive OptimizationSizeVMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Figure 7.Figure 8.VMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Appendix BTable 3.Capacity and sizinghammerdb.com/hammerdb transactionintro.pdfVMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Scale-up scenarioFigure 9.VMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Figure 10.Figure 11.VMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Scale-out scenarioFigure 12.VMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Consolidation scenarioFigure 13.Live migration of Oracle database using VMware vMotionVMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6vMotion StartvMotion EndFigure 14.Best practices and configuration guidance for the solutionVMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Resources and additional linksOn all servers, the following BIOS settings were enabled:For volumes created on HPE StoreVirtual VSA:For VMware es/search.do?language en US&cmd displayKC&externalId 2069356Appendix B.For the Oracle Database:Appendix CFor RHEL 7.2:Appendix DVMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Oracle 12c Databases on Hyper Converged Infrastructure using VMware vSphere 6Analysis and recommendationsVMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.comCopyright 2017 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is aregistered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.