11.2.0.1 to 11.2.0.2 Database Upgrade on Exadata Database Machine
(Doc ID 1315926.1)
Last updated on FEBRUARY 23, 2024
Applies to:
Oracle Exadata Storage Server Software - Version 11.2.1.2.0 to 11.2.1.2.0 [Release 11.2]Exadata Database Machine V2 - Version All Versions and later
Exadata Database Machine X2-2 Qtr Rack - Version All Versions and later
Exadata Database Machine X2-2 Full Rack - Version All Versions and later
Exadata Database Machine X2-2 Half Rack - Version All Versions 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 version 11.2.0.1 to 11.2.0.2 on Exadata Database Machine.
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 and Assumptions |
| References |
| Oracle Documentation |
| Oracle Support Documents |
| Prepare the Existing Environment |
| Review Database 11.2.0.2 Upgrade Prerequisites |
| Sun Datacenter InfiniBand Switch 36 is running software version 1.1.3-2 or later. |
| Database 11.2.0.1 software has applied at a minimum bundle patches DB_BP6 and GI_BP4 in the grid home and all database homes on all database servers. |
| Exadata Storage Server software is version 11.2.2.1.1 or later. |
| Ensure network 169.254.x.x is not currently used on database servers. |
| 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 |
| Run Exadata HealthCheck |
| Update OPatch in Grid Home and Database Home on All Database Servers |
| Apply Fix 12652740 (for unpublished bug 9329767) to the 11.2.0.1 Grid Home |
| Install and Upgrade Grid Infrastructure to 11.2.0.2 |
| Create the new ORACLE_HOME directory where 11.2.0.2 will be installed |
| Prepare installation software |
| Enable Automatic Memory Management (AMM) for ASM |
| Set cluster_interconnects Explicitly for ASM |
| Perform 11.2.0.2 Grid Infrastructure software installation and upgrade using OUI |
| Relink oracle Executable in Grid Home with RDS |
| Implement Necessary Workarounds |
| Execute rootupgrade.sh on Each Database Server |
| Change Custom Scripts and Environment Variables to Reference the 11.2.0.2 Grid Home |
| Install Database 11.2.0.2 Software |
| Prepare Installation Software |
| Perform 11.2.0.2 Database Software Installation with OUI |
| Relink oracle Executable in Database Home with RDS |
| Update OPatch in New Grid Home and New Database Home on All Database Servers |
| Install Latest 11.2.0.2 Bundle Patch - Do Not Perform Post Installation Steps |
| Stage the patch |
| Create OCM response file if required |
| Patch 11.2.0.2 database home |
| Patch 11.2.0.2 grid home |
| Skip patch post installation steps |
| Data Guard only - Apply Fix for Bug 11664046 on Primary and Standby Database Servers |
| Stage the patch |
| Patch 11.2.0.2 database home |
| Apply 11.2.0.2 Bundle Patch Overlay Patches as Specified in Document 888828.1 |
| Apply Customer-specific 11.2.0.2 One-Off Patches |
| Upgrade Database to 11.2.0.2 |
| 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 |
| Set cluster_interconnects Explicitly for All Primary and Standby Databases |
| Data Guard only - Synchronize Standby and Switch to 11.2.0.2 |
| Flush all redo generated on the primary and shutdown |
| Shutdown the primary database. |
| Disable fast-start failover and Data Guard broker |
| Shutdown the standby database and restart it with 11.2.0.2 |
| 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 'After Upgrading to the New Release' |
| Change Custom Scripts and Environment Variables to Reference the 11.2.0.2 Database Home |
| Add Underscore Initialization Parameters Back |
| Run 11.2.0.2 Bundle Patch Post Installation Steps |
| Data Guard only - Enable Fast-Start Failover and Data Guard Broker |
| 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.2 environment |
| Modify the dbfs_mount cluster resource |
| If using wallet-based authentication, recreate the symbolic link to /sbin/mount.dbfs |
| Run Exadata HealthCheck |
| Deinstall the 11.2.0.1 Database and Grid Homes |
| References |