Today's guest post is by Vamsee Kasavajhala, Principal Product Manager for the Oracle MiniCluster.
As more and more customers adopt Oracle MiniCluster as their platform of choice to run Oracle databases and applications, one common message that resonates is how easy it is to use the platform. We have had some customers use words synonymous with simplicity such as “Microwave” or “iPhone” and that is really great to hear.
MiniCluster is designed for the modern DBA and has many features built into the product, but the brains of the product is really the management software – MiniCluster Virtual Assistant (which comes free of cost with the product). It really simplifies day to day tasks that DBAs do.
During the initial system setup, with MiniCluster, we guide the user and configure the Network, Create a Oracle Grid and Database Install directory, Configure disks for DATA, REDO and RECO disk groups, and other database configuration based on customer inputs. This makes it really easy for the DBA to get started with creating database instances and managing them as opposed to worrying about the infrastructure and system setup.
In this blog, I will highlight some of the most common tasks that you would do on a daily basis and how easy it is to do the same on MiniCluster.
Database Instances are constrained by CPU, and now you want to increase the number of cores assigned to the Virtual Machine?
Click “Database” -> Click “Virtual Machine Group Profile” -> Click “Edit” Cores -> Increase to any desired amount. Easy!
MiniCluster supports up to 8 DB VMs. Whenever you create a new DB VM, this VM is automatically added to the cluster and other necessary steps are completed automatically. MiniCluster also has application VMs, and there is no limit on number of Application VMs you can have. This drastically simplifies adding new VMs to an existing DB Cluster. It is important to note that, this does not include application VMs. Total number of VMs in MiniCluster depend on available resources.
Let’s assume that you started with 2 VMs, one on each physical node, and now you want to increase the number of VMs on Node 1, to 4 because you would like to assign dedicated cores to a new database instance you want to create.
Click “Database” -> Click “Virtual Machine Group Profile” -> Click “ Edit” -> Increase the count of VMs from 1 to 4 on Node 1. Easy!
Now that you have your infrastructure ready, let’s create Database homes. MiniCluster automates the creation of:
1. Oracle Database Enterprise Edition 11gR2 Homes
2. Oracle Database Enterprise Edition 11gR2 Homes
3. Oracle Database Standard Edition 2 Homes
All of the above database homes can be mixed and matched in a VM, and you can have any number of database homes in each VM. Note: Oracle Database SE1 is also supported, but it is not automated.
Click “Database” -> Click “Instances” -> Click on “Create Database Home” -> Select “Database Home Version” -> Select “Patch Level” -> Click “Create” and you are done! Easy!
Let’s look into creating a database instance next.
On the MiniCluster, you can create:
1. Single Instance Databases
2. RAC ONE Node Databases
3. RAC Databases
All of these instances can co-exist and you can have any number of instances per DB home and as mentioned above, any number of database homes per Database VM.
Click “Database” -> Click “Instances” -> Select VM and database home you want the instance to be in -> Click “+” sign -> Provide Database parameters -> Select “Database Type”-> Click “Create”
At this point, you simply log into the virtual machine and manage your databases like you always do.
Stay tuned next week for how MiniCluster makes patching and maintenance a breeze.
Vamsee Kasavajhala is an industry veteran and Principal Product Manager for Engineered Systems at Oracle. He loves all things tech, is an avid sports nut and a lifelong San Antonio Spurs fan. You can reach him on twitter at @vskasa or in LinkedIn at linkedin.com/in/kvamsee.