On Demand hot extend clustered vmdk’s online without downtime – Hot Extend RAC clustered disks

 

 

 

This blog focuses on the complete list of steps to be taken to increase the size of the clustered vmdk(s) using Multi-writer flag of an Oracle RAC Cluster. This blog describes the various options using both Native Oracle tools and vSphere tools to attempt to increase the size of the Oracle RAC clustered vmdk(s).

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 clustered vmdk’s online without downtime – Hot Extend RAC clustered disks

Reclaiming dead space from Oracle databases on VMware Hybrid Platform

 

 

Dead space reclamation has always been a challenge especially with thin-provisioned volumes. Thin provisioning dynamically allocated storage on-demand to the workloads in a flexible and efficient manner.

Any database day to day 2 operations would include dropping tablespaces, dropping or resizing datafiles, truncating tables, deleting archive logs from ASM FRA diskgroup etc. .

One would expect the free space to go back to the storage free pool to be used for further allocation purposes, but that ability depends on

  • How the Application reports the discarded space to the GOS (Guest Operating System)
  • How the GOS reports the discarded space to underlying VMware layer
  • And eventually how VMware vSphere reports the discarded space to the Storage array

 

This blog focuses on the Oracle ASM Filter Driver (ASMFD) capability to report discarded or free space of thin-provisioned vmdk’s to the GOS which eventually gets reported to the VMware datastores and the underlying Storage array.

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on Reclaiming dead space from Oracle databases on VMware Hybrid Platform

Oracle Java on VMware Hybrid Cloud Platform – Dispelling the Oracle Java Licensing myths

This is just another blog (JAB) about Dispelling the “Galaxy Licensing” Oracle Java on VMware FUD  perpetuated by overzealous licensing and sales teams, which is in complete contrast to the reality of the actual Contractually Impactful documents.

  This blog intends to clear up the reality of how to effectively license Oracle Java workloads on VMware Hybrid Cloud ( vSphere, vSAN , VxRAIL , VMware Cloud on AWS and other VMware Cloud Platforms) and to make it a cost effective one as well.

 

 

Java Licensing Models

 

Prior to 2019, there were three Java SE products known as

  • Java SE Advanced
  • Java SE Advanced Desktop
  • Java SE Suite

  These models required commercial users to purchase upfront licenses and pay annual support.

  Starting 2019, the above three models was replaced by two new subscription-based models

  • Java SE Subscription
  • Java SE Desktop Subscription

  As per this model, one no longer needs to purchase licenses upfront and pay annual support for Java SE.  Instead, one would have to pay a monthly subscription fee under one to three-year terms for server or desktop licensing and support.

 

 

Continue reading

Posted in Java, VMware Hybrid Cloud | Comments Off on Oracle Java on VMware Hybrid Cloud Platform – Dispelling the Oracle Java Licensing myths

No downtime Storage vMotion of Oracle RAC Cluster using shared vmdk’s with multi-writer attribute from one vSAN to another vSAN Cluster using VMware HCI Mesh

The previous blog post “Around the “Storage World” in no time – Storage vMotion for Oracle Workloads (RAC & Non-RAC) within same vSphere Cluster” addressed the following use cases of Storage vMotion of an Oracle RAC Cluster with shared vmdk(s) using multi-writer attribute .

 

The following uses cases were addressed by the previous blog post for Oracle RAC clusters within the same vSphere Cluster –

  • Migrate Oracle database storage from one Tier to another Tier within a storage array
  • Migrate Oracle database storage from one array to another array (within and between data centers) for the same datastore type [ VMFS . NFS, iSCSI, vVOL, vSAN]
  • Migrate Oracle database storage from one array to another array (within and between data centers) across different datastore types [ VMFS , NFS, iSCSI, vVOL, vSAN]

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on No downtime Storage vMotion of Oracle RAC Cluster using shared vmdk’s with multi-writer attribute from one vSAN to another vSAN Cluster using VMware HCI Mesh

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