All articles

GoldenGate 12.2: ERROR: Unable to create a new wallet

Today I had a very strange issue when setting up a brand new GoldenGate 12.2 installation. Installation went fine, patch went fine (PSU 170221) and then I started to configure GoldenGate. One of the first commands we usually do is:(…)

Can I do it with PostgreSQL? – 11 – NLS_DATE_FORMAT

Following the last post about time zones this post is about the display and default format of date and time values. What people usually do to get a consistent display of date and time values in Oracle(…)

OUD – Oracle Unified Directory 11.1.2.3 Backups Tips and Tricks

By William Sescu Backing up an OUD consists of several components The OUD software itself The OUD back end data The OUD configuration The OUD logical export as a ldif file However, in this post I would like to take(…)

Can I do it with PostgreSQL? – 10 – Timezones

This post is inspired by a question we received from a customer: In Oracle there is the sessiontimezone which returns the time zone of the session. Asking for the time zone of the session in Oracle returns(…)

Vertically scale your PostgreSQL infrastructure with pgpool – 3 – Adding another standby

In the first and second post in this series we did the basic pgpool setup including the watchdog configuration and then did a simple setup for automatically failover from a PostgreSQL master instance in case it(…)

JAN17 Proactive Bundle Patch + Adaptive Statistics control

By Franck Pachot . If you have to create a new database now (I'm writing this in March 2017) for a migration of OLTP database with minimal risks of regression, I would recommend: The latest patchset of Oracle Database 12cR1(…)

Vertically scale your PostgreSQL infrastructure with pgpool – 2 – Automatic failover and reconfiguration

In the first post of this little series we did the basic setup of pgpool and configured the watchdog. So, as of now, pgpool uses a VIP which is active on one of the(…)

SQL Server 2016: Does Dynamic Data Masking works with INSERT INTO and SELECT INTO commands?

I wonder how works Dynamic Data Masking (DDM) with these two commands INSERT INTO  and SELECT INTO. First, I create a table and add some “sensitive data”: USE [DDM_TEST] GO CREATE TABLE [dbo].[Confidential]( [ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY(…)

Purging Unified Audit Trail in 12cR2

By Franck Pachot . A good thing from 12.2 is that the implementation of Unified Audit Trail has changed a little. It was stored in a weird CLI_SWP$ table but now we have a normal partitioned table named AUD$UNIFIED. In(…)

How many members for standby redo logs?

By Franck Pachot . I see lot of databases with two members for redo logs and also two members for standby redo logs. Why not, but when asking I realized that there are some mis-comprehension about it. And what was(…)