Upgrading 10g RAC Clusterware to 11g RAC Clusterware

This article lists the steps to upgrade Oracle 10g RAC Clusterware to 11g RAC Clusterware. There are few new requirements in 11g like kernel parameters and SCAN IP which are discussed herewith.

Existing Environment:

Oracle 10g Two Node RAC Database using ASM on Sun Solaris 10 Update 9.


Preliminary Settings:


- Set the following kernel parameters in /etc/system file on both nodes:


set noexec_user_stack=1
set shmsys:shminfo_shmmax=8589934590
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set semsys:seminfo_semmns=2000
set semsys:seminfo_semmsl=1000
set semsys:seminfo_semmni=100
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmseg=10
set rlim_fd_cur=1024
set max_nprocs=30000
set maxuprc=16384
set default_stksize=32768

- Oracle 11g requires additional IPs for SCAN configuration. Recommended is 3 IPs and minimum is 1. If using 3 IPs, you need to make entry in DNS for round robin name resolution. If using single IP, then hosts file resolution could be used, in which case, cluster verification utility during installation would show as failed, which could be ignored. To avoid this, you need to make a Host entry in DNS Server.

E.g. make an entry in /etc/hosts

#SCAN
10.192.154.234  SCAN-PROD

The IP address should be of same subnet like public IP.


- Download the 11g Software from oracle website.

Unzip the software and run the Cluster Verification Utility.

./runcluvfy.sh stage -pre crsinst -n  < node1 >, < node2 > –verbose

As Oracle Clusterware was already running on these servers, most of the settings like user equivalence, patches etc would be already in place. In case of any errors, take appropriate action.

After Pre-checks are successful, we can further create the home directory for Grid software.

e.g.

/project/11.2.0/grid


- Shutdown the Database and ASM Instances. There is no need to stop the Clusterware.


- Unset the following environment variables:

ORA_CRS_HOME
ORACLE_HOME
ORA_NLS10
TNS_ADMIN


- Execute RunInstaller from Clusterware Software:

On Screen Selections:

Step 1 of 8

Select - Upgrade Grid Infrastructure
Click Yes on message ‘Existing ASM Instances detected’

Step 2 of 8

Click Next on Select Language screen

Step 3 of 8

Select existing Cluster Nodes.
Make sure check box ‘Update cluster ASM’ is checked

Step 4 of 8

SCAN Information:
Enter Cluster name:      CRS
Scan name:                  SCAN-PROD
Scan port:                    1521


Step 5 of 8

Specify password for ASMSNMP user


Step 6 of 8

Select OS group - oinstall


Step 7 of 8

Specify Oracle Base and Grid Home location


Step 8 of 8

Verify all Prerequisite checks have passed and click finish to start Setup.


Run ‘rootupgrade.sh’ script as root on all nodes one by one, when prompted.

After it finishes, Oracle 10g Clusterware and ASM Instances had been successfully upgraded to 11g Clusterware.

Have a question or comment? Post it below!