Backing up Oracle Workloads (RAC & Non-RAC) with VMware Snapshot Technology

 

In computer systems, a snapshot is the state of a system at a particular point in time. To avoid downtime, high-availability systems may instead perform the backup on a snapshot—a read-only copy of the data set frozen at a point in time—and allow applications to continue writing to their data. [ Wikipedia ]

This blog addresses how one can take VM level snapshot of Oracle Single Instance / RAC workloads using VMware snapshot technology, keep certain caveats in mind.

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on Backing up Oracle Workloads (RAC & Non-RAC) with VMware Snapshot Technology

Oracle Real Application Cluster (RAC) Support on VMware Clouds

Oracle Real Application Cluster (RAC) Support on VMware Clouds

 

As of December 9th, 2020, VMware recommends that anyone currently running OR planning to run, an Oracle Real Application Cluster (RAC) in a VMware Cloud environment, reach out to Oracle Corporation for any Oracle support related matters with RAC on our cloud platform.

 

Please reach out to your VMware representative for any clarifications on the below guidance’s.

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on Oracle Real Application Cluster (RAC) Support on VMware Clouds

PVSCSI Controllers and Queue Depth – ASM SAME and Oracle Workloads

The previous blog post ’ PVSCSI Controllers and Queue Depth – Accelerating performance for Oracle Workloads’ purpose was to raise awareness of the importance of using PVSCSI adapters with adequate Queue Depth settings for an Oracle workload.

 

This blog focuses on the implementation of Oracle SAME (Stripe and Mirror everything) technology using Oracle ASM along with using multiple VMware PVSCSI controllers with queue depth for PVSCSI controllers and VMDK’s set to maximum to achieve maximum performance for Oracle workloads.

 

 

 

 

This blog

  • Is not meant to be any kind of performance study or bake off any sort
  • contains results that I got in my lab running a load generator SLOB against my workload, which will be way different than any real-world customer workload, your mileage may vary
  • remember, any performance data is a result of the combination of hardware configuration, software configuration, test methodology, test tool, and workload profile used in the testing. 

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on PVSCSI Controllers and Queue Depth – ASM SAME and Oracle Workloads

PVSCSI Controllers and Queue Depth – Accelerating performance for Oracle Workloads

For readers who are familiar with the Asterix and Obelix series, the magic potion refers to the potion brewed by Getafix, that gives the Gaulish warriors superhuman strength.

 

 

 

 

 

One of VMware’s magic portion for Oracle workloads is the ‘Paravirtualized SCSI Controllers a.k.a PVSCSI Controllers’ which is accelerates workloads performance on a VMware vSphere Platform.

This blog is meant to raise awareness of the importance of using PVSCSI adapters with adequate Queue Depth settings for an Oracle workload.

This blog

  • Is not meant to be a deep dive on PVSCSI and Queue Depth constructs
  • contains results that I got in my lab running a load generator SLOB against my workload, which will be way different than any real-world customer workload , your mileage may vary

Remember, any performance data is a result of the combination of hardware configuration, software configuration, test methodology, test tool, and workload profile used in the testing.

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on PVSCSI Controllers and Queue Depth – Accelerating performance for Oracle Workloads

VMworld 2020 – Breakout Sessions , Expert Round Tables and Demos focused on Business Critical Applications (BCA)

Join us at VMworld 2020 to learn how Business Critical Apps benefit from our latest platforms  

 

 

 

 

VMworld 2020 will be a global online event starting September 29 – October 1, 2020. While the program will be adapted to fit the new digital format, VMworld will still be the place to learn about innovative new technology solutions, hear perspectives from VMware executives, dive into educational and technical content, and engage with experts across the industry ecosystem.

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on VMworld 2020 – Breakout Sessions , Expert Round Tables and Demos focused on Business Critical Applications (BCA)

To NUMA or not to NUMA – Oracle workloads and NUMA

 

 

To NUMA or not to NUMA – that’s the question that comes up when considering Oracle workloads and NUMA.

 

This blog

  • Is not meant to be a deep dive on ESXi NUMA constructs
  • Is not meant to be by any way, any final recommendation, whether to enable NUMA at the database level or not
  • contains results that I got in my lab running a load generator SLOB against my workload, which will be way different than any real-world customer workload
  • is meant to raise awareness of the importance to test one’s database workload with / without Oracle NUMA and then make an informed decision whether to enable Oracle NUMA or not

 

Remember, any performance data is a result of the combination of hardware configuration, software configuration, test methodology, test tool, and workload profile used in the testing. 

The blog assumes that the reader is familiar with the ESXi NUMA constructs. This blog focuses on the use cases around testing Oracle workloads with and without NUMA using a load generator SLOB.

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on To NUMA or not to NUMA – Oracle workloads and NUMA

On Demand hot extend non-clustered Oracle Disks online without downtime – Hot Extend Disks

 

 

The first blog focused on how to Scale up CPU and Memory by hot adding CPU and Memory on the fly to an Oracle workload which can be found here.

This 2nd blog in the on-demand Scale up series focused on how to Hot Add / Hot Remove vmdk’s to / from a VM running an Oracle workload without any application downtime which can be found here.

This blog focuses on the OS and Oracle database steps to be taken once non-clustered vmdk(s) are hot extended while an Oracle database using ASM is running. Current restriction of shared vmdk’s using the multi-writer attribute is that Hot extend virtual disk is disallowed as per KB 1034165 & KB 2121181

 

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on On Demand hot extend non-clustered Oracle Disks online without downtime – Hot Extend Disks

On Demand Scaling up / Scaling down Storage resources for Oracle production workloads – Hot Add / Hot Remove non-clustered Disks

 

 

The first blog focused on how to Scale up CPU and Memory by hot adding CPU and Memory on the fly to an Oracle workload which can be found here.

This blog is the 2nd blog of the on-demand Scale up series which focuses on how to Hot Add / Hot Remove vmdk’s to / from a VM running an Oracle workload without any application downtime.

This blog will not focus on the actual steps how to Hot Add / Hot Remove vmdk(s) / rdm(s) to / from the Oracle Database VM. 

This blog will focus only on the OS and Oracle database steps to be taken once non-clustered vmdk(s) are added or removed from a VM while the database is running.

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on On Demand Scaling up / Scaling down Storage resources for Oracle production workloads – Hot Add / Hot Remove non-clustered Disks

VMware and Oracle together – A brave World – Oracle Cloud Days, 2020

 

 

The announcement on Sept 16th, 2019 by Larry Ellison, CEO Oracle Corporation at the Oracle Open World 2019 keynote heralded a new era in the VMware Oracle partnership, centerpiece of this relationship being a new service that will be offered by Oracle called Oracle Cloud VMware Solution.

This service will enable customers to run VMware Cloud Foundation on Oracle’s Generation 2 Cloud infrastructure. But equally important for the thousands of customers running Oracle software on VMware today in their data centers, Oracle and VMware have entered into a new mutual support agreement for currently supported Oracle products running on VMware environments.

More details can be found here

 

Further on Oct 9th, 2019, the 2nd part of this strategic alliance culminated in a new agreement for enhanced support for Oracle products running on VMware Environments running on Oracle Supported Computing Environments. Oracle Corporation has now changed its landmark Metalink/MyOracleSupport.com note 249212.1 describing that mutual support.  

More details can be found here

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on VMware and Oracle together – A brave World – Oracle Cloud Days, 2020

VMware and Rocky Mountain Oracle User Group (RMOUG) – Training Days, Feb 18th, 2020

 

 

 

RMOUG is one of the largest Oracle User groups in North America.  The RMOUG’s Training Days is the premier (and largest) grass-roots Oracle user training event in the U.S., offering an incredible variety of technical and functional educational sessions over three days from world-renowned experts.

https://rmoug.org/training/

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on VMware and Rocky Mountain Oracle User Group (RMOUG) – Training Days, Feb 18th, 2020