Rapid Upgrade 11.2.0.3 or 11.2.0.4 to 12.2.0.1 - Step One
Today, I am going to show you how to upgrade 11.2.0.4 to 12.2.0.1 in rapid way ( you can apply the same process with 11.2.0.3 )
Maybe as start point you have to check following post where you can find all new features of the release and what is supported.
There are a lot of thinks which should be check and analyzed prior such major upgrade:
Application checks
- Check Application Vendor information ( if there are any special patch related to new database release )
- Check Application Pool driver for any conflicts, special connection configuration or patch due to new release
In case of Weblogic you can this Feature Matrix
WebLogic 12c with Oracle 12c key points
Also some of the features can be implemented as part of normal JDBC driver upgrade with integration of additional java code or Application vendor.
WebLogic 12c with Oracle 12c whitepape
Application Continuity
Transaction Guard
Presentations and Demonstrations
Maximum Application Continuity with Oracle Database 12c
Client Failover - Hiding Outages from Applications
Demo: Application Continuity Standalone
Demo: Application Continuity with WebLogic Server Integration
Database Checks
- Check Current Database time zone version ( in my case 11.2.0.4 was 14 and after upgrade is 26 )
- Check Oracle Metalink information for any recommended patches prior the upgrade
Strongly recommended -> Patches to apply before upgrading Oracle GI and DB to 12.2.0.1 (Doc ID 2180188.1)
Linux x86-64
DB Upgrades to 12.2.0.1
|
From Release |
Bug#(s) |
Patch |
Description |
Additional comments |
|
12.1.0.2 |
21255373 |
22646084 |
12.1.0.2.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) |
included in OCWPSU 12.1.0.2.160419 Recommended to install latest* 12.1.0.2 GI PSU |
|
12.1.0.1 |
17617807 |
23580463 |
MERGE REQUEST ON TOP OF OCW PSU 12.1.0.1.1 FOR BUGS 17617807 21255373 |
Available on top of 12.1.0.1.1 |
|
21255373 |
||||
|
11.2.0.4 |
17617807 |
GI PSU 22646198 |
11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) |
Fix included in 11.2.0.4.4 GI PSU Recommended to install latest* 11.2.0.4 GI PSU |
|
21255373 |
included in 11.2.0.4.160419OCWPSU Recommended to install latest* 11.2.0.4 GI PSU |
|||
|
11.2.0.3 |
17617807 |
23580534 |
MERGE REQUEST ON TOP OF GRID INFRASTRUCTURE PSU 11.2.0.3.9 FOR BUGS 17617807 21255373 |
Available on top of 11.2.0.3.9 Clusterware patch |
- Patch version of the current database version is important and maybe Oracle RDBMS should be considered to be patched prior the major upgrade like this. This will help to avoid errors or upgrade issue during the upgrade process and performance issue after upgrade ( I am going to create special post with a lot of details in order to give you more visibility on the upgrade process)
- Check for any deprecated parameters, recommendation is to clear all deprecated parameters from pfile/spfile and then to add back if necessary ( double check deprecated state )
- Check Database Services, if don’t have services created for each Application pointing to database will be good to start using services for each application because this will provide you clear evidence/statistics which Client/Application increase/decrease impact on database prior and after the upgrade, the main idea is to analyze Application behavior.
OS System Checks
Kernel parameter
Recommendation is to install RPM Pre-installation package to fix all necessary configuration on OS level
Oracle Linux 7
|
oracle-database-server-12cR2-preinstall-1.0-1.el7.x86_64.rpm |
14-Sep-2016 05:21 |
17.3 K |
|
|
oracle-database-server-12cR2-preinstall-1.0-2.el7.x86_64.rpm |
26-Oct-2016 12:31 |
17.7 K |
If you check following link https://docs.oracle.com/database/121/LADBI/pre_install.htm#LADBI7536 for more details
List with all Pre-installation RPM
|
Oracle Database 12cR2 |
Oracle Database 12cR1 |
|
Packages for Oracle Linux 7 and Red Hat Enterprise Linux 7 The following packages (or later versions) must be installed: |
Packages for Oracle Linux 7 and Red Hat Enterprise Linux 7 The following packages (or later versions) must be installed: |
|
binutils-2.23.52.0.1-12.el7 (x86_64) |
binutils-2.23.52.0.1-12.el7.x86_64 |
|
compat-libcap1-1.10-3.el7 (x86_64) |
compat-libcap1-1.10-3.el7.x86_64 |
|
compat-libstdc++-33-3.2.3-71.el7 (i686) |
compat-libstdc++-33-3.2.3-71.el7.i686 |
|
compat-libstdc++-33-3.2.3-71.el7 (x86_64) |
compat-libstdc++-33-3.2.3-71.el7.x86_64 |
|
n/a |
gcc-4.8.2-3.el7.x86_64 |
|
n/a |
gcc-c++-4.8.2-3.el7.x86_64 |
|
glibc-2.17-36.el7 (i686) |
glibc-2.17-36.el7.i686 |
|
glibc-2.17-36.el7 (x86_64) |
glibc-2.17-36.el7.x86_64 |
|
glibc-devel-2.17-36.el7 (i686) |
glibc-devel-2.17-36.el7.i686 |
|
glibc-devel-2.17-36.el7 (x86_64) |
glibc-devel-2.17-36.el7.x86_64 |
|
ksh |
ksh |
|
libaio-0.3.109-9.el7 (i686) |
libaio-0.3.109-9.el7.i686 |
|
libaio-0.3.109-9.el7 (x86_64) |
libaio-0.3.109-9.el7.x86_64 |
|
libaio-devel-0.3.109-9.el7 (i686) |
libaio-devel-0.3.109-9.el7.i686 |
|
libaio-devel-0.3.109-9.el7 (x86_64) |
libaio-devel-0.3.109-9.el7.x86_64 |
|
libgcc-4.8.2-3.el7 (i686) |
libgcc-4.8.2-3.el7.i686 |
|
libgcc-4.8.2-3.el7 (x86_64) |
libgcc-4.8.2-3.el7.x86_64 |
|
libstdc++-4.8.2-3.el7 (i686) |
libstdc++-4.8.2-3.el7.i686 |
|
libstdc++-4.8.2-3.el7 (x86_64) |
libstdc++-4.8.2-3.el7.x86_64 |
|
libstdc++-devel-4.8.2-3.el7 (i686) |
libstdc++-devel-4.8.2-3.el7.i686 |
|
libstdc++-devel-4.8.2-3.el7 (x86_64) |
libstdc++-devel-4.8.2-3.el7.x86_64 |
|
libXi-1.7.2-1.el7 (i686) |
libXi-1.7.2-1.el7.i686 |
|
libXi-1.7.2-1.el7 (x86_64) |
libXi-1.7.2-1.el7.x86_64 |
|
libXtst-1.2.2-1.el7 (i686) |
libXtst-1.2.2-1.el7.i686 |
|
libXtst-1.2.2-1.el7 (x86_64) |
libXtst-1.2.2-1.el7.x86_64 |
|
libX11-1.6.0-2.1.el7 (i686) |
n/a |
|
libX11-1.6.0-2.1.el7 (x86_64) |
n/a |
|
libXau-1.0.8-2.1.el7 (i686) |
n/a |
|
libXau-1.0.8-2.1.el7 (x86_64) |
n/a |
|
libxcb-1.9-5.el7 (i686) |
n/a |
|
libxcb-1.9-5.el7 (x86_64) |
n/a |
|
make-3.82-19.el7 (x86_64) |
make-3.82-19.el7.x86_64 |
|
net-tools-2.0-0.17.20131004git.el7 (x86_64) (for Oracle RAC and Oracle Clusterware) |
n/a |
|
nfs-utils-1.3.0-0.21.el7.x86_64 (for Oracle ACFS) |
n/a |
|
smartmontools-6.2-4.el7 (x86_64) |
n/a |
|
sysstat-10.1.5-1.el7 (x86_64) |
sysstat-10.1.5-1.el7.x86_64 |
Oracle Linux 6
Recommendation is to install RPM Pre-installation package to fix all necessary configuration on OS level
|
oracle-database-server-12cR2-preinstall-1.0-1.el6.x86_64.rpm |
14-Sep-2016 10:00 |
17.5 K |
List with all Pre-installation RPM
|
Oracle Database 12cR2 |
Oracle Database 12cR1 |
|
Packages for Oracle Linux 6 and Red Hat Enterprise Linux 6 The following packages (or later versions) must be installed: |
Packages for Oracle Linux 6 and Red Hat Enterprise Linux 6 The following packages (or later versions) must be installed: |
|
binutils-2.20.51.0.2-5.36.el6 (x86_64) |
binutils-2.20.51.0.2-5.11.el6 (x86_64) |
|
compat-libcap1-1.10-1 (x86_64) |
compat-libcap1-1.10-1 (x86_64) |
|
compat-libstdc++-33-3.2.3-69.el6 (x86_64) |
compat-libstdc++-33-3.2.3-69.el6 (x86_64) |
|
compat-libstdc++-33-3.2.3-69.el6 (i686) |
compat-libstdc++-33-3.2.3-69.el6 (i686) |
|
e2fsprogs-1.41.12-14.el6 (x86_64) |
n/a |
|
e2fsprogs-libs-1.41.12-14.el6 (x86_64) |
n/a |
|
n/a |
gcc-4.4.4-13.el6 (x86_64) |
|
n/a |
gcc-c++-4.4.4-13.el6 (x86_64) |
|
glibc-2.12-1.7.el6 (i686) |
glibc-2.12-1.7.el6 (i686) |
|
glibc-2.12-1.7.el6 (x86_64) |
glibc-2.12-1.7.el6 (x86_64) |
|
glibc-devel-2.12-1.7.el6 (x86_64) |
glibc-devel-2.12-1.7.el6 (x86_64) |
|
glibc-devel-2.12-1.7.el6 (i686) |
glibc-devel-2.12-1.7.el6 (i686) |
|
ksh |
ksh |
|
libgcc-4.4.4-13.el6 (i686) |
libgcc-4.4.4-13.el6 (i686) |
|
libgcc-4.4.4-13.el6 (x86_64) |
libgcc-4.4.4-13.el6 (x86_64) |
|
libs-1.42.8-1.0.2.el6.x86_64 |
n/a |
|
libstdc++-4.4.4-13.el6 (x86_64) |
libstdc++-4.4.4-13.el6 (x86_64) |
|
libstdc++-4.4.4-13.el6 (i686) |
libstdc++-4.4.4-13.el6 (i686) |
|
libstdc++-devel-4.4.4-13.el6 (x86_64) |
libstdc++-devel-4.4.4-13.el6 (x86_64) |
|
libstdc++-devel-4.4.4-13.el6 (i686) |
libstdc++-devel-4.4.4-13.el6 (i686) |
|
libaio-0.3.107-10.el6 (x86_64) |
libaio-0.3.107-10.el6 (x86_64) |
|
libaio-0.3.107-10.el6 (i686) |
libaio-0.3.107-10.el6 (i686) |
|
libaio-devel-0.3.107-10.el6 (x86_64) |
libaio-devel-0.3.107-10.el6 (x86_64) |
|
libaio-devel-0.3.107-10.el6 (i686) |
libaio-devel-0.3.107-10.el6 (i686) |
|
n/a |
libXext-1.1 (x86_64) |
|
n/a |
libXext-1.1 (i686) |
|
libXtst-1.0.99.2 (x86_64) |
libXtst-1.0.99.2 (x86_64) |
|
libXtst-1.0.99.2 (i686) |
libXtst-1.0.99.2 (i686) |
|
libX11-1.5.0-4.el6 (i686) |
libX11-1.3 (x86_64) |
|
libX11-1.5.0-4.el6 (x86_64) |
libX11-1.3 (i686) |
|
libXau-1.0.6-4.el6 (i686) |
libXau-1.0.5 (x86_64) |
|
libXau-1.0.6-4.el6 (x86_64) |
libXau-1.0.5 (i686) |
|
libxcb-1.8.1-1.el6 (i686) |
libxcb-1.5 (x86_64) |
|
libxcb-1.8.1-1.el6 (x86_64) |
libxcb-1.5 (i686) |
|
libXi-1.3 (x86_64) |
libXi-1.3 (x86_64) |
|
libXi-1.3 (i686) |
libXi-1.3 (i686) |
|
make-3.81-19.el6 |
make-3.81-19.el6 |
|
sysstat-9.0.4-11.el6 (x86_64) |
sysstat-9.0.4-11.el6 (x86_64) |
|
net-tools-1.60-110.el6_2.x86_64 (for Oracle RAC and Oracle Clusterware) |
n/a |
|
nfs-utils-1.2.3-15.0.1 (for Oracle ACFS) |
n/a |
|
smartmontools-5.43-1.el6.x86_64 |
n/a |
How to setup yum repo - http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html
Memory usages and what is free
Memory and CPU utilization profiling ( this is one very important step in order to avoid capacity issue )
Tools
- Lab128 – ( there are trial period ) Collect Database workload and compare workload before the upgrade and after.
- NMON – ( free ) Collect OS information CPU,MEM,NET etc. – very easy to create graphic from the workload
- Oracle OS watcher ( free ) similar to NMON but you can extract more details
- Oracle Trace File Analyzer - TFA Collector - TFA with Database Support Tools Bundle (Doc ID 1513912.1)
--- Next Step
Rapid Upgrade 11.2.0.4 Standard Edition to 12.2.0.1 Standard Edition
1 comment
Comment from: radoslav Member
Good to know ….
I am adding a link that can save us some time trying to find the GI PSU’s download link for GI 12.1.0.2.
12.1.0.2 Grid Infrastructure Patch Set Updates - List of Fixes in each GI PSU (Doc ID 1928853.1)
;)