Overview
This entry shows the start of my process to upgrade the PERSONAL database to 19c.
References
- Install Oracle RDBMS 19.5.1.0.200114 without Grid Infrastructure
- Bug 26894777 - ORA-7445 kkqjgrp parsing query (Doc ID 26894777.8)
- Bug 6660162 : ENHANCE FIX TO BUG5705257
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:
- Install Oracle 19C in a separate home (Oracle 20C has not been released for Linux as of February 2020);
- Patch this home to January 2020 RUR;
- Create a new CDB called PERSCDB ;
- 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.