Oracle Linux 8: Block Device Names changing

Today I went to start a db on my Oracle Linux 8 server and had this error:

SQL> startup
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux-x86_64 Error: 2: No such file or directory
SQL>  

Checking the database filesystem, I see the contents are from /boot:

[root@ol8_23ai ~]# ls -tlr /u02/database | tail -4
-rw-------. 1 root root  51459694 Aug  8 20:15 initramfs-4.18.0-513.24.1.el8_9.x86_64.img
-rw-------. 1 root root  53236817 Aug  8 23:25 initramfs-5.15.0-205.149.5.1.el8uek.x86_64.img
-rw-------. 1 root root  28533760 Nov 11 15:44 initramfs-5.15.0-205.149.5.1.el8uek.x86_64kdump.img
drwx------. 4 root root       140 Nov 11 15:47 grub2
[root@ol8_23ai ~]#

vs:

[root@ol8_23ai ~]# ls -ltr /boot/ | tail -4
-rw-------. 1 root root  51459694 Aug  8 20:15 initramfs-4.18.0-513.24.1.el8_9.x86_64.img
-rw-------. 1 root root  53236817 Aug  8 23:25 initramfs-5.15.0-205.149.5.1.el8uek.x86_64.img
-rw-------. 1 root root  28533760 Nov 11 15:44 initramfs-5.15.0-205.149.5.1.el8uek.x86_64kdump.img
drwx------. 4 root root       140 Nov 11 15:47 grub2
[root@ol8_23ai ~]#

What is happening??

[root@ol8_23ai ~]# lsblk
NAME        MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sda           8:0    0  150G  0 disk
├─sda1        8:1    0    1G  0 part /boot
└─sda2        8:2    0  149G  0 part
  ├─ol-root 252:0    0   70G  0 lvm  /
  ├─ol-swap 252:1    0  9.9G  0 lvm  [SWAP]
  └─ol-home 252:2    0 69.1G  0 lvm  /home
sdb           8:16   0  100G  0 disk
└─sdb1        8:17   0  100G  0 part   <<--- Naming changed!
sr0          11:0    1   51M  0 rom
[root@ol8_23ai ~]#

[root@ol8_23ai ~]# grep -i database /etc/fstab
/dev/sda1              /u02/database            xfs
[root@ol8_23ai ~]#

This behavior matches “Oracle Linux: Kernel Block Device Names changing, Order Became Non-deterministic (Doc ID 2899803.1)” so I did:

[root@ol8_23ai ~]# blkid | grep sdb1
/dev/sdb1: UUID="b121e80a-534f-4069-9b70-431c6701a4b9" BLOCK_SIZE="512" TYPE="xfs" PARTUUID="f030e35a-01"
[root@ol8_23ai ~]#

replaced fstab with:

[root@ol8_23ai ~]# grep -i database /etc/fstab
UUID="b121e80a-534f-4069-9b70-431c6701a4b9"  /u02/database            xfs
[root@ol8_23ai ~]#

and re-mount:

[root@ol8_23ai ~]# systemctl daemon-reload
[root@ol8_23ai ~]# umount /u02/database
[root@ol8_23ai ~]# mount /u02/database

done!

[root@ol8_23ai ~]# ls -tlr /u02/database
total 12
drwxr-x---. 11 oracle oinstall 4096 Sep 11 09:41 DB23AISTB
drwxr-x---. 10 oracle oinstall 4096 Sep 11 10:06 DB23AI
drwxr-x---.  5 oracle oinstall 4096 Sep 11 18:16 DBTEST23
[root@ol8_23ai ~]#