Upgrade 11gR2 RAC to 12c RAC on RHEL !!!

Home »  11g »  Upgrade 11gR2 RAC to 12c RAC on RHEL !!!

On April 2, 2016, Posted by , In 11g,12c, By ,, , With Comments Off on Upgrade 11gR2 RAC to 12c RAC on RHEL !!!

In this article we will see the steps to Upgrade 11gR2 RAC to 12c RAC on RHEL. We will be doing upgradation of Oracle version 11.2.0.3 to 12.1.0.2 which will include Grid and Database both.

The current 11gR2 RAC configuration is as below,
• OS: RHEL 5.8
• Oracle Software owner: oracle
• Grid Software owner: grid
• Oracle Home: /u01/app/oracle/products/11.2.0/db
• Grid Home: /u01/app/11.2.0/crs
• The OCR, Voting Disk and Database files are stored in ASM diskgroups.
• RAC Nodes – rac1,rac2

======================================================================================================

 

• Complete prerequisites

Complete the below checks before proceeding with the upgrade installation of 12c Clusterware

– First of all make sure you have downloaded the below software from Oracle Support site.

Grid binaries
• linuxamd64_12102_grid_1of2.zip
• linuxamd64_12102_grid_2of2.zip

Oracle binaries
• linuxamd64_12102_database_1of2.zip
• linuxamd64_12102_database_2of2.zip

Perform the below checks required for 12c installation.

– Stop the “avahi-daemon” process and disable it

# /etc/init.d/avahi-daemon stop
# chkconfig avahi-daemon off
# chkconfig –list avahi-daemon

– Add below kernel parameter in “sysctl.conf” file

# vi /etc/sysctl.conf
kernel.panic_on_oops = 1

# sysctl -p

– Add below lines “/etc/rc.local” file

chown grid:oinstall /dev/sdb1
chown grid:oinstall /dev/sdc1
chown grid:oinstall /dev/sdd1
chown grid:oinstall /dev/sde1
chown grid:oinstall /dev/sdf1
chmod 660 /dev/sdb1
chmod 660 /dev/sdc1
chmod 660 /dev/sdd1
chmod 660 /dev/sde1
chmod 660 /dev/sdf1

– Run the below command as “grid” user to check whether rolling upgrade prechecks have been completed or not. For this the 11gR2 RAC cluster should be up and running.

$ ./runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u01/app/11.2.0/crs -dest_crshome /u01/app/12.1.0/crs -dest_version 12.1.0.2.0 -fixup -verbose

Verify that all the requirements have “Passed”. If any prechecks failed, resolve it and again run the cluvfy utility.

======================================================================================================

 

• Upgrade 11gR2 Clusterware and ASM

Once the pre-requisites are completed, you can proceed with the Grid upgradation.
[Note: The existing 11g RAC cluster and ASM should be up and running on both the nodes]

– Login as grid user, Unzip the grid software and start the installation.
$ cd grid
$ ./runInstaller

– SELECT INSTALLATION OPTION Screen

Upgrade 11gR2 RAC Grid Select Installation Option

The upgrade option will be automatically selected. Click on Next to continue.

 

– SELECT PRODUCT LANGUAGES Screen

Upgrade 11gR2 RAC Grid Select Product Languages

Click on Next to continue.

 

– GRID INFRASTRUCTURE NODE SELECTION Screen

Upgrade 11gR2 RAC Grid Node Selection

By default, both nodes will be selected. Click on Next to continue.

 

– SPECIFY MANAGEMENT OPTIONS Screen

Upgrade 11gR2 RAC Grid Specify Management Options

You can specify the OMS details to register your database in OEM or leave it and proceed without registering.

 

– OPERATING SYSTEM GROUPS Screen

Upgrade 11gR2 RAC Grid OS Groups

Check whether appropriate groups are shown. Click on Next to continue.

 

– INSTALLATION LOCATION Screen

Upgrade 11gR2 RAC Grid Installation Location

Enter the path for Oracle Software installation and Click on Next to continue.

 

– ROOT SCRIPT EXECUTION CONFIGURATION Screen

Upgrade 11gR2 RAC Grid Root Script Execution Cfg

You can provide root credentials here if you want to automate the execution of root scripts. If you want to execute root script manually then you can ignore and continue.

 

– SUMMARY Screen

Upgrade 11gR2 RAC Grid Summary

Check whether all the information displayed is proper or not. To continue with the installation click on Install.

 

– INSTALL PRODUCT Screen

Upgrade 11gR2 RAC Grid Install Product

You can observe the installation process.

 

– EXECUTE CONFIGURATION SCRIPTS Screen

Upgrade 11gR2 RAC Grid Execute Configuration Scripts

Run the root.sh script on both nodes. I have attached output of root.sh script for both nodes.

root.sh script output of Node 1

 

root.sh script output of Node 2

 

Click on OK after execution of root.sh script is completed on both nodes. Once you click on OK, the installation will proceed further as shown in below screenshot.

Upgrade 11gR2 RAC Grid Install Product 2

Wait for the installation to complete.

 

– FINISH Screen

Upgrade 11gR2 RAC Grid Finish

The last screen confirms that upgrade of Grid Infrastructure was successful.

======================================================================================================

 

• Post Installation Sanity Checks

– You can confirm the status of 12c cluster using below commands,

 

– Check status of OCR and Voting disk

 

– Detach old (11gR2) GRID home

If all post checks are completed and OK, then you can detach the old GRID home as shown below.

If you get errors for some files that they could not be deleted then you can remove it manually after the above script finishes.

======================================================================================================

 

• Install 12c Oracle Database Software

– Login as oracle user and start the installation.
$ cd database
$ ./runInstaller

– CONFIGURE SECURITY UPDATES Screen

Upgrade 11gR2 RAC DB Configure Security Updates

Uncheck the option “I wish to receive security updates….” and click on Next to continue the installation.

 

– INSTALLATION OPTION Screen

Upgrade 11gR2 RAC DB Installation Option

Select “Install Database Software Only” and click on Next to continue.

 

– GRID INSTALLATION OPTIONS Screen

Upgrade 11gR2 RAC DB Grid Installation Options

By default, the option “Oracle Real Application Clusters database installation” is selected. Make sure that all the nodes are also selected before proceeding with the installation.

 

– NODES SELECTION Screen

Upgrade 11gR2 RAC DB Nodes Selection

Make sure that all nodes are selected. Click on Next to Continue.

 

– PRODUCT LANGUAGES Screen

Upgrade 11gR2 RAC DB Product Languages Screen

Click on Next to continue.

 

– DATABASE EDITION Screen

Upgrade 11gR2 RAC DB Database Edition

Since our 11g database was Enterprise Edition, the option “Enterprise Edition” is automatically selected. Click on Next to continue.

 

– INSTALLATION LOCATION Screen

Upgrade 11gR2 RAC DB Installation Location

Enter the path for Oracle Software installation and Click on Next to continue.

 

– OPERATING SYSTEM GROUPS Screen

Upgrade 11gR2 RAC DB OS Groups

Check whether appropriate groups are shown. Click on Next to continue.

 

– SUMMARY Screen

Upgrade 11gR2 RAC DB Summary

Check whether all the information displayed is proper or not. To continue with the installation click on Install.

 

– INSTALL PRODUCT Screen

Upgrade 11gR2 RAC DB Install Product

You can observe the installation process.

 

– EXECUTE CONFIGURATION SCRIPTS Screen

Upgrade 11gR2 RAC DB Execute Configuration Scripts

Execute the “root.sh” script on all rac nodes.
After you have finished executing the script on all nodes, click on OK to continue.

 

– FINISH Screen

Upgrade 11gR2 RAC DB Finish

You have successfully installed the Oracle Database Software. The next step is to upgrade the Database to 12c. For database upgradation steps you can refer this link.

======================================================================================================

Tags : ,, ,
Comments are closed.