RAC Upgrade 11gR2 to 12cR1- from 11.2.0.3 to 12.1.0.1

  RAC Upgrade 11gR2 to 12cR1

from 11.2.0.3 to 12.1.0.1

In the demonstration  we are upgrading an Oracle RAC cluster 11.2.0.3 (PSU-11.2.0.3.12) on OEL 6.5 to Oracle RAC cluster 12c on OEL 6.5.

The upgrade comprises the following steps:

1.    Rolling upgrade (rac131 and rac132)

2.    Oracle 11gR2 11.2.0.3 to Oracle 12c 12.1.0.1 for both GI/RDBMS software.

3.    The database upgrade involves a downtime during the upgrade.

4.    Using ASM-Lib for raw device discovery

This upgraded involve recommended PSU 11.2.0.3.12 before upgrade, but I am showing here.  For more details you can refer my existing PSU on 11gR2 RAC PSU - Click Here.

ACTION_TIME                   VERSION    COMMENTS              BUNDLE_SER

----------------------------  ----------  -------------------- ---------

17-SEP-11 10.21.11.595816 AM  11.2.0.3   Patchset 11.2.0.2.0  PSU

08-SEP-15 09.34.55.797434 PM  11.2.0.3   Patchset 11.2.0.2.0  PSU

08-SEP-15 11.56.28.357498 PM  11.2.0.3   PSU 11.2.0.3.12             PSU

 Extract the download software from edelivery on stating location.  First extract GI and the move the extract directory.

• Run ./runInstaller
  
  You will see the below grid infrastructure installation window.  Follow the self explanatory wizard.

Click Next and select Upgrade the Grid Infrastructure or Oracle Automatic......

Click Next 

 Click Next and ensure both node are select

Click yes if you want to use asm health check.  From 12.1.0.2 it is mandatory and this dialog box you can't see here.

Select required group and Click Next 

Click Next 

Configure sudo/root credentials

Its up to you if you want to add batch.  I am using default configuration as i have only 2 node cluster.

Review and proceed for GI Upgrade 

Confirm the root.sh script run by installer autamatically. 

Processing 

Finally Grid Infrastructure has migrated to 12c

Proceed for 12c RDBMS Installation.  

Here I am using software only for cluster database and will upgrade database later in this slide.

From the stage location (12c Database software) run the below :

$. ./runInstaller

Select Cluster database installation and click next

Choose both nodes

 Click Next 

 Select Enterprise......  

 Choose New RDBMS home for 12c

 Select required group 

 Click Next and Verify the details

 Click Next 

 run the root.sh  as privilege user on both nodes. 

Now Cluster Database binary has successfully installed.

Proceed for Database Upgrade from 11.2.0.3  to 12.1.0.1 

Now its time for database upgrade from 11g to 12c.  Its mandatory existing db is having mandatory applied patch.

ACTION_TIME                   VERSION    COMMENTS              BUNDLE_SER

----------------------------  ----------  -------------------- ---------

17-SEP-11 10.21.11.595816 AM  11.2.0.3   Patchset 11.2.0.2.0  PSU

08-SEP-15 09.34.55.797434 PM  11.2.0.3   Patchset 11.2.0.2.0  PSU

08-SEP-15 11.56.28.357498 PM  11.2.0.3   PSU 11.2.0.3.12             PSU

 Set the 12c environment and run the Database Upgrade Assistance (DBUA)

$ $ORACLE_HOME/bin/dbua

 Select Upgrade Database option 

 Select your database which you want to upgrade and click Next 

 We will see some warning during db upgrade.  Its because of  I forget to remove existing 11g Enterprise Manager Database console.  So first remove EM then move forward.

 Ignore the LDAP dependencies will fix once we have OID configure in our environment.

 Select parallelism option to boost the upgrade process.  Number of parallelism is depend upon your CPU thread on your server.  

Select the Diag and Audit dest location as per your configuration. 

 Here I am choosing EM database express for database monitoring.  

 Click Next as i have already taken RMAN backup 

 Verify the summary and click next for Upgrade processing 

In my case it took 1 hours plus to complete all upgrade process.  So be patient or have a long break...

 Verify the Upgrade result 

 Congratulation we have successfully upgrade existing cluster database to 12c.  Now verify the post step to confirm.

  

Post Upgrade

[oracle@rac131 DB-12.1.0.1]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed Sep 9 06:21:07 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP

Advanced Analytics and Real Application Testing options

SQL> @?/rdbms/admin/utlu121s.sql

.

Oracle Database 12.1 Post-Upgrade Status Tool           09-09-2015 06:21:24

.

Component                               Current         Version  Elapsed Time

Name                                    Status          Number   HH:MM:SS

.

Oracle Server

.                                         VALID      12.1.0.1.0  00:13:51

JServer JAVA Virtual Machine

.                                         VALID      12.1.0.1.0  00:04:09

Oracle Real Application Clusters

.                                         VALID      12.1.0.1.0  00:00:01

Oracle Workspace Manager

.                                         VALID      12.1.0.1.0  00:01:10

OLAP Analytic Workspace

.                                         VALID      12.1.0.1.0  00:00:42

Oracle OLAP API

.                                         VALID      12.1.0.1.0  00:00:24

Oracle XDK

.                                         VALID      12.1.0.1.0  00:00:47

Oracle Text

.                                         VALID      12.1.0.1.0  00:01:03

Oracle XML Database

.                                         VALID      12.1.0.1.0  00:06:35

Oracle Database Java Packages

.                                         VALID      12.1.0.1.0  00:00:23

Oracle Multimedia

.                                         VALID      12.1.0.1.0  00:02:11

Spatial

.                                         VALID      12.1.0.1.0  00:06:49

Oracle Application Express

.                                         VALID     4.2.0.00.27  00:18:54

Final Actions

.                                                                00:02:34

Total Upgrade Time: 01:00:02

PL/SQL procedure successfully completed.

 Check the oracle registry history ...... 

  

SQL> select ACTION_TIME, ACTION, VERSION, COMMENTS, BUNDLE_SERIES
FROM registry$history ;

ACTION_TIME                  ACTION        VERSION    COMMENTS             BUNDLE_SER

---------------------------- ------------- ---------- -------------------- ----------

17-SEP-11 10.21.11.595816 AM APPLY         11.2.0.3   Patchset 11.2.0.2.0  PSU

08-SEP-15 09.34.55.797434 PM APPLY         11.2.0.3   Patchset 11.2.0.2.0  PSU

08-SEP-15 11.56.28.357498 PM APPLY         11.2.0.3   PSU 11.2.0.3.12      PSU

09-SEP-15 05.40.10.997725 AM VIEW INVALIDA            view invalidation

                             TE

09-SEP-15 05.42.41.761736 AM UPGRADE       12.1.0.1.0 Upgraded from 11.2.0

                                                      .3.0

09-SEP-15 05.46.25.451966 AM APPLY         12.1.0.1   Patchset 12.1.0.0.0  PSU

Hope this will help you .... :)