Intro I recently had a situation where I was troubleshooting a system that had fallen victim to some intermittent and very high load averages. At first, there were no apparent reasons for the high load averages, so that sent me searching for some monitoring tools to help identify the issue. Besides using OSWBB and dstat, … Continue reading
Oracle Golden Gate – OGG-01028 Incompatible record
Intro The incompatible record error is one I have seen a couple of times now with DB2 as the source and it seems to hing around something that occurs on weekends when they take the system down for maintenance. I have yet to pinpoint the cause, but this workaround does get everything back up and … Continue reading
Using dstat for monitoring CPU, Memory, Disk, etc
Overview dstat is a good tool for replacing vmstat, netstat, iostat, and ifstat. It it a very lightweight tool that can consolidate and correlate data that you would normally have to capture in different terminals. Examples RMAN Backup Throughput I’ve used dstat before in the past to monitor backup throughput over interfaces. Of … Continue reading
Changing Timezone Settings on Oracle Database Servers
Twice now in the past month, I have run across some clients that are wanting to change the timezone of their database due to a server relocation. Both cases ended up being a bit similar, one a single instance and the other on Exadata. Since I had to lookup how to do it the seconds … Continue reading
GoldenGate Initial-Load Trail to Replicat – Part 2
This article will demonstrate how to perform a OGG Initial Load using the Trail to Replicat technique. You can see part 1 here . In this article, we get by the bug since we are on a version higher than 11.2.1.0.1. Using this method, there is no limit on the amount of data that can … Continue reading
Oracle GoldenGate : DB2 to Oracle
This article will demonstrate heterogeneous replication using OGG from DB2 to Oracle. 1. Pre-requisites OGG is installed on source and target systems. 2. Environment DB2 on Mainfram Z/OS Oracle Database : 11.2.0.3 3. Configuration on Source Server ( DB2 ) A. Parameter Files Place all parameter files in the $GG_HOME/dirprm directory. Extract Capture … Continue reading
GNU screen Command
The screen utility can be used to start a session that will be persistent if the terminal is lost, plus it also provides the ability to login from another computer simply by attaching to the screen session name. Here are some essential commands to know: Start new session with a name and a log … Continue reading
GoldenGate 12 – Classic, Coordinated and Integrated Replicat
I. New Replicat Modes Availalble in GolgenGate 12.1 Prior to the release of version 12.1, the replicat applied transactions to the target database serially. To achieve parallelism, tables could be split across multiple replicats to get data applied quicker and reduce lag. Drawbacks to this approach was the manual configuration of multiple replicats, trail files, … Continue reading
GoldenGate 12 Users, Privileges and Security on Multitenant DBs
I. Users and Privileges With the release of the latest versions of GG and database, there have been many modifications that require changes in how users are created, logins and the privileges granted. A. Database Users If the source database is a multitenant container database, the Extract user must be a common user and must … Continue reading
Mapping problem with compressed update record – Key column missing from update
Here’s an example of an update statement failing on the target database on a table without a primary or unique key. Since there are no keys defined on the table, the replicat will consider all the columns as key columns. The update statement that was processed by the extract only logged the column values that … Continue reading
