Applies To:

Operating System(s): RHEL/OEL 5.x and RHEL/OEL 6.x

Oracle Version(s): 11.2.0.2 and higher

Author:

Manjunatha Reddy MC

Problem:

----------------------------------------------------------------------------------------------------------
How do I upgrade Oracle 11gR2 Database Software to Oracle 12cR1?

Solution:

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

This is an out-of-place upgrade, which will create a new Oracle Software home and leave old home untouched for us to rollback/downgrade easily.

To upgrade existing Oracle 11gR2 RAC database software to Oracle 12c, you have to download and then install the Oracle 12c Release 1 database software in a new Oracle Home and make sure there are no relinking errors. Also, install the latest available patch set, opatch, or CPU patches if available.

Copy the parameter files and password file from the Oracle Home of the database being upgraded to the new Oracle Home for Oracle Database 12c. Remove or comment out obsolete and deprecated initialization parameters.

 

1.     Log in as root and type: xhost +.

2.     Mount the Oracle Database 12c media. 

3.     Log in as Oracle user by typing: 

          su - oracle 

4.     Run the installer script from your Oracle database media:
         <CD_mount>/runInstaller
 

In the Configure Security Updates window, enter your My Oracle Support credentials to receive security updates, and click Next.

 

In the Configure Security Updates window, enter your My Oracle Support credentials to receive security updates, and click Next.


In the Download Software Updates window, enter your My Oracle Support credentials to download patch updates available after the initial release. If you choose not to update at this time, select Skip software updates and click Next.


In the Select Installation Option window, select Upgrade an existing database.


In the Grid Installation Options window Select Oracle Real Application Clusters database installation and click Next.


In the Select List of Nodes window select all the nodes and Click SSH Connectivity and configure your passwordless SSH connectivity by entering the OS Password for the Oracle user and selecting Setup. Click Ok and click Next to go the next window


In the Select Product Languages window, select English as the Language Option and click Next

In the Select Database Edition window, select Enterprise Edition and click Next.


In the Installation Location window,

 Specify the location of your Oracle Base configured within the Dell oracle utilities RPM.

NOTE: The default locations used within the Dell Oracle utilites RPM are as follows:

Oracle Base—/u01/app/oracle

Software Location—/u01/app/oracle/product/12.1.0/dbhome_1


In the Privileged Operating System Groups window, select dba for Database Administrator (OSDBA) group, Database Operator (OSOPER) group, Database Backup and Recovery (OSBACKUPDBA) group, Data Guard administrative (OSDGDBA) group and Encryption Key Management administrative (OSKMDBA) group and click Next.


In the Summary window verify the settings and select Install.


On completion of the installation process, the Execute Configuration scripts wizard is displayed. Follow the instructions in the wizard and click OK.


  In the Finish window, click Close.