My Oracle Support Banner

SuperCluster - 11.2.0.4 Grid Infrastructure and Database Upgrade for 11.2.0.3 (Doc ID 1919830.1)

Last updated on FEBRUARY 06, 2020

Applies to:

Oracle SuperCluster M6-32 Hardware - Version All Versions to All Versions [Release All Releases]
Oracle Exadata Storage Server Software - Version 11.2.1.2.0 and later
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
SPARC SuperCluster T4-4 - Version All Versions to All Versions [Release All Releases]
Oracle SuperCluster T5-8 Hardware - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Purpose

This document provides step-by-step instructions for upgrading from Oracle Database and Oracle Grid Infrastructure release 11.2.0.3 BP8 and later to 11.2.0.4 on Oracle SuperCluster.

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 SuperCluster Maintenance
 Overview
 Conventions
 Assumptions
 Oracle SuperCluster Supported Versions Documents
 Prepare the Existing Environment
 Plan the Upgrade
 Test on non-production first
 Preserve SQL Execution Plans with SQL Plan Management
 Develop and Test a Recovery Plan
 Obtain Required Account Access
 Review 11.2.0.4 Upgrade Prerequisites
 Generic requirements:
 Download Required Files
 Apply patches / updates where required before upgrading proceeds
 Update OPatch in existing 11.2 Grid Home and existing 11.2 Database Homes on All Database Servers
 Apply required patches / updates identified in the section  'Upgrade Prerequisites' 
 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 11.2.0.4
 Create a snapshot based backup of the database server partitions
 Create the new Grid Infrastructure (GI_HOME) directory where 11.2.0.4 will be installed
 Prepare installation software
 Perform the 11.2.0.4 Grid Infrastructure software installation and upgrade using the Oracle Universal Installer (OUI)
 Apply the latest Bundle Patchset  and the workaround for item DB_10 in SuperCluster Critical Issues
 If available apply 11.2.0.4 Bundle Patch Overlay Patches to the Grid Infrastructure Home as specified in  SuperCluster Supported Versions for your hardware type
 Apply Customer-specific 11.2.0.4 One-Off Patches to the Grid Infrastructure Home
 Change SGA memory settings for ASM
 Verify values for memory_target and memory_max_target
 Change Custom Scripts and Environment Variables to Reference the 11.2.0.4 Grid Home
 Install Database 11.2.0.4 Software
 Prepare Installation Software
 Perform 11.2.0.4 Database Software Installation with the Oracle Universal Installer (OUI) 
 Update OPatch in the New Database Home on All Database Servers
 Install Latest 11.2.0.4 Bundle Patch for Oracle  Exadata Database Machine to the Database Home  - Do Not Perform Post-Installation Steps
 When available: Apply 11.2.0.4 Bundle Patch Overlay Patches to the Database Home as Specified in Document 888828.1
 Apply Customer-specific 11.2.0.4 One-Off Patches
 Upgrade Database to 11.2.0.4
 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 11.2.0.4 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 an 11.2.0.4 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 11.2.0.4 Database Home
 Underscore Initialization Parameters
 Perform 11.2.0.4 Bundle Patch for Oracle Exadata Database Machine 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 11.2.0.4 environment
 Run Exachk
 Re-configure RMAN Media Management Library
 Troubleshooting
 Revision History
 Appendix
 Oracle Documentation  
 Patch matrix for 14639430 - patch requirements for rolling-back upgrades from 11.2.0.4 Linux and Solaris x86-64 
 Patch matrix for minimal required patches on top of 11.2.0.4 
 Community Discussions
References

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