Exadata Database Machine 11.2.0.4 Grid Infrastructure and Database Upgrade for 11.2.0.2 BP12 and later
(Doc ID 1565291.1)
Last updated on APRIL 28, 2022
Applies to:
Oracle Exadata Storage Server Software - Version 11.2.1.2.0 and laterOracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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.2 BP12 and later to 11.2.0.4 on Oracle Exadata Database Machine for the Oracle Linux and Oracle Solaris operating system. For upgrades to 11.2.0.4 coming from releases earlier than 11.2.0.2 BP12 see <document 1555036.1>. If you have multiple database homes installed, with at least one of them on 11.2.0.2 BP11 or earlier, then also follow <document 1555036.1>.
This document may also be used in conjunction with <document 1919941.1> for upgrade of Oracle Database and Oracle Grid Infrastructure to 11.2.0.4 on Oracle Exadata Database Machine running Oracle Solaris x86-64 and Oracle SuperCluster running Oracle Solaris SPARC. Document <document 1919941.1> contains Solaris-specific requirements, recommendations, guidelines, and workarounds that pertain to upgrade of Oracle Database and Oracle Grid Infrastructure to 11.2.0.4.
Scope
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 |
| Scope |
| Details |
| Oracle Exadata Database Machine Maintenance |
| Overview |
| Conventions |
| Assumptions |
| 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 |
| 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 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 Bundle Patchset 11 or later to the Grid Infrastructure Home using 'napply' before running rootupgrade.sh on all nodes in the cluster |
| If available apply 11.2.0.4 Bundle Patch Overlay Patches to the Grid Infrastructure Home as Specified in Document 888828.1 |
| 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, memory_max_target and use_large_pages |
| Change Custom Scripts and Environment Variables to Reference the 11.2.0.4 Grid Home |
| Modify the dbfs_mount cluster resource |
| 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 11.2.0.4 Bundle Patch 11 or later for Oracle Exadata Database Machine to the Database Home - Do Not Perform Post-Installation Steps |
| 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 |
| Apply 11.2.0.4 Bundle Patch Overlay Patches to the Database Home and other overlays when specified in Document 888828.1 |
| Apply Customer-specific 11.2.0.4 One-Off Patches |
| 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 or HealthCheck |
| 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 |