Upgrading GoldenGate when the source is DB2 for z/OS is not quite the same exercise as upgrading a GoldenGate installation for Oracle. Most of what I described in my generic blogs about planning a GoldenGate upgrade and migrating from Classic to Microservices Architecture is still valid. However, there is an extra layer to deal with. It has to do with…
While upgrading GoldenGate to 26ai for a DB2 z/OS source, I had to update the IBM Data Server Driver for ODBC and CLI (CLI Driver, in short) alongside it. Since I realized that DB2 driver know-how was rare in companies, I figured it would be worth writing a blog about the topic. In this GoldenGate upgrade, the previous driver was…
Introduction The arrival of SQL Server 2025 introduces the Standard Developer edition, allowing companies to deploy across all development, quality and testing environments using an edition equivalent to the Standard Edition without having to pay the associated licensing fees. Here are the different editions available in SQL Server 2025: What problem does this solve? Some companies deploy the Developer edition…
Introduction If you use Enterprise Edition on your Oracle Database Appliance environment, and if you don’t have unlimited licences, you probably lowered the CPU cores available on each server to dispatch your licences accross your environment. This operation is normally done after deploying your ODAs, and this number of cores could eventually be increased if you need more and if…
By Franck Pachot . Note that I’ve written previously about Oracle Standard Edition 2 licensing before but a few rules change. This is written in May 2020. TL;DR: 4 vCPU count for 1 socket and 2 sockets count for 1 server wherever hyper-threading is enabled or not. The SE2 rules I think the Standard Edition rules are quite clear now:…
By Franck Pachot . On Twitter, Ludovico Caldara mentioned the #licensing #pitfall when using the Online Partition Move with Basic Compression. Those two features are available in Enterprise Edition without additional option, but when used together (moving online a compressed partition) they enable the usage of Advance Compression Option: https://twitter.com/njesp/status/1251961678020960257?s=20 And there was a qustion about detection of this feature.…
By Franck Pachot . When you clone a PDB on the primary CDB, you want that the same is automatically done on the standby ones. Unfortunately, for this operation, the CDB must be opened read-only. In 12.1 even the PDB needed to be opened read-only (Ludovico Caldara reported this in his blog). This, as far as I know, was fixed…
By Franck Pachot . Remember the times when the Oracle Software features were the same on all platforms? Where Oracle databases could be ported to any relevant platform? Where we were able to try any feature, freely, by downloading the latest release software? Now we need to think differently. Because: The new software is released on Cloud first The major…
In 2015 I wrote a blog named “All you need to know about Oracle Database licensing with VMware”. This blog generated lots of comments and hopefully helped some DBAs and IT Managers understanding the potential issues that they can face in case of Oracle LMS Audit. In 2 years I made some new experiences related to Oracle LMS audit and…
By Franck Pachot . Oracle Database licensing can be based on two metrics: Processor or Named User Plus (NUP). NUP also necessitate to count the processors because there is a minimum number of NUP per processor. Then it is very important to know how to count processors. The time where a machine had 1 socket with 1 processor with 1…
By Franck Pachot . This post is not about technical limitations: Oracle Database is supported in most hypervisors (certified or not) so anybody can provide a DBaaS through a virtual machine as long as it run a supported OS, has enough CPU, memory, and storage, and open the required ports to access to the database (ssh and listener). But you…
By Franck Pachot . Matching the Feature Usage Statistics to licensed options is not always easy. And once a feature usage is recorded, it is usually stored definitively. Let’s see how the multitenant option is recorded there. exec_db_usage_sampling I have a single-tenant database with only one user pluggable database: 16:19:20 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———-…
