10g asm upgrade to 11g on linux

10g OCW, ASM and RAC Upgrade to 11g on Linux

1/1

Alejandro Vargas | Principal Support ConsultantOracle Advanced Customer Services

Part II ASM Instance Upgrade

Summary............................................................................................................................................................................2The Environment................................................................................................................................................................2Install 11.1.0.6 Oracle Home for ASM and Database........................................................................................................4

Root.sh on Node 1..........................................................................................................................................................7Root.sh on Node 2..........................................................................................................................................................8

Upgrade ASM and Databases Home to 11.1.0.7.............................................................................................................10Upgrade ASM to 11.1.0.7.................................................................................................................................................16


2/18

Summary

This document describes the procedure to upgrade Oracle Clusterware, ASM and RAC database from 10.2.0.3 to11.1.0.7 step by step.

The CRS and ASM upgrades are straightforward and were completed without any inconvenient. The database upgradetook longer and required more manual intervention, there are several preupgrade tasks that must be completed, evenusing the database upgrade assistant.

Usually I do prefere manual upgrades but this time I wanted to check how well DBUA worked on 11g and it did the jobquite well.

The Environment

The environment consisted of 2 nodes running Red Hat Linux Version 4, Oracle clusterware and database version10.2.0.3

[oracle@rac1 ~]$ uname -aLinux rac1.av.com 2.6.9-55.0.0.0.2.EL #1 Wed May 2 14:55:28 PDT 2007 i686 i686 i386GNU/Linux

[oracle@rac1 ~]$ cat /etc/issueEnterprise Linux Enterprise Linux AS release 4 (October Update 5)Kernel \r on an \m

[oracle@rac1 ~]$ chkcrsHA Resource Target State----------- ------ -----ora.rac1.ASM1.asm ONLINE ONLINE on rac1ora.rac1.ASM1.asm ONLINE ONLINE on rac1ora.rac1.LISTENER_RAC1.lsnr ONLINE ONLINE on rac1ora.rac1.gsd ONLINE ONLINE on rac1


3/18

ora.rac1.ons ONLINE ONLINE on rac1ora.rac1.vip ONLINE ONLINE on rac1ora.rac2.ASM2.asm ONLINE ONLINE on rac2ora.rac2.LISTENER_RAC2.lsnr ONLINE ONLINE on rac2ora.rac2.gsd ONLINE ONLINE on rac2ora.rac2.ons ONLINE ONLINE on rac2ora.rac2.vip ONLINE ONLINE on rac2ora.sati.db ONLINE ONLINE on rac2ora.sati.dbserv.cs ONLINE ONLINE on rac2ora.sati.dbserv.sati1.srv ONLINE ONLINE on rac1ora.sati.dbserv.sati2.srv ONLINE ONLINE on rac2ora.sati.sati1.inst ONLINE ONLINE on rac1ora.sati.sati2.inst ONLINE ONLINE on rac2

[oracle@rac1 bin]$ crsctl query crs softwareversionCRS software version on node [rac1] is [10.2.0.3.0]

[oracle@rac1 bin]$ crsctl query crs activeversionCRS active version on the cluster is [10.2.0.3.0]

SQL> select * from v$version;

BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProdPL/SQL Release 10.2.0.3.0 - Production


4/18

CORE 10.2.0.3.0 ProductionTNS for Linux: Version 10.2.0.3.0 - ProductionNLSRTL Version 10.2.0.3.0 - Production

Install 11.1.0.6 Oracle Home for ASM and Database

Mount the 11g Database DVD

[root@rac1 oracle]# umount /dev/hdc[root@rac1 oracle]# chmod 777 /media/cdrom[root@rac1 oracle]# mount /dev/hdc -t iso9660 -r /media/cdrom


5/18


6/18


7/18

Root.sh on Node 1

[oracle@rac1 db_1]$ su -Password:[root@rac1 ~]# /u01/app/oracle/product/11.1.0/db_1/root.shRunning Oracle 11g root.sh script...

The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/app/oracle/product/11.1.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)[n]:The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]:The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)


8/18

[n]:

Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.Finished product-specific root actions.

Root.sh on Node 2

[root@rac2 ~]# /u01/app/oracle/product/11.1.0/db_1/root.shRunning Oracle 11g root.sh script...


Enter the full pathname of the local bin directory: [/usr/local/bin]:The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)[n]:The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]:The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]:



9/18


10/18

Upgrade ASM and Databases Home to 11.1.0.7

Once the new 11.1.0.6 Homes are installed for ASM and Database, I did upgrade them to the last patch level, today is11.1.0.7.

Mount the disk with the 11.1.0.7 Patch

[root@rac1 ~]# umount /dev/hdc[root@rac1 ~]# mount /dev/hdc -t iso9660 -r /media/cdrom[root@rac1 ~]# ls -l /media/cdrom/total 2dr-xr-xr-x 1 root root 2048 Oct 16 17:58 11gpatch1

Execute the Oracle Universal Installer

[oracle@rac1 db_1]$ /media/cdrom/11gpatch1/Disk1/runInstallerStarting Oracle Universal Installer...

Checking Temp space: must be greater than 80 MB. Actual 1906 MB PassedChecking swap space: must be greater than 150 MB. Actual 2039 MB PassedChecking monitor: must be configured to display at least 256 colors. Actual 1 6777216 PassedPreparing to launch Oracle Universal Installer from /tmp/OraInstall2008-12-15_02 -38-44PM. Please wait ...[oracle@rac1 db_1]$ Oracle Universal Installer, Version 11.1.0.7.0 ProductionCopyright (C) 1999, 2008, Oracle. All rights reserved.


11/18


12/18


13/18

Execute root.sh on Node 1



Enter the full pathname of the local bin directory: [/usr/local/bin]:The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)[n]:The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]:The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)


14/18

[n]:


Execute root.sh on Node 2



Enter the full pathname of the local bin directory: [/usr/local/bin]:The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)[n]:The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]:The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]:



15/18


16/18

Upgrade ASM to 11.1.0.7

In this example I did upgrade ASM using the Database Upgrade Assistant, DBUA, it does upgrade also the listeners.


17/18


18/18

10g asm upgrade to 11g on linux

Documents

local bin directory

specific root actions

database configuration assistant

oracle rac1 bin

oracle rac1 db 1

database upgrade assistant

root rac1 oracle

oracle rac1