How to Fix: The Selected Subscriber does not satisfy the minimum version compatibility

Problem: You are trying to add a new subscriber to a SQL Server Publication using the SQL Server Management Studio and you receive an error similar to the one below: “The selected Subscriber does not satisfy the minimum version compatibility…

Read More >

Exadata: 7 Useful Commands to check Port/Sensor Alarms

Some days ago I was checking for the alarm below, with a very generic message: Message=The aggregate sensor /SYS/CABLE_CONN_STAT has a fault. So, I decided to document some useful commands I used to verify all ports/sensors in my Exadata cluster….

Read More >

Minimal Networking Knowledge Recommended for DBAs

In a recent post, I summarized what I consider to be the minimal topics one should be familiar with in order to do technical work with databases.  One thing I left out, except for it being implicitly included in “Hardware…

Read More >

Pythian sponsors first Google DevFest Montreal 2019

Pythian would like to announce Diamond sponsorship of the first cloud and machine learning (ML) DevFest in Montreal, September 27th, at École de Technologie Supérieure (ÉTS). More details can be found on the website: https://devfest.cloud-montreal.ca/. DevFests are large-scale community-driven events…

Read More >

What to expect at ProxySQL Technology Day in Ghent

On October 3rd ProxySQL will have it’s very first technology day. They have chosen the lovely city of Ghent, Belgium, my home town, as the place to be. For those attending Percona Live Europe in Amsterdam, this is a great…

Read More >

How to execute 19c runcluvfy.sh with root and sudo method

One method to prepare for a Grid Infrastructure (GI) upgrade is to execute runclufy.sh (Cluster Verification Utility). Here, I will demonstrate how I executed runclufy.sh to verify the upgrade, as well as some issues that I encountered. The above is…

Read More >

How to fix InfiniBand Error: Cable is present on Port “X” but it is polling for peer port

Facing an InfiniBand error? Let me guess: Ports 03, 05, 06, 08, 09 and 12 are alerting? You have a Quarter Rack? Have recently installed Exadata plugin to version 12.1.0.3 or higher? Don’t panic! This is probably related to Bug 15937297:…

Read More >

How to get the most out of your EBS performance

A commonly encountered scenario is when EBS volumes are not performing at the expected theoretical performance. Let’s look at some of the potential reasons for that and how we can “fix” it. (When I say EBS volume, I am talking…

Read More >

Considerations for Converting from Oracle to Other RDBMS Platforms

Oracle software is known for being complex, expensive, and even cumbersome. However, while legacy database management systems (DBMS) like Oracle often hang around well past their best before date – in many cases due to corporate inertia and well-worn habit…

Read More >

Examining Teradata To Google BigQuery Migration

Cloud migration is hot nowadays. Enterprises are considering options to migrate on-premises data and applications to cloud (AWS/GCP/Azure) to get the benefits of quick deployments, pay-per-use models and flexibility. Recently, I got a chance to work on data migration from…

Read More >
Page 4 of 351« First Page...23456...10...Last Page »