Recover from ORA-01172 & ORA-01151

This morning I was working on an Oracle Management Repository (OMR) for a test Enterprise Manager that is used by a few consultants I work with. When I logged into the box, I found that the OMR was down. When I went to start the database, I was greeted with ORA-01172 and ORA-01151.

These errors basically say:

ORA-01172 – recovery of thread % stuck at block % of file %
ORA-01151 – use media recovery (more...)

Defining Resources in #GoldenGate Studio 12c

As I’ve been working with the beta of GoldenGate Studio 12c, I have tried to do simple things to see what will break and what is needed to make the process work. One of the things that I lilke about the studio is that prior to creating any solutions, mappings or projects, you can define what databases and GoldenGate instances will be used during the design process. What I want to show you in this (more...)

Error when starting #GoldenGate Extract against MS SQL Server

If you work with Oracle GoldenGate long enough, you will eventually have to setup against a Microsoft SQL Server. Being that GoldenGate is a heterogeneous application, this isn’t a problem; however there are small differences. One such difference is how the exact/replicat will connect to the MS SQL Database.

In an Oracle-to-Oracle configuration, you would just use a command line the following from the command line:

GGSCI> dblogin useridalias [ alias name]
or
GGSCI> dblogin (more...)

Exporting solutions from #GoldenGate Studio

In doing some testing with Oracle GoldenGate Studio, I decided to create a test solution that can be moved from studio-to-studio. In order to move the test solution from studio-to-studio, it has to be exported first. This post will be about how to export a solution so it can be archived or shipped to a co-worker.

To export a solution, you will start in the Projects window. After opening the project, you will see a (more...)

Table Definitions in Oracle #GoldenGate #12c Trail Files

Oracle GoldenGate 12c (12.2.0.1.0) has changed the information that is stored in the trail files. All the standard information is still there. What Oracle changed has to do with the meta data that is used to define a table.

Note: If you want a understand how to use log dump and general trail information, look here.

Prior to 12.2.0.1.0 release of Oracle GoldenGate, if the column order (more...)

The Integrated Heartbeat of Oracle #GoldenGate #12c (12.2)

With the announcement of Oracle GoldenGate 12c (12.2.0.1.0) at Oracle Open World this year, I was interested in hearing that Oracle has finally integrated the heartbeat process into the core functionality of GoldenGate. Setting up the heartbeat is always a fun thing to do with GoldenGate and I had hoped that this move to integrated it would bring benefits with it. To my dismay, I’m a little underwhelmed with the heartbeat (more...)

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!

(more...)

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...)

Upgrade Oracle Enterprise Manager 12c (12.1.0.2) to 12.1.0.3

Uncategorized
| Sep 15, 2013

In order to upgrade out OEM environment from 12.1.0.2 to 12.1.0.3 we need to download the latest version of OEM from either http://otn.oracle.com or from http://edelivery.oracle.com. Once we have the files needed to upgrade, we need to stage them in (more…)