If you are one of the folks who have already upgraded the production E-Business Suite database to 19c Certified, then you are a superhero and this post is not for you. The majority of us are still running the good…

It is no secret to anyone that software release cycles are more aggressive than ever. Now that the cloud has become ubiquitous as a strategic component of IT services, we are spoiled by a constant release of new features and…

At times, you may be required to gather information about Oracle Clusterware configuration details. Instead of running multiple commands, information can be gathered using one simple command. This should work with srvctl version: 18.0.0.0.0 or higher. oracle@ol7-19-rac2 ~]$ echo $ORACLE_HOME…

I made an error when creating an Oracle ASM disk group which resulted in not being able to drop or mount the disk group because the ASM header_status was FORMER. The following steps were performed to modify the ASM header_status…

Patching an Exadata has moved from a painful task to a near-regular activity with tools such as “patchmgr”, but that doesn’t mean it can’t go sideways. This post will describe some of the most recent issues I have faced while…

Often we get involved in projects where there are all sorts of stringent security requirements. In this post, I will share a few of the methods used to meet these security requirements within Google Cloud Platform (GCP), while still allowing…

I could start this blog the same way I started this one because everything is supposed to be easy and at a 1 click distance in any cloud, so it should be the same for the database backups in Oracle…

I decided to write about Exadata Smart Scan feature for this blog post. Why Smart Scan? Well, because it is awesome and I don’t know any other relational database system that has this feature. So what is Smart Scan and…

Whether Grid Infrastructure Management Repository (GIMR) database MGMTDB is required or not depends on the version of Oracle you are using. For 19c, GIMR is not required –  About the Grid Infrastructure Management Repository However, GIMR is being created to…

The overall importance of data and information within organizations has continued to grow. We’ve also seen the continued rise of megatrends like IoT, big data – even too much data – and of course, machine learning. That’s along with the…