upgrade oracle from 9i to 10g on sg

[Shaik Hyder Shakeel]

Do I need to halt package while I'm doing Oracle upgrade?

[Jeff Schussele]

That depends.
If SG is simply starting Oracle - then no you wouldn't need to stop the pkg.
BUT if SG is starting & monitoring Oracle processes then yes you'd need to stop the pkg because SG will keep attempting to restart the processes being monitored every time you attempt an Oracle halt.

Rgds,
Jeff Schussele

[Shaik Hyder Shakeel]

this answer no clear to me i neeed step by step as command line before start upgrade and after upgrade

[JaMeS_311]

hi,

i presume that for an upgrade you would have to close and re-open the database... but i am no oracle expert.

however,IF YOU USE THE TOOLKIT provided with serviguard to start/halt/monitor the database, then you should simply switch the database into maintenance mode. this is achieved by creating a dummy file called "oracle.debug" in the package home folder. this feature needs to be enabled in one of the package configuration scripts - i think it is haoracle.conf. in doing so, serviceguard stops monitoring the oracle processes so you can safely close the database without instigating a failover, deactivation of VGs, etc. syslog entries are provided in the corresponding package log file.

e.g.
# touch /etc/cmcluster/pkgname/oracle.debug
# tail -f /etc/cmcluster/pkgname/pkgname.cntl.log

when done, you can switch back to normal mode by simply removing the "oracle.debug" file.

e.g.
# rm /etc/cmcluster/pkgname/oracle.debug

i suggest you have a look at the readme file that comes with the toolkit for more details.

i hope this helps.

James

[Bart Paulusse]

In addition to the remarks made by James and Jeff:
If ORACLE_HOME is a seperate filsystem you will need to change this in your SG configuration as the ORACLE_HOME changes when upgrading from 9 to 10.
And, having SG, you will want to verify the clusters ability to succesfully failover after the upgrade.
I recommend getting someone with serviceguard experience on this upgrade, there are just too much possiblities to give you a simple list of commands to execute...

Regards,

Bart