All articles

Can I do it with PostgreSQL? – 13 – create database

Following the last post about which tools you can use to create your PostgreSQL instance in this post we'll look at how you can do the "create database" part that you would do in Oracle when not using(…)

Documentum – Increase the number of concurrent_sessions

In Documentum, there is a parameter named concurrent_sessions which basically defines how many sessions a Content Server can open simultaneously. This parameter is defined in the server.ini file (or server_<dm_server_config.object_name>.ini on a Remote Content Server) of each docbase and it(…)

Documentum – Wrong dfc versions after installation, upgrade or patch

If you are familiar with Documentum or if you already read some of my blogs, then you probably already know that EMC has sometimes issues with libraries. In a previous blog ((…)

Documentum – Thumbnail not working with TCS

A few months ago and right after a migration of around 0.5TB of documents, we enabled the TCS for one of our Application. We were using a Content Server 7.2 P05 with the associated D2 4.5 P03. As already mentioned(…)

Can I do it with PostgreSQL? – 12 – dbca (database configuration assistant)

Short answer: No. Long answer: No. Every other possible answer: No. There is no such tool in PostgreSQL. In Oracle you can use the database configuration assistant to create your Oracle database. But this is not a must,(…)

SQL Server on Linux and experimental Flexible Architecture

In this blog post let’s talk a little bit about SQL Server optimal installation on the Linux file system. This is probably one of the first considerations we will have as a database administrator. Actually basic installation of SQL Server(…)

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(…)