Oracle GoldenGate replication + AES encryption on the fly – part 1 of 2

Let’s consider a poor man’s data encryption in the database. We’ll use AES128 CBC algorithm to encrypt the data. The application is written in such way that it can encrypt/decrypt the data while doing database operations. This solution is license free, works with no additional database licenses. A new requirement has arrived – the data […]

Oracle GoldenGate replication + AES encryption on the fly – part 1 of 2 Read More »

Oracle GoldenGate Microservices Architecture 12.3 quick set up tutorial

Oracle GoldenGate 12.3 Microservices Architecture just came out. This is a separate build, and in contrary to previous architecture (called now Classic Architecture) has distinct installation binaries and completely different directory structure after installation. Processes are run from different binaries and the whole configuration is also completely different. This article is a complete tutorial which

Oracle GoldenGate Microservices Architecture 12.3 quick set up tutorial Read More »

Connecting Oracle SQL Developer to SAP ASE 16.0 (Sybase ASE 16.0)

Oracle SQL Developer has the functionality to not only Oracle databases. For MS SQL and SAP ASE (Sybase ASE) connections it uses the jTDS JDBC driver. Unfortunately the program refuses to work with ASE 16.0 even though the database is very similar to ASE 15.7. This article describes how to force the SQL Developer to

Connecting Oracle SQL Developer to SAP ASE 16.0 (Sybase ASE 16.0) Read More »

Oracle GoldenGate – using Unique Index instead of Primary Key

Oracle GoldenGate Replicat process requires somehow to identify replicated records. When an UPDATE or DELETE command is replicated the Replicat process needs somehow to identify the row that has to be modified. The obvious solution is to use a PRIMARY KEY on the target table to avoid scanning the whole table to find the row.

Oracle GoldenGate – using Unique Index instead of Primary Key Read More »

Preventing archive log deletion before being processed by Oracle GoldenGate

Oracle GoldenGate just like Oracle Streams has a mechanism of preventing archive logs from being deleted before they are processed. This mechanism is supported both in Classic and Integrated Extract mode. Although the latter one offers more functionality and control. This article brings in dept analysis what is happening in the database.

Preventing archive log deletion before being processed by Oracle GoldenGate Read More »

Oracle GoldenGate documentation WGET download scripts

The documentation for Oracle GoldenGate is a bit tricky to locate. Manuals for older versions of the software are hidden and after downloading the PDF files the file names are not very easy to use. I have created a series of Linux Bash scripts for WGET to download the documentation in PDF format and rename

Oracle GoldenGate documentation WGET download scripts Read More »

Oracle GoldenGate: What is ADD TRANDATA really doing?

In the process of data replication using Oracle GoldenGate the first step is assuring that all the needed information has been written to the database redo log. By default the database does not write all the information that might be needed by the replication process. That’s why some additional supplemental logging is needed. According to

Oracle GoldenGate: What is ADD TRANDATA really doing? Read More »