Author: Michael Dinh

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 >

How to determine RMAN backup size

A time long ago, I wrote a SQL query to determine RMAN backup size. Here is another validation for the SQL query. Why is this important? Because, as part of a backup review, it’s good to know the growth for the backup…

Read More >

Using RDA to check Oracle Database preinstallation

Remote Diagnostic Agent (RDA) is often under-utilized. It has some very nice features such as database preinstallation check. Remote Diagnostic Agent (RDA) – FAQ (Doc ID 330363.1) Remote Diagnostic Agent (RDA) – Getting Started (Doc ID 314422.1) Stay with me…

Read More >

GoldenGate: relative or absolute path for trail files?

When implementing GoldeGate solutions, something as simple as path to trail files can create havoc. What is the correct path for trail format? It depends. There is one important factor to consider. You can change any of the attributes specified…

Read More >

Oracle Enterprise Manager Cloud Control 13c release 3 (13.3.0.0) database template

I am currently working on a project to install Oracle Enterprise Manager Cloud Control Release 13.3 and was looking for a more simplified method to create a 12.2 database with all the required components. I was excited to find: Creating a…

Read More >

Enable X11 forwarding after Sudo SSH session for AWS EC2 Linux instance

Working with a secure environment presents some challenges and this post will demonstrate how to overcome one of the challenges. Prerequisites: Configuration for X-Windows must have been completed. Scenario: From laptop, connect to dinh@host, then connect to ssh ec2-user, then…

Read More >
Page 1 of 41234