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
Découvrez pourquoi Eclipsys a été nommée 2023 Best Workplaces in Technology, Great Place to Work® Canada et Canada's Top 100 SME !
En savoir plus !Recently, when I worked on upgrading ODA X7-2 S/M/L from version 12.2.1.4.0 to version 18.3.0.0.0. I hit two known issues after patching server components.
This blog will cover those two known issues and show how we can proactively handle them before upgrading ODA to 18.3.
To upgrade to Oracle Database Appliance Release 18.3, your deployment must be on Release 12.1.2.12 or later.
When you apply patches or re-image Oracle Database Appliance, the onboard public network interfaces may not come up due to faulty status presented in the ILOM and remote SSH access will not be available as a result.
You can proactively handle this issue before upgrading to 18.3 by upgrading server firmware to the version which contains the fix.
Solution:
1. Download firmware package 4.1 or later from here
In my case, I downloaded package version 1.5.1.
2) Copy package zip file to ODA node.
3) Unzip package file using root Unzip will create folder “Oracle_Server_X7-2-1.5.0.90261-FIRMWARE_PACK”
4) Change directory to “Oracle_Server_X7-2-1.5.0.90261-FIRMWARE_PACK/Firmware/Oracle-BASE-T-25Gb-lom”
[root@oak ~] # cd Oracle_Server_X7-2-1.5.0.90261-FIRMWARE_PACK/Firmware/Oracle-BASE-T-25Gb-lom
5) Clear all faults on the ilom from ILOM Web Console.
6) To update firmware, you need to install bnxtnvm tool. If you are running 12.2.1.4.0, the bnxtnvm tool is already included, and you do not need to install the rpm.
7) Update the firmware. For Bare Metal, the device names are em2 and em3.
[root@oak ~]# bnxtnvm install 20.08.01.18-57417-LOM.pkg -dev=em2
[root@oak ~]# bnxtnvm install 20.08.01.18-57417-LOM.pkg -dev=em3
8) Power Cycle ODA node.
Reference:
Description:
Workaround: there is no workaround. The issue will be recovered automatically, but it will take time depending on hardware types, disk capacity, size of ACFS volumes, and disk speed. You can monitor recovery progress by watching “Mirror recovery for” message as below.
# grep ‘Mirror recovery for’ /u01/app/grid/crsdata/$(hostname -s)/acfs/event.log.0
# tail -f /proc/oks/log | grep dirty
Note: Yon can’t continue with ODA storage and database home patching until the issue is resolved.
You can proactively avoid that issue by patching GI home before starting with ODA upgrade. In my case, ODA version was 12.2.1.4, so I applied path 29597701
After you apply above patch on GI home, you can start with ODA upgrade and you will NOT face that problem once server update finishes.
Reference:
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