Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Jérôme Dubar

ODA : Free up space on local filesystems

By | Database Administration & Monitoring, Oracle | No Comments

Introduction When you work on ODA you sometimes get struggled with local filesystem free space. ODA has terabytes of space on data disks, but local disks are still limited to a raid-1 array of 2x 480GB disks. And only few GB are dedicated to / and /u01 filesystems. You do not need hundreds of GB on these filesystems, but I think that you prefer to keep at least 20-30% of free space. And if you…

Read More
Mouhamadou Diaw

PAM Authentication With PostgreSQL

By | Database Administration & Monitoring, Postgres | No Comments

PostgreSQl supports many authentication methods. The PAM authentication method operates similarly to password except that it uses PAM (Pluggable Authentication Modules) as the authentication mechanism. The user must exist in the database before PAM can be used for authentication. In this blog I will configure PAM authentication for a PostgreSQL cluster 11 running on a centos 7. postgres=# select version(); version ——————————————————————————– ————————- PostgreSQL 11.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (R ed…

Read More
David Barbarin

Deploying SQL Server on K8s with Helm charts

By | Database Administration & Monitoring, DevOps, Docker, Kubernetes | No Comments

During the last DockerCon EU in Barcelona, I heard a lot about Helm with K8s architectures. It was also a good opportunity to write about it after attending to this conference. In a nutshell, Helm is a package manager for K8s and you may think of it like the other ones available on the Linux side with apt, yum or zypper to cite few of them. Helm charts are a key component of the Helm architecture and…

Read More
Nathan Courtine

Transparent Data Encryption – Certificate in master database: is it really a good practice?

By | Database Administration & Monitoring | No Comments

As encryption solution in SQL Server, Transparent Data Encryption (TDE) is simple and quick to set up. That’s why this is a common encryption mechanism. TDE encrypts data with a certificate at the page level, before SQL Server writes on the disk. It is supposed to protect your environment from some scenarios, where SQL Server files (backups or data) are stolen. By default the certificate used for encryption is stored in the master database. But…

Read More
Pierre Sicot

Foglight

By | Database Administration & Monitoring | No Comments

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 we always have to be curious and discover new products. As described by my colleague Nicolas Penot, I installed Foglight: https://blog.dbi-services.com/foglight-monitoring-solution-for-databases-part-01/ https://blog.dbi-services.com/foglight-monitoring-solution-for-databases-part-02/ The installation was successful and very quick to realize, remember when you have…

Read More
Mouhamadou Diaw

PostgreSQL : Get my database server name

By | Database Administration & Monitoring | No Comments

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 can allow to get the database server host name. In this this blog I am explaining how to install and how to use it. The installation is very easy. The first step is to download it here . After…

Read More
Mouhamadou Diaw

PostgreSQL 12 : New option –socketdir for pg_upgrade

By | Database Administration & Monitoring, Postgres | No Comments

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 found that there is a new parameter for pg_upgrade. This new parameter is –socketdir. Why this parameter? In fact the path name of a UNIX socket is allowed to be maximally 108 chars long. Before PostgreSQL 12, the default directory for the sockets…

Read More
Joël Cattin

OEM Cloud Control 13c – Agent Gold Image

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

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 also have to install 3 Oracle Homes and one Cloud Control Agent 13c. An OMS13c server already exists including an Agent patched with the EM-AGENT Bundle Patch 13.2.0.0.181031 (28680866) : oracle@oms13c:/home/oracle/ [agent13c] opatch lsinventory |…

Read More
Thomas Rein

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

By | Database Administration & Monitoring, Oracle | No Comments

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 shares the Oracle Homes, he wants to create a 11.2.0.4 database: [root@robucnoroda020 ~]# odacli list-dbhomes ID Name DB Version Home Location Status —————————————- ——————– —————————————- ——————————————— ———- 157bfdf4-4430-4fb1-878e-2fb803ee54bd OraDB11204_home1 11.2.0.4.180417 (27441052, 27338049) /u01/app/oracle/product/11.2.0.4/dbhome_1 Configured 2aaba0e6-4482-4c9f-8d98-4a9d72fdb96e…

Read More