Infrastructure at your Service

 
Karsten Lenz

The log_duration parameter in PostgreSQL

By | Database Administration & Monitoring | No Comments

log_duration is a useful point for finding slow running queries and to find performance issues also on the applications side using PostgreSQL as database. Another topic is finding issues with Java Applications using Hibernate after a migration to PostgreSQL. Often Hibernate switches from lazy to eager mode and this has massive impact on the application performance. In this context I will also describe one of the most useful extensions: pg_stat_statements. The log duration shown in…

Read More
Morgan Patou

Documentum – DARs installation fails Java 11

By | Application integration & Middleware, Entreprise content management | No Comments

As you probably heard if you weren’t in an underground bunker for the past 2 years, Oracle changed the licensing of the Oracle JDK. If you want to read more about it, there is a good FAQ here. This obviously had some important repercussions everywhere and Documentum wasn’t exempted. I would have a lot to say about the way OpenText tried to adapt since Documentum 16.4 (and kind of failed) but that’s not really the…

Read More
Furkan Suv

How to prepare for the SLES 15 Admin certification.

By | Operation systems | No Comments

My Background Since I started at dbi services sa (before 3 Weeks), I was working and preparing for the SUSE Linux Enterprise 15 certification. I had worked with other Linux distributions like CentOS, Ubuntu and Debian on my old employer. With my basic Linux knowledge I was able to administrate Apache and nginx with virtual hosts, SSL Encryption with Let’s Encrypt, installing and configuring MySQL Database, opening/closing ports for services with firewall-cmd, network configuration and…

Read More
Franck Pachot

The myth of NoSQL (vs. RDBMS) “joins dont scale”

By | AWS, Database Administration & Monitoring, NoSQL, Oracle, Postgres, SQL Server | 13 Comments

By Franck Pachot . I’ll reference Alex DeBrie article “SQL, NoSQL, and Scale: How DynamoDB scales where relational databases don’t“, especially the paragraph about “Why relational databases don’t scale”. But I want to make clear that my post here is not against this article, but against a very common myth that even precedes NoSQL databases. Actually, I’m taking this article as reference because the author, in his website and book, has really good points about…

Read More
Morgan Patou

Documentum Upgrade – Castor is locked!

By | Application integration & Middleware, Entreprise content management | No Comments

One of the best practices while doing upgrade of Documentum is to unlock the various repository objects before starting. This will make sure that if the upgrade process requires an update of some objects, then it will succeed and not cause you issues because you are missing some pieces. This also brings a second benefit: it means that if you ever see locked objects after the upgrade, then something probably went wrong somewhere.   In…

Read More
Franck Pachot

Oracle ACFS: “du” vs. “df” and “acfsutil info”

By | Oracle | No Comments

By Franck Pachot . This is a demo about Oracle ACFS snapshots, and how to understand the used and free space, as displayed by “df”, when there are modifications in the base parent or the snapshot children. The important concept to understand is that, when you take a snapshot, any modification to the child or parent will [[email protected] ~]$ asmcmd lsdg DATAC1 State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files…

Read More
Olivier Spiesser

Microsoft Teams, Power Automate and Planner

By | Database Administration & Monitoring | No Comments

As we moved to Teams at dbi and one of our customers, automating tasks was a strong need. One of the tasks that could be automated is the creation of tasks in Microsoft Planner which does not support recurring tasks. Every 4 weeks, we are patching the environment. For everyone awareness and follow up, we need to publish these dates in the planning. As the pace of these tasks is known, it is a bit…

Read More
Marc Wagner

POUG 2020 Workshop Day 1

By | Oracle | No Comments

I had the opportunity to participate to POUG day 1 and wanted through this blog to share some of my feedback on the interesting sessions I could follow. First of all, I would like to mention the great introduction done by the staff team and the great organization. POUG staff team could adapt to the coronavirus situation and organized excellent POUG virtual days. Well done!

Read More
Mouhamadou Diaw

Oracle Data Guard RedoRoutes : What is Priority 8 ?

By | Database Administration & Monitoring, Oracle | No Comments

When dealing with cascading or far sync in a Data Guard environment, it is important to understand how to configure the RedoRoutes property. By default, a primary database sends redo to each transport destination that is configured in the destination. We can create more complex transport topology, depending of our environment, using the RedoRoutes property. Basically the RedoRoutes property has this format (redo_routing_rule_1) [(redo_routing_rule_n)] Where each routing rule contains a redo source field and a…

Read More
Franck Pachot

Oracle Autonomous Linux: cron’d ksplice and yum updates

By | Cloud, Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . Oracle Enterprise Linux (OEL) is a Linux distribution which is binary compatible with Red Hat Enterprise Linux (RHEL). However, unlike RHEL, OEL is open source, free to download, free to use, free to distribute, free to update and gets free bug fixes. And there are more frequent updates in OEL than in CentOS, the free base of RHEL. You can pay a subscription for additional support and features (like Ksplice or…

Read More
Lazhar Felahi

Oracle GoldenGate 19c: Cannot register Integrated EXTRACT due to ORA-44004

By | Application integration & Middleware, Database Administration & Monitoring, Oracle | No Comments

The global_name in an oracle database has a direct impact on the Golden Gate Extract process registration we need to do when we create an Integrated Extract. In my example below, I use Oracle GoldenGate MicroServices architecture but the same behaviour occurs with Oracle GoldenGate Classic architecture.   Let’s start with the creation of the Extract process by clicking on the plus button :   Choose Integrated Extract and click on Next button: Fulfill all…

Read More