Infrastructure at your Service

All Posts By

Daniel Westermann

Daniel Westermann

If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?

By | Database Administration & Monitoring | No Comments

This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) – file to replicat Performing an initial load with GoldenGate (2) – expdp/impdp Using GoldenGate event actions to suspend replication for end of day reporting One question that pops up when stopping the replication by using an event marker is: What happens…

Read More
Daniel Westermann

Using GoldenGate event actions to suspend replication for end of day reporting

By | Database Administration & Monitoring | 3 Comments

The last post in this series outlined on how to do an initial load of the target database using the “expdp/impdp” method: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) – file to replicat Performing an initial load with GoldenGate (2) – expdp/impdp In this post I’ll look into how to use event actions to suspend GoldenGate replication for…

Read More
Daniel Westermann

Performing an initial load with GoldenGate (2) – expdp/impdp

By | Database Administration & Monitoring | 12 Comments

The last post in this series outlined on how to do an initial load of the target database using the “file to replicat” method: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) – file to replicat In this post I’ll show how to do the initial load by exporting a schema from the source database, importing that into the…

Read More
Daniel Westermann

Performing an initial load with GoldenGate (1) – file to replicat

By | Database Administration & Monitoring | 4 Comments

The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release.The second post explained how to create a sample replication with Oracle GoldenGate: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate In this post I’ll look how to do an initial load using GoldenGate by using the “File to replicat” method (several other methods are available). To start…

Read More
Daniel Westermann

Setting up a sample replication with GoldenGate

By | Database Administration & Monitoring | 8 Comments

The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release: Installing and patching Oracle GoldenGate 12c to the latest release In this post I’ll look in how to prepare the databases and how to setup GoldenGate for a first sample replication between two Oracle 12.1.0.2 databases. My test setup is as follows: Hostname Database Type oelgg1 DB1 Source oelgg2 DB2 Target   The idea is that…

Read More
Daniel Westermann

Installing and patching Oracle GoldenGate 12c to the latest release

By | Database Administration & Monitoring | 8 Comments

As more and more customers ask for expertise in Oracle GoldenGate this blog post is the first in a series and outlines how to install Oracle GoldenGate 12c and how to patch it to the latest release on Oracle Linux 7.1 x64. The installation sources (as always) can be downloaded from otn.oracle.com. For the latest patchset you’ll need access to mos. At the time of writing the latest patchset is 12.1.2.1.9 and can be downloaded…

Read More
Daniel Westermann

Row level security is coming to PostgreSQL

By | Database Administration & Monitoring | No Comments

Before PostgreSQL 9.5 (which is in alpha2 currently) you could grant access to individual columns of a table to users or roles. A little test script to demonstrate this: ([email protected][local]:5432) [postgres] > select version(); version ————————————————————————————————————– PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit (1 row) create table t ( id int primary key, name varchar(50), salary bigint ); insert into t ( id, name, salary ) values (…

Read More
Daniel Westermann

Representing ranges with one data type?

By | Database Administration & Monitoring | No Comments

How many applications do you know that need to define a validity of a row? And how many of these do that by adding two columns: valid_from and valid_to or similar column names? Well, in PostgreSQL (you already suspect it 🙂 ) there is much more elegant way to do that. PostgreSQL knows the concept of range types. Several of these are pre-defined and you get them once you install PostgreSQL: int4range — Range of…

Read More
Daniel Westermann

Connecting your PostgreSQL instance to an Oracle database – The PostgreSQL 9.5 way

By | Database Administration & Monitoring | 8 Comments

As you might know PostgreSQL 9.5 is currently in alpha 2. One of the new features will be the possibility to import foreign schemas. Having this it is no longer required to create all the foreign tables which saves a lot of work. Setting up oracle_fdw was done in exactly the same way as in the previous post. Make sure you use the latest version of oracle_fdw as some internals changed in PostgreSQL 9.5 which…

Read More
Daniel Westermann

Connecting your PostgreSQL instance to an Oracle database

By | Database Administration & Monitoring | 16 Comments

For integrating data from other systems PostgreSQL has the concept of foreign data wrappers. Many of these exist for different types of systems. In this post I’ll look into how you may connect PostgreSQL to Oracle. The home of the foreign data wrapper for Oracle (as most of the PostgreSQL stuff) is on github. If you do not want to clone the git repository you can download it from the PostgreSQL extension network, too. For…

Read More