Database Administration & Monitoring

Foglight

As many Oracle Database Administrators, I am a regular user of Oracle Enterprise Manager in order to monitor or administer my client’s databases. I am lucky because most of them have the diagnostic pack and the tuning pack :=). But(…)

PostgreSQL : Get my database server name

By Mouhamadou Diaw I was looking for a build-in function to get the hostname of the server hosting my PostgreSQL cluster. But seems that there is no build-in function. Looking in the extensions, I find the extension hostname which(…)

PostgreSQL 12 : New option –socketdir for pg_upgrade

By Mouhamadou Diaw PostgreSQL 12 is under development but tests can be done. Steps to install this version can be found in this dbi blog . Many thanks to Daniel. While reading the documentation I(…)

OEM Cloud Control 13c – Agent Gold Image

Introduction I am currently setting up a new “Base Image” virtual machine (Red Hat Enterprise Linux 7.6) which will be used to create 6 brand new Oracle database servers requested by a customer. Besides installing and configuring the OS, I(…)

odacli create-database fails on ODA X7-2HA with java.lang.OutOfMemoryError

Today I was onsite at my customer and he told me: I can no longer create databases on my ODA X7-2HA, every time I try to use odacli create-database it fails, please help. Ok, let’s check what happens, the customer(…)

Oooooops or how to undelete a file on an ext4 filesystem

It happens within the blink of an eye. A delete command was executed and half a second after you hit the enter button you knew it. That was a mistake. This is the scenario which leads to this blog entry(…)

OEM 13c Repository view gc$metric_values_daily

Oracle OEM 13c offers the possibility to generate reports about Oracle Database Tablespace Monthly Space Usage. The displayed information is quite useful and display a lot of information:     The report displays the details for(…)

PostgreSQL 12: csv output format for psql

Getting data out of PostgreSQL in csv format is not a big issue. Using copy you can do that easily. PostgreSQL 12 will enhance psql so that you can directly return csv formatted output from a(…)

PostgreSQL 12: log_statement_sample_rate

A common way to identify long running queries in PostgreSQL is to set log_min_duration_statement to a value that is known to cause troubles. In other words: If you know most of your statements usually execute in(…)

Extend a Oracle Access Manager 12.2.1.3 with User Messaging Service

After upgrading a Oracle Access Manager from 11.1.2.3 to 12.2.1.3, one of my customer requested from me to configure the Forget Password feature. This feature requires the User Messaging Service that was part of the SOA software in previous versions.