MySQL: Updating the Configuration of a MySQL DB System on OCI
Overview: A MySQL configuration is a collection of variables that define the operation of a MySQL DB system. It is analogous to ... Read More
Learn more about why Eclipsys has been named the 2023 Best Workplaces in Technology and Ontario, Certified as a Great Place to Work in Canada and named Canada’s Top SME Employer!
Learn more!There are two main questions you need to answer while planning your Exadata patching:
I’ll answer the above questions with the below scenario.
Exadata Database Machine Hardware | X6 |
Exadata Storage Server Software | 18.1.6.0.0.180529 |
Oracle Grid Infrastructure release | 18.2.0.0.180417 |
Oracle Databases releases | 12.1.0.2.180417, 12.2.0.1.180417 |
The objective is to patch Exadata components to the latest Exadata software release (July 2021 QFSDP as of writing this blog).
Exadata Storage Server Software | 21.2.2.0.0.210720 |
Oracle Grid Infrastructure release | 19.12.0.0.210720 |
Oracle Databases releases | 12.1.0.2.210720, 12.2.0.1.210720 |
1. What are the software versions that are compatible with the Exadata Database Machine Hardware version?
We can find the answer to that question in MOS Doc ID 888828.1. The Doc has a table that lists the software versions that are compatible with each supported Exadata Database Machine Hardware version.
The table above shows that X6 can run Exadata software 12.1.2.3.1 and higher. That means the latest Exadata Software (21.2.2.0.0) is supported on X6 Hardware.
2. What are the minimum Oracle Grid Infrastructure and Database Software releases that are certified with Exadata Storage Server Software?
Exadata software Supplemental Note answers this question.
Exadata software (21.2.2.0.0) Supplemental Note 2781458.1 lists the minimum Oracle Grid Infrastructure and Database Software releases supported by Exadata software 21.2.2.0.0.
The current GI release is 18.2.0.0.180417 and based on information from Supplemental Note 2781458.1 above, the minimum supported GI release is 18.7.0.0.190716.
The current GI release (18.2.0.0.180417) < the minimum supported GI release (18.7.0.0.190716).
The current DB releases (12.1.0.2.180417, 12.2.0.1.180417) < the minimum supported DB releases (12.1.0.2.180831, 12.2.0.1.181016).
So, it is mandatory to patch GI from 18.2 to 18.7 or the latest 18c GIRU and DB 12.1 and 12.2 homes to the minimum supported releases or the latest 12.1/12.2 RU before we can patch compute and cell nodes.
Note: we can NOT upgrade GI from 18c to 19c before patching compute and cell nodes to Exadata software 19, 20, or 21.
As a result, the patching and upgrade plan will be as follows:
My next blog will be on upgrading GI from 18c to 19c on Exadata.
Stay tuned!
Overview: A MySQL configuration is a collection of variables that define the operation of a MySQL DB system. It is analogous to ... Read More
Overview: Oracle 23c introduces the use of SUM and AVG functions with INTERVAL datatype This enhancement makes it easier to calculate totals and ... Read More