Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Daniel Westermann

GoldenGate 12.2: ERROR: Unable to create a new wallet

By | Database Administration & Monitoring | No Comments

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: GGSCI (xxxxx) 2> create wallet I really never had any issues with this, but today I got: GGSCI (psrdbap03n1) 2> create wallet ERROR: Unable to create a new wallet.  

 
Read More
Daniel Westermann

Can I do it with PostgreSQL? – 11 – NLS_DATE_FORMAT

By | Database Administration & Monitoring | No Comments

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 is to set NLS_DATE_FORMAT: SQL> show parameter nls_date_format; NAME TYPE VALUE ———————————— ———– —————————— nls_date_format string YYYY-MON-DD HH24:MI:SS SQL> alter session set nls_date_format=’DD.MM.YYYY HH24:MI:SS'; Session altered. SQL> select sysdate from dual; SYSDATE ——————- 29.03.2017 16:26:11 SQL> alter session…

 
Read More
William Sescu

OUD – Oracle Unified Directory 11.1.2.3 Backups Tips and Tricks

By | Database Administration & Monitoring | No Comments

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 a closer look at the back end data. Unlike the old OID, the OUD directory server uses the Berkeley DB Java Edition (JE) as its primary back end. The OUD backup command allows you to backup all back…

 
Read More
Daniel Westermann

Can I do it with PostgreSQL? – 10 – Timezones

By | Database Administration & Monitoring | No Comments

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 you the offset to the UTC time: SQL> select sessiontimezone from dual; SESSIONTIMEZONE ————————————————————————— +02:00 This is fine as I am based in Switzerland and we skipped one hour in the night from last Saturday to Sunday  

 
Read More
Daniel Westermann

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

By | Database Administration & Monitoring | No Comments

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 goes down for any reason. In addition we told pgpool how an old master instance can be reconfigured as a new standby instance that follows the new master. In this post we’ll add another standby instance and then teach…

 
Read More
Franck Pachot

JAN17 Proactive Bundle Patch + Adaptive Statistics control

By | Database Administration & Monitoring | 2 Comments

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 The latest Proactive Bundle Patch The two patches to get full control over Adaptive statistics This post gives more detail about it and which patches to apply. It would be nice to have those patches merged into each bundle…

 
Read More
Daniel Westermann

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

By | Database Administration & Monitoring | No Comments

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 pgpool nodes and failovers to the other node in case the node where the VIP currently runs on goes down for any reason. This provides the very same address for the application or clients to connect and eliminates the single point…

 
Read More
Stéphane Haby

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

By | Database Administration & Monitoring | No Comments

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 CLUSTERED, [Name] [nvarchar](70)NULL, [CreditCard] [nvarchar](16)NULL, [Salary] [int] NULL, [Email] [nvarchar](60)NULL) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’Stephane’,N’3546748598467584′,113459,N’sts@dbi-services.com’) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’David’,N’3546746598450989′,143576,’dab@dbi-services.com’) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’Nathan’,N’3890098321457893′,118900,’nac@dbi-services.com’) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’Olivier’,N’3564890234785612′,98000,’olt@dbi-services.com’) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’Alain’,N’9897436900989342′,85900,’ala@dbi-services.com’)…

 
Read More