upgrade oracle on sg

[Shaik Hyder Shakeel]

this my steps i will do when upgrade oracle on sg , please check it if true or no# cmhaltpkg orapkg
activate all Oracle volume groups
# vgchange -a e vgora
mount /dev/vgora/oracle /u01
#make upgrade# cmhaltpkg orapkg
activate all Oracle volume groups
# vgchange -a e vgora
mount /vgora/oracle /u01
# make upgrade oracle and after upgrde comlete
# stop Oracle
# reconfigure package at sg
# vgchange -a n vg
#unmount /u01
# cmrunpkg orapkg


stop Oracle
# ifconfig lan0:1 0.0.0.0
# vgchange -a n vgora vgora2 vgoraredo
# cmrunpkg orapkg

[Steven E. Protter]

Shalom,

Full cold backup of data is required if the process touches oracle data.

Major oracle upgrades require a data conversion, which means downtime, even with high availability SG installations.

The plan seems reasonable but how can I tell without knowing the uptime requirements and the version of oracle before and after.

SEP

[Shaik Hyder Shakeel]

i will make upgrade from oracle 9i to 10g and is my steps
cmhaltpkg orapkg
# vgchange -a e vgora
mount /vgora/oracle /u01
make upgrade oracle and after upgrde comlete
# stop Oracle
# reconfigure package at sg

# vgchange -a n vg
#unmount /u01
# cmrunpkg orapkg
please tell me these steps is true and i can start upgrade with safe

[Ben Dehner]

As long as you can tolerate the downtime, the basic steps seem correct. Since the upgrade process requires controlled restarts outside of ServiceGuard, you need to temporarily remove the db from control of SG. If you have RAC, it may change the rules a bit, but the proce is:

halt the package
manually activate VGs and mount filesystems
ugrade the database
shutdown the database
dismount volume groups and umount filesytems
modify ServiceGuard ORACLE_HOME
start the package

Some other notes:

Insure you have a good backup before starting.

The upgrade uses an internal "bequeath" connection (as in "/ as sysdba"), so you don't need to worry about the lan settings or assigning the IP address. DBUA run locally will work fine without it.

Before re-starting the package, edit the ServiceGuard scripts to point to the new 10g ORACLE_HOME. ServiceGuard scripts typically do not read the /etc/oratab file to find the ORACLE_HOME.

Insure that the listener/IP address has been properly defined in the 10g ORACLE_HOME network configuration.

[Emil Velez]

Procedure looks sound

if you have the oracle executibles on each local node you will have to copy the new executibles to the other nodes before starting up the oracle package.

If your executibles are on the oracle volume group with the data this is unnecessary

[Shaik Hyder Shakeel]

please tell me steps step by step as commands line and i need to assign ip address when halting packge to interface of virutal cluster