My Oracle Support Banner

11.2.0.2, 11.2.0.3, 11.2.0.4 or 12.1.0.1 to 12.1.0.2 Grid Infrastructure and Database Upgrade on Exadata Database Machine running Oracle Linux (Doc ID 1681467.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Exadata Hardware - Version 11.2.1.2.1 and later
Exadata X3-8 Hardware - Version All Versions and later
Exadata Database Machine X2-2 Hardware - Version All Versions and later
Exadata X4-2 Hardware - Version All Versions and later
Oracle Exadata Storage Server Software - Version 11.2.1.2.0 and later
Information in this document applies to any platform.

Purpose

This document provides step-by-step instructions for upgrading Oracle Database and Oracle Grid Infrastructure from release 11.2.0.2, 11.2.0.3, 11.2.0.4 or 12.1.0.1 to 12.1.0.2 on Oracle Exadata Database Machine running Oracle Linux.

This document may also be used in conjunction with <Document 1908556.1> for upgrade of Oracle Database and Oracle Grid Infrastructure to 12.1.0.2 on Oracle Exadata Database Machine running Oracle Solaris x86-64 and Oracle SuperCluster running Oracle Solaris SPARC.  <Document 1908556.1> contains Solaris-specific requirements, recommendations, guidelines, and workarounds that pertain to upgrade of Oracle Database and Oracle Grid Infrastructure to 12.1.0.2.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Details
 Oracle Exadata Database Machine Maintenance
 Overview
 Conventions
 Assumptions
 References
 Oracle Documentation
 My Oracle Support Documents
 Prepare the Existing Environment
 Planning
 Testing on non-production first
 SQL Plan Management
 Recoverability
 Account Access
 Review 12.1.0.2 Upgrade Prerequisites
 Sun Datacenter InfiniBand Switch 36 is running software release 1.3.3-2 or later, 2.1.3-4 recommended
 Grid Infrastructure Software
 Database Software
 Generic requirements
 Exadata Storage Server software recommended and minimum release 
 Do not place the new ORACLE_HOME under /opt/oracle.
 Data Guard only - If there is a physical standby database associated with the databases being upgraded, then the following must be true:
 Download Required Files
 Patch matrix for 12539000 - Required Patches when upgrading from 11.2.0.2 
 Patch matrix for 14639430 - patch requirements for rolling-back upgrades from 12.1.0.2 to 11.2.0.2 
 Patch matrix for 14639430 - patch requirements for rolling-back upgrades from 12.1.0.2 to 11.2.0.3 
 Patch matrix for 13460353 - Optional patch for those who will be creating 11.2.0.2 databases while running a 12.1.0.2 Grid infrastructure
 Patch matrix for 13460353 - Optional patch for those who will be creating 11.2.0.3 databases while running a 12.1.0.2 Grid infrastructure
 Apply patches / updates where required before upgrading proceeds
 Update OPatch in existing 11.2 and 12.1 Grid Home and Database Homes on All Database Servers 
 For Exadata Storage Servers and Database Servers on releases earlier than Exadata 11.2.3.3.1
 For 11.2.0.2 Grid Infrastructure and Database:
 For 11.2.0.3 Grid Infrastructure and Database:
 Run Exachk or HealthCheck
 Validate Readiness for Oracle Clusterware upgrade using CVU and Exachck
 Early stage pre-upgrade check: analyze your databases to be upgraded with the Pre-Upgrade Information Tool
 Install and Upgrade Grid Infrastructure to 12.1.0.2
 Install MGMTDB or not
 Validate hugepage configuration for new ASM SGA requirements
 Create a snapshot based backup of the database server partitions
 Create the new Grid Infrastructure (GI_HOME) directory where 12.1.0.2 will be installed
 Prepare installation software
 Change css misscount setting back to default before upgrading
 Perform the 12.1.0.2 Grid Infrastructure software installation and upgrade using OUI
 If available: Apply recommended patches to the Grid Infrastructure before running rootupgrade.sh
 Apply Customer-specific 12.1.0.2 One-Off Patches to the Grid Infrastructure Home
 When required relink oracle binary with RDS
 Verify values for memory_target, memory_max_target and use_large_pages
 Actions to take before executing rootupgrade.sh on each database server
 Execute rootupgrade.sh on each database server
 Continue with 12.1.0.2 GI installation in OUI
 Verify cluster status
 Change Custom Scripts and environment variables to Reference the 12.1.0.2 Grid Home
 Modify the dbfs_mount cluster resource
 Install Database 12.1.0.2 Software
 Prepare Installation Software
 Create the new Oracle DB Home directory on all database server nodes
 Perform 12.1.0.2 Database Software Installation with the Oracle Universal Installer (OUI)
 When required relink Oracle Executable in Database Home with RDS
 If necessary: Install Latest OPatch 12.1 in the Database Home on All Database Servers
 When available: Install the latest 12.1.0.2 GI PSU (which includes the DB PSU) to the Database Home when available - Do Not Perform Post-Installation Steps
 Stage the patch
 Create OCM response file if required
 Patch 12.1.0.2 database home
 Skip patch post-installation steps
 When available: Apply 12.1.0.2 Patch Overlay Patches to the Database Home as Specified in Document 888828.1
 Apply Customer-specific 12.1.0.2 One-Off Patches
 Upgrade Database to 12.1.0.2
 Backing up the database and creating a Guaranteed Restore Point
 Analyze the Database to Upgrade with the Pre-Upgrade Information Tool
 Run Pre-Upgrade Information Tool
 Handle obsolete and underscore parameters
 Review pre-upgrade information tool output
 Data Guard only - Synchronize Standby and Change the Standby Database to use the new 12.1.0.2 Database Home
 Flush all redo generated on the primary and disable the broker
 Data Guard only - Disable Fast-Start Failover and Data Guard Broker
 Shutdown the primary database.
 Shutdown the standby database and restart it in the 12.1.0.2 database home
 Start all primary instances in restricted mode
 Upgrade the Database with Database Upgrade Assistant (DBUA)
 Review and perform steps in Oracle Upgrade Guide, Chapter 4 'Post-Upgrade Tasks for Oracle Database'
 Change Custom Scripts and environment variables to Reference the 12.1.0.2 Database Home
 Underscore Initialization Parameters
 When required: run PSU Post-Installation Steps
 Data Guard only - Enable Fast-Start Failover and Data Guard Broker
 Post-upgrade Steps
 Remove Guaranteed Restore Point 
 DBFS only - Perform DBFS Required Updates
 Obtain latest mount-dbfs.sh script from Document 1054431.1
 Edit mount-dbfs.sh script and Oracle Net files for the new 12.1.0.2 environment
 Run Exachk or HealthCheck
 Verify nproc setting (CRS_LIMIT_NPROC) for Grid Infrastructure
 Optional: Deinstall the 11.2.0.2, 11.2.0.3, 11.2.0.4 or 12.1.0.1 Database and Grid Homes
 Re-configure RMAN Media Management Library
 Restore settings for concurrent statistics gathering
 Advance COMPATIBLE.ASM diskgroup attribute 
 Troubleshooting
 Revision History
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.