How to upgrade Oracle 11gR2 database software to Oracle 12cR1

Applies To:

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

Oracle Version(s): 11.2.0.2 and higher

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.

Figure 1: Enter My Oracle Support credentials

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

Figure 2: Click on 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.

Figure 3: Select Skip software updates and click Next.

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

Figure 4: Select Upgrade an existing database

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

Figure 5 :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

Figure 6: 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

Figure 7: Select English as the Language Option and click Next

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

Figure 8: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. 

Oracle Base—/u01/app/oracle

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

Figure 9:Specify the location of your Oracle Base configured

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

Figure 10: Select dba for Database Administrator (OSDBA) group

In the Summary window verify the settings and select Install.

Figure 11: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.

Figure 12: Click on OK

In the Finish window, click Close.

Figure 13: Click on Finish