2020-03-09 Upgrade to 19C

Overview

This entry shows the start of my process to upgrade the PERSONAL database to 19c.

References

Planning

The PERSONAL database on PERSONAL is a non-cdb as shown by the following snippet of SQL:

SQL> select cdb from v$database; CDB --- NO

Because Oracle 20C no longer supports non-CDB, I will need to migrate this database into a CDB. To do this, I have the following plan:

    1. Install Oracle 19C in a separate home (Oracle 20C has not been released for Linux as of February 2020);
    2. Patch this home to January 2020 RUR;
    3. Create a new CDB called PERSCDB;
    4. Plug the old PERSONAL database into this CDB.

Review Fix Control Parameters

There are two (2) Fix Control parameters set for the PERSONAL database:

*._fix_control='17376322:0','6660162:0'

Fix control, 17376322, is set in response to "Bug 26894777 - ORA-7445 kkqjgrp parsing query (Doc ID 26894777.8)". This fix for this bug is first included in Oracle 18.1.0. So, upgrade to 19.5 means I can remove this fix control setting.

Fix control, 6660162, is set in response to "Bug 6660162 : ENHANCE FIX TO BUG5705257". There is no indication that this bug has been fixed. I have no record of why the workaround was needed. I leave the workaround off, and see what problems result.

I will go forward with no fix control parameters set.

Procedure

Install Oracle 19.5.1.0.200114

The procedure described in "Install Oracle RDBMS 19.5.1.0.200114 without Grid Infrastructure" installs Oracle 19C and patches the Oracle home to 19.5.1.0.200114.

Validate Oracle Home

I ran the following commands to validate SQL*Plus accessibility:

export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1 export PATH=${ORACLE_HOME}/bin:${PATH} sqlplus /nolog

The errors were:

sqlplus: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /opt/oracle/product/19c/dbhome_1/lib/libclntsh.so.19.1) sqlplus: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /opt/oracle/product/19c/dbhome_1/lib/libclntshcore.so.19.1) sqlplus: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /opt/oracle/product/19c/dbhome_1/lib/libnnz19.so)

I ran the following commands to find whether GLIBC was installed or not:

yum search glibc

The output was:

Loaded plugins: security Could not get metalink https://mirrors.fedoraproject.org/metalink?repo=epel-6&arch=x86_64 error was 14: problem making ssl connection ol6_UEKR3_latest | 2.5 kB 00:00 ol6_UEKR3_latest/primary_db | 71 MB 01:30 ol6_latest | 2.7 kB 00:00 ol6_latest/primary_db | 21 MB 00:27 ol6_oracle_instantclient | 1.2 kB 00:00 ol6_oracle_instantclient 14/14 ============================================================================================ N/S Matched: glibc ============================================================================================ glibc-common.x86_64 : Common binaries and locale data for glibc compat-glibc.x86_64 : Compatibility C library compat-glibc-headers.x86_64 : Header files for development using standard C libraries. glibc.x86_64 : The GNU libc libraries glibc.i686 : The GNU libc libraries glibc-devel.x86_64 : Object files for development using standard C libraries. glibc-devel.i686 : Object files for development using standard C libraries. glibc-headers.x86_64 : Header files for development using standard C libraries. glibc-static.i686 : C library static libraries for -static linking. glibc-static.x86_64 : C library static libraries for -static linking. glibc-utils.x86_64 : Development utilities from GNU C library kernel-headers.x86_64 : Header files for the Linux kernel for use by glibc kernel-uek-headers.x86_64 : Header files for the Linux kernel for use by glibc latrace.i686 : LD_AUDIT feature frontend for glibc 2.4+ latrace.x86_64 : LD_AUDIT feature frontend for glibc 2.4+ nss-mdns.i686 : glibc plugin for .local name resolution nss-mdns.x86_64 : glibc plugin for .local name resolution Name and summary matches only, use "search all" for everything.

I ran the following commands to find the version of GLIBC that was installed:

yum info glibc-common.x86_64

The output was:

Loaded plugins: security Installed Packages Name : glibc-common Arch : x86_64 Version : 2.12 Release : 1.132.el6 Size : 107 M Repo : installed From repo : anaconda-OracleLinuxServer-201311252058.x86_64 Summary : Common binaries and locale data for glibc URL : http://sources.redhat.com/glibc/ License : LGPLv2+ and LGPLv2+ with exceptions and GPLv2+ Description : The glibc-common package includes common binaries for the GNU libc : libraries, as well as national language (locale) support. Available Packages Name : glibc-common Arch : x86_64 Version : 2.12 Release : 1.212.0.3.el6_10.3 Size : 14 M Repo : ol6_latest Summary : Common binaries and locale data for glibc URL : http://sources.redhat.com/glibc/ License : LGPLv2+ and LGPLv2+ with exceptions and GPLv2+ Description : The glibc-common package includes common binaries for the GNU libc : libraries, as well as national language (locale) support.

So, I have GLIBC 2.12 installed - not GLIBC 2.14.