Infrastructure at your Service
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…
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…
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…
One question that comes often out working with Percona Monitoring and Management tool, is how to use LDAP to define users which can connect to the PMM web interface. Let’s see how to implement this kind of configuration.
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…
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…
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…
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…
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…
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…
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,…
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…
