Author Archives: maazanjum

A Useful Metric Extension in EM12c for Unsupported Oracle Database Versions

Metric Extensions (ME) in EM12c are the new User Defined Metrics from EM11g. It’s an awesome extension of EM12c to monitor non-standard metrics. For example, EM12c’s Oracle Database Plugin 12.1.0.4.0 and 12.1.0.5.0 are only supported with the following versions of the database: I wrote a post on an Alternative Method to monitor GoldenGate from EM12c […]

Adding Tables to an Existing GoldenGate Configuration with Transaction Integrity

There is always something new to learn every day. For me, today was one of those days, where I learnt a new way to add new tables to an existing Extract, Pump, and Replicat setup.   The current configuration consists of a single Extract and Replicat running OGG 11.2.1.0.13 on OEL 6.4 64bit. Both databases […]

GoldenGate 12.1.2.0 Install/Upgrade on OEL 6.4 x86-64

It was about time that I started working with the new release. I’ve had to upgrade my current 11g install, and since I’m on a documentation high these days, I put something together to help anyone else who wants to go through the install. My current install is OGG 11.2.1.0.13 on Linux 64bit running against […]

GoldenGate Veridata 11.2.1 Agent Installation

With my previous post, I completed the Server component install and moving ahead I’d like to proceed with the agent installs. The Veridata server communicates with the hosts (that are running on each target and source servers) via the Veridata Agents. There are basically two types of agents; Java based and the C-Agent. The latter […]

GoldenGate Veridata 11.2.1 Server Installation

Today, I’d like to share my experience with a tool that I’ve used infrequently with GoldenGate. Veridata is Oracle’s answer to Data Validation for environments where a replication technology is utilized. In other words, the tool is agnostic (but partial) to a set Database vendors. You can install it on a variety of platforms, and […]

Patch and Provision with EM12c: #4 Software Library – Create a Component From Oracle Home Clone

To continue with the previous series, I want to illustrate another useful feature with the Patching & Provisioning functionality within EM12c. Using the provisioning functionality, one can create software components which contain compressed installation binaries. This feature is not limited to only Oracle software, but to illustrate an example, I’d like to show you how […]

11gR1 to 11gR2 RAC – An Upgrade Experience on Solaris

I’ve recently gone through an experience (see title), that I thought would be a good one to share. As of late, I’ve started documenting the life out of any project/task, and this is one of in the long line of many. Basically, the goal here was to upgrade an existing 11gR1 RAC configuration to 11gR2 […]

SRVCTL: Add Preferred Instances

Dedicated to an old friend and colleague. 1.     Add the service. Please take note, the instance names are in UPPER case. [oowner@gxtbdb01 ~]$ srvctl status service -d utldb [oowner@gxtbdb01 ~]$ srvctl add service -d utldb -s test -r UTLDB1 2.     Start it [oowner@gxtbdb01 ~]$ srvctl status service -d utldb Service test is not running. [oowner@gxtbdb01 […]

Oracle Golden Gate 12.1.2

I’ve only just caught up on the new OGG release news! Stepping through just the documentation, I’m excited about trying it out in the next few weeks.   Edited December 19, 2013: It took me a while to get around it, but I did write a post on installation/upgrade to this version here. http://docs.oracle.com/goldengate/1212/gg-winux/index.html Cheers!

How to Resume an RMAN Duplicate on Failure – Just Re-Run it!

If you find yourself at the with an error message like below during an RMAN Duplicate, don’t worry about it. As I found out from dumb luck, it’s quite easy! RMAN-03002: failure of recover command at 10/07/2013 15:11:47RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 53302 and starting SCN of 143193979270 […]

Musings

Things I see and learn!

Thoughts from James H. Lui

If you Care a Little More, Things Happen. Bees can be dangerous. Always wear protective clothing when approaching or dealing with bees. Do not approach or handle bees without proper instruction and training.

bdt's blog

Sharing stuff (by Bertrand Drouvot)

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting

Vishal desai's Oracle Blog

Just another WordPress.com weblog