Author: Michael Dinh

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 >

Gathering GoldenGate deployment status

The objective of this post is to demonstrate how to gather existing GoldenGate deployment status. The rationale is to gather all the pertinent information for GoldeGate deployment using RAC in order to relocate the GoldenGate trail from DBFS to ACFS…

Read More >