Oracle E-Business Suite and 12cR1 database in Extended support – What to do?

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…

Read More >

Top 10 New Features of SQL Server 2019

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…

Read More >

How to Find Clusterware Configuration Details Using srvctl

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…

Read More >

How To Fix ASM Disk Header Status from “FORMER” To “MEMBER”

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…

Read More >

Issues and workarounds for Exadata Patching (JAN-2019)

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…

Read More >

Creating secure access architecture on Google Cloud Platform (and building it with Terraform)

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…

Read More >

Troubleshooting Oracle Cloud Infrastructure Automatic Backups

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…

Read More >

Exadata Smart Scan: A Quick Overview

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…

Read More >

Using MDBUtil To Create Grid Infrastructure Management Repository Database

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…

Read More >

Top big data analytics trends hold true as we look toward 2020

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…

Read More >
Page 2 of 35112345...10...Last Page »