Author: Michael Dinh

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 >

EM 12c, EM 13c: Delete Agent and Targets Using emcli

It’s feasible to delete agents and targets using GUI but can take a lot of work depending on configuration and security. Some of the complexities involve port forwarding and access to web browser which is not always available or simple…

Read More >

Simplify Oracle Critical Patch Updates Using Simple Configurations

There are many automation tools available and what I am about to share doesn’t require any. Currently, I am patching Oracle July 2018 for AIX and October 2018 for Linux. The steps are the same and only the patch number…

Read More >

Recovering From Quarterly PSU Patching Disaster

Applying GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.181016(Patch 28429134) for AIX (64-Bit) was a disaster for Oracle Restart environment, as described in a previous post. # $GRID_HOME/OPatch/opatch auto $GI_PSU -ocmrf /tmp/ocm.rsp patch /stage/psu/11g/GI/2018OCT/28429134/27735020/custom/server/27735020 apply successful for home /u01/app/oracle/product/11.2.0/db_1 patch /stage/psu/11g/GI/2018OCT/28429134/28204707 apply failed…

Read More >

The Best Times to Apply Oracle Quarterly Patches

When is the best time to apply an Oracle quarterly patch? I suppose the answer is, “It depends.” As it turns out, we started to apply October 2018 Grid Infrastructure PSU for AIX the day after it was released and…

Read More >

How Do You Test Your Oracle Database Backup?

From my experience, the one area where a DBA cannot afford to make errors is in database backup. When was the last time database backup was tested? Was it successful? How often is backup tested? Is testing automated? I was…

Read More >

Troubleshooting a GoldenGate Error Code

After applying Oracle GoldenGate V12.2.0.1.170919 for Oracle Database 12c OPTIMIZER Patch for Bug# 26849949, starting GoldenGate extract failed with OGG-00303: Unable to open credential store. Error code 43,490. Here is what the report looks like. $ head -50 E_LAX6.rpt ***********************************************************************…

Read More >
Page 1 of 3123