Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
With the integration of OMIS into dbi services we also got a new product: OMrun. OMrun is all about data, especially comparing, validating and anonymizing data from various sources against various targets. Most of that is done using plain SQL, so we get the full power of SQL for validating, comparing or anonymizing data. In this first introduction post we’ll…
by Alexandre Nestor In the previous article A step by step guide to install and configure OCI client the oci client configuration. OCI provides also token access. Note: The tenancy name can be found on the page “Tenancy details“ Let’s try out the OCI output suggestion: The $HOME/.config file was updated with the token and the session parameters are in…
As a DBA I used more and more the dbachecks at customer place to validate environments. It became part of our DBA toolkit at the same place than its famous brother the dbatools.My colleague Steven Naudet did a blog-post some weeks ago about it and today I will show you how is it possible to add your own checks if…
In my last blog we had a look on how to bootstrap a complete Patroni Cluster from pgBackRest. But there is also the possibility to recreate only one Patroni node using pgBackRest. In this blog we will have a look on all the things we need to change to recreate a node successfully from backup. First of all, let’s assume…
I recently patched ODAs X7-2-HA and X8-2-HA from version 19.8 to version 19.12 and then 19.16 at one of our customer environment. I faced some HDD firmware that was not patched during storage patching, and I had to manually patched them. Through this blog I wanted to share how I performed this, hoping that it might help you. All the…
In my last blog post I explained how to automatically download the last Service Pack and Cumulative Update for all versions of SQL Server.Here I will show you how to patch your SQL Server instances automatically with some cmdlets from the dbatools. First we need a SQL Credential to be able to remotely connect to the server where we will…
By Mouhamadou Diaw During a consulting on a customer, we faced the following issue when trying to delete a dbhome Message: DCS-10001:Internal error encountered: PRGO-2470 : Working copy “OraDB19000_home1” is involved in an incomplete move or upgrade operation The result of the job is shown below After researches on the net, we found following Oracle document ODA: Create-prepatchreport fails with…
Introduction One of the long requested features in case of Multitenant was the possibility to create and manage a data guard configuration on pdb level. Now with the Release Update 21.6 this was finaly implemented and the name of the new feature ist called DGPDB. If you want to know more about the data guard on pdb level and how…
Imagine the following use case: You have a table t1, and based on it’s contents you create another table t2. What you want to achieve is: If table t1 gets dropped, you want to have table t2 to be dropped automatically. Can you do something like this in PostgreSQL? Short answer is yes, you have several options here. Depending on…
Last week I had the pleasure to join the pgconf.eu in Berlin. After three years of waiting since Milan 2019, I was really excited to travel to Berlin to meet all the PostgresFriends again and of course meet a lot of new people. With a new visitor record of 604 participants, we started the conference in a great mood at…
Last week, the biggest European PostgreSQL event of the year took place in Berlin (2022.pgconf.eu). This event is an excellent opportunity to meet developers from the PostgreSQL community and to attend high profile tech presentations. Tuesday evening we started with the traditional “Schweizer Abend” Dinner with the Swiss community. We had a special guest at our table with Frits Hoogland…
Working with YaK core, we created a YaK component to deploy WebLogic Domains, Fusion Middleware Forms & Reports and Fusion Middleware ADF infrastructure. The idea is to be able to deploy such kind of infrastructure in different Clouds or on-Premise without any line change at component level. During the development phase I run in an issue I never saw before.…
