All articles

Deploying SQL Server 2019 AGs on K8s with helm charts

This write-up follows my first article about helm chart with SQL Server. This time, I would like to cover the availability groups topic and how to deploy them with helm charts. In fact, to go(…)

Documentum CS 7.* – 777 permission on jobs log

A few weeks ago at a customer, our team was involved in a security control. We tracked files with 777 permission and we detected that logs generated by Documentum jobs have 777 permissions.

Copy or Migrate a SSISDB environment

Integration catalog is easy to work with and the environments feature is as well very convenient. In SQL Server management Studio, there are a lot of features available to administrate(…)

Compile additional packages for Oracle VM Server

I needed a special package on my OVM Server 3.4.6. The package is called fio and is needed to do some I/O performance tests. Unfortunately, OVM Server does not provide any package for compiling software and installing additional software(…)

PostgreSQL 12, pg_stat_statements_reset for userid, queryid and dbid

PostgreSQL 12 will give you more control on resetting statistics gathered by pg_stat_statements. When you check the documentation for PostgreSQL 11 (as linked in the previous sentence) you will see that the function has the following(…)

Documentum Rest API

Introduction Nowadays, restful APIs are used in any product, almost. In the era of web services, it is normal to have the same for documentum. In this blog I’ll show you a part of this API for documentum, how to(…)

Documentum 7+ internal error during installation or upgrade DBTestResult7092863812136784595.tmp

This blog will go straight to the topic. When upgrading/installing your content server to 7+, you may experience an internal error with a popup telling you to look into a file called something like: DBTestResult7092863812136784595.tmp In fact, the installation process(…)

How to build a dummy resource plan

Often switching off resource plan feature of Oracle database is desired. Unfortunately setting parameter RESOURCE_MANAGER_PLAN to empty string does not help, because it does not disable switching to another resource plan, e.g. with dbms_scheduler. Following procedure prevents this switching.

Using Ansible to bring up a three node Patroni cluster in minutes

Automation is key today, nobody wants to do the same tasks over and over and again. Cloud without automation is not even possible. There are several tools around that help with automation and one of the most popular is(…)

ODA: The Patch version must be 12.2.1.4.0

When trying to patch your virtualized ODA with patch 12.1.2.12.0 and immediately after that with 12.2.1.4.0, you might consider to load the patches like this: [root@XX1 Oracle_Soft_Repo]# oakcli unpack -package /cloudfs/Oracle_Soft_Repo/p26433712_1212120_Linux-x86-64_1of2.zip Unpacking will take some time, Please(…)