upgrade oracle from 9i to 10g

[Shaik Hyder Shakeel]

do i need halt packge before start upgrade oracle 9i on SG envirment. please i need step by step procedure

[Avinash Agarkar]

Hi,

Yes you need to shutdown the package if the package is part of the database which you are going to upgrade.

Take the approriate backup of vg's.

check the system kernal parameter which you need to tune for 10g upgrade

take the current kernal backup and also make the backout plan ready with you.

thanks,
avinash

[Shaik Hyder Shakeel]

please tell me steps of upgrade oracle regarding service service gurad as command lines

[Frank de Vries]

I have done many upgrades of Oracle8 to 9i and 9i to 10g in SG env , without halting the package during the upgrade.

However BEWARE:
We use a lock file that needs to be touched/created in the cluster dir,
that turns of any monitoring, so that you don't halt the package but stopping an instance.

I Only halted the package after the upgrade and modifications to intergration script to test start/halt. Usually need 2 or 3 goes before all my scripts were clean.

With other words you do not have to change SG integration script(s) version, just because you change Oracle version.

Yes you need to adapt the control.ctl (or whatever you have called it) script from SG, but if you know a bit of scripting that is piece of cake.

[Frank de Vries]

Maybe this is helpfull:

go to www.oracle.com and browse the documentation for HPUX installation guide. They have a bunch of very good resources. The one you're looking for is here:

http://www.oracle.com/pls/db111/portal.portal_db?selected=11&frame=#hp-ux_installation_guides

Scroll down to HPUX installation guides and select the one that corresponds to your HPUX and Oracle products.

[Shaik Hyder Shakeel]

i understand from answer , no need to halt package when start upgrade but when upgrade complete how can halt packge when the package had changed to new version and the home file of pervious package was not found

[Shaik Hyder Shakeel]

please i need recomendation and procedure before start upgrade oracle 9i to 10g on sg