Infrastructure at your Service

 
Daniel Westermann

PostgreSQL 15: Add row filters for logical replication

By | Database Administration & Monitoring | No Comments

My last post about logical replication in PostgreSQL was in 2017 before PostgreSQL 10 was released later that year. There have been many enhancements to logical replication since then and today we’ll look at a new features that will probably come with PostgreSQL 15 later this year: Allow specifying row filters for logical replication of tables. What is it about? Up until today you can only replicate whole tables to a subscriber node. It is…

Read More
Jérôme Dubar

ODA: Migrating from bare metal to CPU pools

By | Database Administration & Monitoring, Database management, Development & Performance, Oracle | 2 Comments

Introduction Oracle Database Appliance now fully supports virtualization with KVM, and this could be interesting for some of us. If you’re using Enterprise Edition, you probably decreased the number of cores to comply with your licences. Now you can increase your core configuration with more cores, some being dedicated to your databases, and some for user-managed VMs. Let’s find out how you can migrate from bare-metal core allocation to CPU pools and discover the possibilities…

Read More
Mouhamadou Diaw

Pluggable Database Snapshots with Oracle 21c

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

In a previous blog , I talked about refreshable PDB technology which can be used to refresh a target PDB. The target PDB can be in mounted state (mandatory to be refreshed) or can be opened in a read only mode. One application is to use the target refreshable PDB as a master to provide PDB snapshots. A PDB snapshot is copy of a PDB at a given time. The source PDB can be open…

Read More
Marc Wagner

Snapshot solutions with Oracle Standard Edition SE2

By | Oracle | No Comments

Would you like to quickly provide your engineering team with a real production environment database with updated data to develop new features? Does your operational team need a copy of the production database to test a new release or a new patch? “Easy” would you say. “Let’s do a clone and duplicate the production database with RMAN!”. Yes, but would you take the same direction if your production database size makes more than a few…

Read More
Mamy Rasoanaivo

How to use the licensing Control-M reporting tool

By | Control-M | No Comments

BMC Software requests yearly a licencing report of the usage of Control-M at the customer site, for that they send you a request to generate a report by using a Usage Reporting Tool provided by them and send back the the generated Report. When I tried to use the tool, I encountered an issue (java), I was using the version 9.0.19.200, therefore if you are facing with the same issue, I will explain you here…

Read More
Marc Wagner

Separating database traffic on an ODA

By | Oracle | One Comment

I recently wrote a blog on how to separate database traffic on an ODA using KVM Database Systems on different VLAN : Creating KVM Database System on separate VLAN network on ODA As we could see there is pros and cons. Another way would be to have the database created on the Bare Metal itself and using listeners running on individual network interfaces. Let’s try this! Of course this solution is more suitable for Standard…

Read More
Morgan Patou

Alfresco – Removing JMX settings via the AttributeService since the Revert doesn’t work

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

At a customer, I recently faced a problem with the JMX settings that couldn’t be reverted. If you already worked with Alfresco, you know that it’s possible to save configurations through the Alfresco Administration Console and that doing so will store these settings into the Database. This has several drawbacks like the fact that it’s then impossible to manage your Alfresco through its configuration files since the DB settings will always take precedence and that…

Read More
Morgan Patou

WebLogic – No more SSO after a SSL Certificate renewal?

By | Application integration & Middleware | No Comments

I had an interesting case at a customer where the Single Sign On (using SAML2) on a WebLogic Server stopped working after the renewal of the WebLogic SSL Certificate. The WebLogic Server itself and its applications were still accessible (by bypassing the SSO) and working fine but not the SSO itself. That’s definitively a strange behavior and not something I would expect to see broken after just changing a certificate that has, apparently, no link…

Read More
Nathan Courtine

Access Check Results entries too large, resulting in a memory pressure

By | Database Administration & Monitoring | No Comments

As part of a MSSQL consolidation project, with application servers located in one domain and the databases in another, we received an alert indicating that some databases were not available. After starting the investigation, we discovered that the Availability Group (AAG), to which these databases belong, was temporary taken in RESOLVING_NORMAL: The state of the local availability replica in availability group ‘xxxxxxxx has changed from ‘PRIMARY_NORMAL’ to ‘RESOLVING_NORMAL’. The state changed because the lease between…

Read More
Karsten Lenz

Migration from CentOS 8 to Rocky Linux 8

By | Database Administration & Monitoring | No Comments

This Blog describes the Migration from CentOS 8 to Rocky Linux 8. And hopefully there is a backup or VM Snapshot in place when something goes wrong. At first Updating CentOS 8 to the latest is required, but this is now not so easy, most Repositiory Mirrors are deprecated. As Preparation an adaptation of the CentOS Repo files is needed to get this task done. In this case the following repo files where in place,…

Read More
Clemens Bleile

Oracle Database Appliance: Install a DB Release Update manually

By | Oracle | No Comments

By Clemens Bleile Recently I upgraded an ODA X7-M from 19.12. to 19.13. After the dcs-, server- and storage-upgrade several databases on the machine had to be patched from 19.9. to 19.13. The [[email protected]<node> ~]# odacli create-prepatchreport –dbhome –dbhomeid <home-id> -v 19.13.0.0.0 went through without reporting an issue, but during the [[email protected]<node> ~]# odacli update-dhome -i <home-id> -v 19.13.0.0.0 -f I got an error “DCS-10001:Internal error encountered: null.”: [[email protected]<node> ~]# odacli describe-job -i “<Job-Id>” Job…

Read More