Database Administration & Monitoring

Open source monitoring solutions (1) – Zabbix server setup

We are often asked which monitoring solution we recommend for PostgreSQL, by people attending our PostgreSQL workshops. We usually answer: What do you have in place already? If a solution already is in place, the most obvious(…)

ODA 19.12: How can you manage DB Systems with odacli?

Introduction As virtualization is available for all ODAs now, you could ask yourself if it’s a good idea to use this virtualization or not. Databases can be created as bare metal, but also within a DB System for better isolation.

Dbvisit 10 on Oracle Database Appliance

By Mouhamadou Diaw Dbvisit Standby can also be installed on Oracle Database Appliance (ODA). The installation is the same that on any other Linux box. I did an install of Dbvist 10 on an ODA 19.12 for a customer and(…)

SQL Server – Granting SQL Server permission to service SID

Introduction We know that SQL Server itself is using it own SID NT SERVICEMSSQL$ and NT SERVICESQLAGENT$ to grant permission to the database engine and the SQL agent services. But the same method can be used for other application(…)

Control-M/EM Add a suffix to your jobs using mass update utility

Hi guys,and girls of course 😉 Sometimes we have to make some cleanup on our Control-m folders and also we have to keep them disabled (we never know if one day the can be used again by a new agent)(…)

Switching from CentOS 8 to Red Hat 8

We have quite a few customers still running on CentOS 8 and you probably already are aware that CentOS 8 will be end of life by the end of this year. This forces a(…)

Install Enterprise Manager 13c R5: Check the db edition Failed

By Mouhamadou Diaw A few days ago, I was setting an Enterprise Manager 13c R5 for a client. The configuration used is the following -The EM binaries are installed in a separate server than the database -The database(…)

Improve Oracle Insert Performance with BULKCOLLECT and FORALL

As specified by Steven Feuerstein into the Oracle Blog Website the bulk processing features of PL/SQL are designed specifically to reduce the number of context switches required to communicate from the PL/SQL engine to the SQL engine. Using BULK(…)

DataPump and the Transform option – Not very well known, but it can be useful

I work with Oracle Databases and Datapump for more than 10 years but still I find some datapump options that I did know and in some cases can be very helpful. For a customer we did a migration of(…)

Using pgBackRest to backup your PostgreSQL instances to a s3 compatible storage

When it comes to backup and restore of PostgreSQL we usually recommend pgBackRest to our customers. This tool comes with many options and features and should bring everything you need. Most of the times we install a(…)