Infrastructure at your Service

Category

Database Administration & Monitoring

Jérôme Dubar

Patching or reimaging your ODA?

By | Database Administration & Monitoring, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction One of the key features of the ODA (Oracle Database Appliance) is the ability to patch the entire stack every three months, the goal being to keep all the components up-to-date. Most of the customers won’t patch so often, but one patch a year is quite a good average. But when comes the time for patching, comes the time for anxiety for the DBA. And it’s totally justified. Why ODA patching can eventually be…

Read More
Daniel Westermann

EDB EPAS 12 comes with interval partitioning

By | Database Administration & Monitoring | No Comments

While community PostgreSQL 12 is in beta quite some time now (currently in beta 3) it usually takes some time until EDB EPAS will be available on top of the next major PostgreSQL release. Yesterday EDB finally released a beta and you can register for access here, release notes here. One of the new features is interval partitioning which you already might know from Oracle. Basically you do not need to create range partitions in…

Read More
Pierre-Yves Brehier

Feedback on the EMEA Red Hat Partner Conference 2019 in Prague

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

A few weeks ago I attended the Red Hat EMEA Partner Conference for the first time. The Red Hat Conference took place in Prague from June 25th to 27th. If you are interested in Open Source technologies and in Red Hat, feel free to read this personal feedback on trends at Red Hat and in the IT sector.

Read More
Nicolas Penot

Sparse OVM virtual disks on appliances

By | Database Administration & Monitoring | No Comments

For some reason, you may need to sparse OVM virtual disks in an Oracle appliances. Even though that feature is present trough the OVM Manager, most of the Oracle appliances doesn’t have any OVM Manager deployed on it. Therefore if you un-sparse your virtual disk by mistake, you are on your own. This is a note on how to sparse virtual disks which are un-sparse. Stop I/Os on the virtual disk First, ensure the VM…

Read More
Nicolas Penot

Red Hat 8 Server in 9 minutes into the Google Cloud

By | Database Administration & Monitoring | No Comments

Do you have 9 minutes to learn how to quick start with the Google Cloud? Here is a simple copy/past procedure to successfully deploy a Red Hat 8 compute server into the Cloud. Installation of the Google command client Download first the client and uncompress it: $ curl -O https://dl.google.com/dl/cloudsdk/channels/rapid/downloads/google-cloud-sdk-255.0.0-linux-x86_64.tar.gz $ tar zxvf google-cloud-sdk-255.0.0-linux-x86_64.tar.gz Optionally configure the PATH for your comfort: $ ./google-cloud-sdk/install.sh That command will connect your local environment with your cloud. Just follow…

Read More
Mouhamadou Diaw

dbvisit 9: Automatic Failover

By | Database Administration & Monitoring | 2 Comments

dbvisit 9 is released since a few months. And one new feature I tested is the Automatic Failover. In this blog I suppose that dbvisit 9 is already installed and that the standby database is already created. Indeed I will not describe nor dbvisit installation neither the standby creation as it is the same as the previous versions. For more info about dbvisit installation and/or dbvisit standby creation please see these steps in my previous…

Read More
David Barbarin

Deploying SQL Server 2019 container on RHEL 8 with podman

By | Database Administration & Monitoring, DevOps, Docker, SQL Server | No Comments

Having a fresh install of RHEL8 on my lab environment, I was curious to take a look at new containerization stuff from Red Hat in the context of SQL Server 2019. Good chances are the future version of SQL Server should be available and supported on with the latest version of Red Hat but for now this blog post is purely experimental. This time I wanted to share with you some thoughts about the new…

Read More
Mehdi Bada

Kubernetes – How to install a single master cluster with kubeadm?

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

To bootstrap a minimal K8S cluster for testing purpose, kubeadm is a very interesting tool. The goal of this blog is not to explain to you the K8S architecture or the components but only the deployment part. using kubeadm. The final architecture of our cluster will be the following: Source:https://elastisys.com/2018/01/25/setting-highly-available-kubernetes-clusters/ Docker Installation The first step is to install Docker on each cluster node: yum install yum-utils device-mapper-persistent-data lvm2 yum-config-manager \ –add-repo \ https://download.docker.com/linux/centos/docker-ce.repo yum update…

Read More
David Barbarin

SQL Server 2019 availability group R/W connection redirection, routing mesh and load balancing

By | Database Administration & Monitoring, SQL Server | No Comments

SQL Server 2019 availability group feature will provide secondary to primary replica read/write connection redirection. I wrote about it in a previous blog post here. It consists in redirecting client application connections to the primary replica regardless of the target server specified in the connections string. That’s pretty interesting in some scenarios as read scale-out or specific multi-subnet configurations where creating the traditional AG listener is not an viable option. The new R/W connection redirection…

Read More
Pierre Sicot

ORA-01000 and agent13c

By | Database Administration & Monitoring, Oracle | No Comments

Recently I received errors messages from OEM13c saying too many cursors were opened in a database: instance_throughput:ORA-01000: maximum open cursors exceeded My database had currently this open_cursors value: SQL> show parameter open_cursors NAME TYPE VALUE ———————————— ———– —————————— open_cursors integer 300 I decided to increase its value to 800: SQL> alter system set open_cursors=800; System altered. But a few minutes later I received again the same message. I decided to have a more precise look…

Read More