Step By Step: Upgrade Oracle 10g R2 RAC 10.2.0.1 to 10.2.0.3 on Oracle Enterprise Linux 5.5 (32 bit) Platform.

By Bhavin Hingu

 

<<PREV                 

 

Step By Step: Upgrade Clusterware, ASM and Database from 10.2.0.1 to 10.2.0.3.

 

Backing up the ORACLE_HOMEs before the upgrade:

 

Steps I followed to take the Backup of ORACLE_HOMEs before the upgrade: (This can be applied to 11gR1 and 10g databases).

 

On node1:

 

mkdir backup

cd backup

 

dd if=/dev/dev/raw1 of=ocr_disk.bkp

dd if=/dev/dev/raw3 of=voting_disk.bkp

 

tar cvf node1_crs.tar /u01/app/oracle/crs/*

tar cvf node1_asm.tar /u01/app/oracle/asm/*

tar cvf node1_db.tar /u01/app/oracle/db/*

tar cvf node1_etc_oracle /etc/oracle/*

 

cp /etc/inittab /etc_inittab

 

mkdir etc_init_d

cd etc_init_d

cp /etc/init.d/init* .

 

On node2:

 

mkdir backup

cd backup

 

tar cvf node2_crs.tar /u01/app/oracle/crs/*

tar cvf node2_asm.tar /u01/app/oracle/asm/*

tar cvf node2_db.tar /u01/app/oracle/db/*

tar cvf node2_etc_oracle /etc/oracle/*

 

cp /etc/inittab /etc_inittab

 

mkdir etc_init_d

cd etc_init_d

cp /etc/init.d/init* .

 

On node3:

 

mkdir backup

cd backup

 

tar cvf node3_crs.tar /u01/app/oracle/crs/*

tar cvf node3_asm.tar /u01/app/oracle/asm/*

tar cvf node3_db.tar /u01/app/oracle/db/*

tar cvf node3_etc_oracle /etc/oracle/*

 

cp /etc/inittab /etc_inittab

 

mkdir etc_init_d

cd etc_init_d

cp /etc/init.d/init* .

 

 

 

RMAN full backup was taken.

 

Upgrade 10gR2 Clusterware from 10.2.0.1 to 10.2.0.3 in Rolling Fashion (No Downtime):

 

On Node1:

 

Stop the labdb1 instance, asm instance, nodeapps. Relocate any db or cluster service resources to the other nodes. Stop and disable the CRS on this node and then reboot the node to clean up any oracle related processes. Once the node comes backup, enable the crs back and start the runInstaller from the 10203 software directory.

 

srvctl stop instance -d labdb i labdb1

srvctl stop asm n node1

srvctl stop nodeapps n node1

crs_relocate ora.labdb.db

crsctl stop crs

crsctl disable crs

reboot

 

crsctl enable crs once the node comes backup after the reboot.

./runInstaller ignoreSysPrereqs

/u01/app/oracle/crs/install/root102.sh run this script at the end as root

 

Verify the CRS

 

crsctl check crs (on all the node) it should be up on all the nodes

crsctl query crs activeversion node1

crsctl query crs activeversion node2

crsctl query crs activeversion node3

crsctl query crs softwareversion node1

crsctl query crs softwareversion node2

crsctl query crs softwareversion node3

 

 

01.jpg

 

02.jpg

 

01.JPG

 

02.JPG

03.JPG

05.JPG

 

06.JPG

 

On Node2:

 

Stop the labdb2 instance, asm instance, nodeapps. Relocate any db or cluster service resources to the other nodes. Stop and disable the CRS on this node and then reboot the node to clean up any oracle related processes.

Once the node comes back up, enable the crs and run the /u01/app/oracle/crs/install/root102.sh script as root.

 

srvctl stop instance -d labdb i labdb2

srvctl stop asm n node2

srvctl stop nodeapps n node2

crs_relocate ora.labdb.db

crsctl stop crs

crsctl disable crs

reboot

 

crsctl enable crs once the node comes backup after the reboot.

/u01/app/oracle/crs/install/root102.sh run this script at the end as root

 

Verify the CRS

 

crsctl check crs (on all the node) it should be up on all the nodes

crsctl query crs activeversion node1

crsctl query crs activeversion node2

crsctl query crs activeversion node3

crsctl query crs softwareversion node1

crsctl query crs softwareversion node2

crsctl query crs softwareversion node3

 

 

07.JPG

 

08.JPG

 

On Node3:

 

Stop the labdb3 instance, asm instance, nodeapps. Relocate any db or cluster service resources to the other nodes. Stop and disable the CRS on this node and then reboot the node to clean up any oracle related processes.

Once the node comes back up, enable the crs and run the /u01/app/oracle/crs/install/root102.sh script as root.

 

srvctl stop instance -d labdb i labdb3

srvctl stop asm n node3

srvctl stop nodeapps n node3

crs_relocate ora.labdb.oltp.cs

crsctl stop crs

crsctl disable crs

reboot

 

crsctl enable crs once the node comes backup after the reboot.

/u01/app/oracle/crs/install/root102.sh run this script at the end as root

 

Verify the CRS

 

crsctl check crs (on all the node) it should be up on all the nodes

crsctl query crs activeversion node1

crsctl query crs activeversion node2

crsctl query crs activeversion node3

crsctl query crs softwareversion node1

crsctl query crs softwareversion node2

crsctl query crs softwareversion node3

 

 

09.JPG

 

10.JPG

 

Upgrade 10gR2 ASM from 10.2.0.1 to 10.2.0.3:

 

Stop database labdb, asm instance, asm listener from ASM_HOME. Invoke the runInstaller from 10.2.0.3 Patchset directory and select the ASM_HOME to be upgraded.

 

srvctl stop database d labdb

srvctl stop asm n node1

srvctl stop asm n node2

srvctl stop asm n node3

srvctl stop listener l LISTENER_NODE1 n node1

srvctl stop listener l LISTENER_NODE2 n node2

srvctl stop listener l LISTENER_NODE3 n node3

./runInstaller ignoreSysPrereqs

 

At the End, run the root.sh as root on all the nodes.

 

Invoke dbua to upgrade the ASM to 10.2.0.3

 

01.JPG02.JPG03.JPG04.JPG05.JPG

06.JPG

 

Upgrade 10gR2 DB from 10.2.0.1 to 10.2.0.3:

 

Stop database labdb, db Listener from DB_HOME. Invoke the runInstaller from 10.2.0.3 Patchset directory and select the DB_HOME to be upgraded.

 

srvctl stop database d labdb

srvctl stop listener l LAB_LISTENER_NODE1 n node1

srvctl stop listener l LAB_LISTENER_NODE2 n node2

srvctl stop listener l LAB_LISTENER_NODE3 n node3

./runInstaller -ignoreSysPrereqs

 

At the End, run the root.sh as root on all the nodes.

 

Invoke dbua to upgrade the Database to 10.2.0.3

 

01.JPG02.JPG03.JPG04.JPG05.JPG

06.JPG

 

Upgrade Database using DBUA:

 

01.JPG02.JPG03.JPG04.JPG05.JPG06.JPG

 

07.JPG

 

 

<<PREV                 

 

 

HTML Comment Box is loading comments...