Author: Michael Dinh

How to remove grid 12.2 after an 18c upgrade

The environment started with a GRID 12.1.0.1 installation, upgraded to 18.3.0.0, and performed out-of-place patching (OOP) to 18.6.0.0. As a result, there are three GRID homes and, ideally, we should remove 12.1.0.1 to save space because it’s longer required. This…

Read More >

How to use mount-dbfs.sh to resolve “Device or resource busy”

I was not satisfied with using fuser -mv to identify processes causing DBFS failure to unmount and killing the processes haphazardly. Upon further investigation, mount-dbfs.sh can be used to kill processes causing “Device or resource busy” and unmount DBFS. One…

Read More >

A simple command that saved me

So there I was, reviewing the environment to create an action plan for patching. To my surprise, I noticed the following when checking DBFS: I will demonstrate the simple command I used to ensure that all services that are supposed…

Read More >

How to troubleshoot a failure to mount DBFS

Stop a CRS error with [Stop of ‘ora.crsd’ on ‘host02’ failed.].  I will demonstrate my attempts to troubleshoot and identify the cause for failure. # crsctl stop crs DBFS is registered and managed by CRS: $ $GRID_HOME/bin/crsctl stat res -w…

Read More >

Troubleshooting a failure when upgrading to Oracle 18c

WhenI was upgrading Grid to 18c, the final step was to run gridSetup.sh -executeConfigTools, which failed. Unfortunately, the error provided was not very descriptive or useful. In this post, I will demonstrate how I went about troubleshooting the failure. To…

Read More >

How to configure X11 for Vagrant Box

“Good artists copy, great artists steal” – Pablo Picasso I am currently using Vagrant boxes from Mikael Sandström (oravirt) and unfortunately, it did not have X11 configured. Typically, using CLI is better for automation; however, there may come a time…

Read More >

Why you shouldn’t delete GoldenGate README

When installing Oracle GoldenGate for Big Data, it’s better to not delete the README file as it provides the version for GoldenGate Java Adapter. The version for GoldenGate ggsci is 12.2.0.1 while the version for Java Adapter is 12.3.0.1. The…

Read More >

Sharing GoldenGate directories in RAC environments

GoldenGate operates in an active/passive capacity for RAC databases. When installing GoldenGate on a local host, certain directories are required to be on shared storage. I will share my opinions for which directories should be placed on shared storage. Determine…

Read More >

How to prepare a response file for a grid 18c silent upgrade

Due to security and complexity of the environment, the option to use Graphical User Interface (GUI) is not always available. Upgrade operations will need to be performed from the command line interface (CLI). Determine groups assigned to grid and oracle…

Read More >

How to simplify automation: using environment variables

Michael Dinh provides simple solutions for automating GoldenGate processes from source to destination.

Read More >