Infrastructure at your Service

 
Cesare Cervini

Installing the ODBC drivers for PostgreSQL

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes SQLite, MariaDB, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). The postgresql drivers can be installed from the platform’s default package repositories using the following…

Read More
Cesare Cervini

Installing the ODBC Driver Manager with SQLite on Linux

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes Firebird, Postgresql, Microsoft SQLServer, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Excepting the present part which deals with the ODBC Driver manager’s installation which is a prerequisite, each part can be used independently from the others. The test system is a debian v11 (bullseye). Installation…

Read More
Mouhamadou Diaw

Oracle 21C Security : diagnostics_control and enable diagnostics

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

Some debug-events and debug-actions are not safe and should be exposed to users with caution. In previous releases, privilege control for the usage of these diagnostics was not sufficient. With Oracle 21c, regular users can be blocked from using these diagnostics to better support separation of duty. Indeed with Oracle 21c, we have a new mechanism to control the debug-events and debug-actions through ALTER SESSION and/or ALTER SYSTEM. This mechanism is implemented by two new…

Read More
Karsten Lenz

PostgreSQL Flexible Server on Azure, Status

By | Database management, Development & Performance, Postgres | No Comments

This Blog is about the actual status of the development on Microsoft’s side for the Azure Flexible Server for PostgreSQL. The Flexible Server is announced “GA Ready” at November 30st, after shiftig the GA Raeady date several times. But there are still some open requirements which are “Post GA”. 1. AD Integration => Post GA, promissed Q2 2022. 2. Customer managed Keys => Post GA, promissed Q2 2022. According to the latency of 6 month…

Read More
Morgan Patou

Documentum – Applying Content-Security-Policy (CSP) on D2 while using WSCTF plugin

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

If you have ever been working on a sensitive Documentum environment (they are all sensitive, are they not?!), you might already have worked on hardening your Web Servers. One of these aspects is to have a specific set of HTTP Security Headers. In this blog, I will talk about one in particular, which is the Content-Security-Policy (CSP).   The recommendations are usually to setup a set of headers. Here is an example of header names…

Read More
Morgan Patou

Alfresco – Documents are searchable only after 3min

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

I had a case at a customer recently where newly uploaded documents into Alfresco would always be searchable but only after 2min45s to 3min. The environment in question is an Alfresco Content Services 7.1 with High Availability (Repository and Share Clustering, Solr Sharding on multi-nodes, …) used for QA/TEST. It’s an ongoing project to upgrade an Alfresco 6.1 to 7.1 and during the testing, the documents take time to be visible through searches, everything else…

Read More
Nicolas Jardot

AWS CLI tips and tricks

By | AWS, Cloud | No Comments

When working with AWS, I would not advice to run all operations through the AWS Console. And it’s not always possible or easy to do it only with pipelines and Infrastructure as Code. Sometimes, we just need to perform the same operations on many instances or we already have an automation based on a script. In those situations, AWS CLI (the command line) can be very handy. I had the chance recently to attend a…

Read More
Clemens Bleile

opatch hangs while patching OEM 13.4. concerning the log4j-vulnerability

By | Oracle | No Comments

By Clemens Bleile To address the log4j-vulnerability I recently had to fix the Oracle Enterprise Manager 13.4.-installation for a customer. REMARK: Please check the following link for details concerning the log4j-vulnerability and how Oracle is affected: alert-cve-2021-44228 and the following MOS Notes: – Impact of December 2021 Apache Log4j Vulnerabilities on Oracle Products and Services (CVE-2021-44228, CVE-2021-45046) (Doc ID 2827611.1) – Impact of December 2021 Apache Log4j Vulnerabilities on Oracle on-premises products (CVE-2021-44228, CVE-2021-45046) (Doc…

Read More
Clemens Bleile

Script to calculate the network latency between the application and the Oracle DB-server

By | Oracle | 2 Comments

By Clemens Bleile Network latency is crucial for applications, especially if lots of “row by row”-processing (some call it “slow by slow”-processing) is used by the application or if lots of data is transported between the database and the application. If there’s lots of data to be transported between the database and the application then increasing the fetchsize may help to improve the performance and throughput. But this is not the aim of this blog….

Read More
Lazhar Felahi

Parallelize your Oracle INSERT with DBMS_PARALLEL_EXECUTE

By | Database Administration & Monitoring | No Comments

One of the challenge of all PL/SQL developers is to simulate the Production activity in a Non Prod. environment like for example different Insert executed by several sessions. Different tools exist like Oracle RAT (Real Application Testing) but under license or you can create your own PL/SQL package using DBMS_SCHEDULER or DBMS_PARALLEL_EXECUTE packages. The aim of this blog is to show you how to use DBMS_PARALLEL_EXECUTE to parallelize several INSERTS commands through different sessions. My…

Read More