05 February 2024

Upgrade Database System to Linux 8 on OCI using console

When upgrading to Linux 8 of your Database System (Oracle Base Database), using the console, you will lose some settings that you have made manually.

https://docs.oracle.com/en/cloud/paas/base-database/upgrade-dbs/index.html#GUID-32241D49-BA5B-42D3-90B6-83D0A50480C9


What will you CERTAINLY lose:

* changes in /etc/fstab LOST

* extra directory in /opt/ LOST

* all stuff in /home/oracle  (scripts, changes in .bash_profile)

* extra mounted Filesystems. If they are external, you will need to put them back in /etc/fstab and remount.

* /etc/cron.allow is gone

* crontab of user oracle is gone (probably all crontabs!)

* contents of database directory objects if they are not on /u01, /u02, /u03!!

What goes ok:

  • extra stuff stored in /u01 /u02 /u03  (if you use Filesystem storage)
  • extra entries in tnsnames.ora  (which is in $ORACLE_HOME on u01)
  • The external /mnt to a filesystem is gone, but the filesystem itself is ok. Just remount it.


MAKE SURE TO BACKUP ALL BEFORE YOU START UPGRADE