Building Oracle #GoldenGate Studio Repository…. a walk through

With the announcement of Oracle GoldenGate Studio at OOW this year, there has been a good bit of interest in what is can do for any Oracle GoldenGate environment. The basics of this new design tool is that it will allow the end user to quickly build out GoldenGate architectures and mappings; however, before you can build the architectures and mappings there needs to be a repository to store this information.

The Oracle GoldenGate Studio (more...)

Installing Oracle #GoldenGate Studio 12.2.1

At Oracle Open World this year, Oracle announced the release of Oracle GoldenGate Studio 12.2.1. This is a graphical design tool for Oracle GoldenGate. It will allow you to design your replication flows, map tables, and generate your parameter files based on these items.

To install Oracle GoldenGate Studio, you will need access to Java 8 (1.8) JDK. Java should be mapped to the PATH as well for easier access when installing. (more...)

Oracle GoldenGate Studio, It is here and so are my thoughts

Ever since Oracle purchased GoldenGate, the biggest complaint about Oracle GoldenGate (OGG) has been around the fact that it is a command line tool. I like the command line interface of OGG, the simplicity of it and what can be done by just editing the parameter files from the command line. However, for those of you that require a graphical interface, Oracle has listened and provided a new tool. This tool is Oracle GoldenGate Studio!


Submit an abstract for Georgia Oracle User Group (GaOUG) Tech Day 2016

In 2014, myself and a few other well known speakers in the Atlanta area were added to the board of directors for the Georgia Oracle User Group (GaOUG). With us being added to the Board of Directors, we initatied a rebranding of the user group from GOUSER to GaOUG in Feburary 2015, with much success. Then followed that event up with two quarterly events in April and July 2015, which proved to be an even (more...)

Discovery and Monitor Oracle Database Appliance (#ODA) using #EM12C

A few months ago, I heard that Oracle was releasing a plug-in for the Oracle Database Appliance (ODA (Oh Dah). At first I couldn’t find anything on this plug-in, then I was able to find it in the Self-Update for Plug-ins (Extensibility -> Self Update -> Plug-ins).

After finding the plug-in, it needed to be deployed to the Oracle Management Server (OMS). Once deployed, it can be used to monitor the ODA; however, this plug-in (more...)

ZFS Storage monitoring with #EM12C

How do you monitor an ZFS Storage Appliance with Oracle Enterprise Manager 12c? This is a question that has been asked a few time and I needed to solve this issue. You hear a lot about the em agents and that they need to be used to monitor many different targets. Let’s just say, that is not the case when wanting to monitor a ZFS Storage Appliance.

In order to monitor a ZFS Storage Appliance, (more...)

Issue with Perl in $ORACLE_HOME during installs

I’ve been doing some Enterprise Manager installs a bit more lately. At the same time, I’ve been working on Data Integration items such as GoldenGate and ODI.  What these products have in common are that they require an Oracle Database for a repository.  Needless to say I’ve been installing a lot of databases in test and production environments.  The one thing that has been consistent is the issue I keep seeing (more...)

Error referenced ‘irman ioracle’ during binary installation

This week I decided to redo a few of my virtual box machines and build a few new ones for testing. Getting the Oracle Linux 6.6 installed was a breeze; however, when I started to install the Oracle Database 12c binaries I was hitting errors during the linking phase. This had me puzzled for a bit to say the least. I kept getting this error:

After driving myself nuts, I decided to look closer (more...)

Possible Truncation Attack? logged in #em12c nodemanager.log file

Recently I’ve come across issues with restarting Oracle Enterprise Manager and seeing messages in the nodemanager.log. The message that I’m referring to is (followed by a java trace stack):

<Jul 2, 2015 11:46:11 PM> <WARNING> Uncaught exception in server 
Inbound closed before receiving peer's close_notify: possible truncation attack? 
Inbound closed before receiving peer's close_notify: possible truncation attack?

What is interesting about this message is the panic (more...)

Create #em12c users fast and easy!

Over the last few months, I’ve been working a project where I’ve started to dive into EM CLI and the value that EM CLI brings to cutting down on doing things like creating Enterprise Manager users. Hence the reason for this post.

Note: If you haven’t looked into EM CLI yet, I encourage you to do so. A good starting point is here. Plus there is a whole book written on the topic by some (more...)

Upgrade Oracle Enterprise Manager 12c ( to

| Sep 15, 2013

In order to upgrade out OEM environment from to we need to download the latest version of OEM from either or from Once we have the files needed to upgrade, we need to stage them in (more…)