This entry shows the start of my process to upgrade the PERSONAL database to 19c.
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:
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.
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.
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.