11i OS Upgrade

[Edgar_8]

Hi,

We currently running 11.0 & 8i Oracle DB and plan to clean install 11i.Is it advisable to also install Oracle 9i at the same time or wait aw while? What are the risks involved?

Any ideas or feedback would be appreciated.

Thanks

[Mark Grant]

I'm very conservative in these areas and would suggest you do one first and then the other. A clean install of 11i will most likely go smoothly but there are a bunch of patches to install for oracle on 11i or you just can't get it to install.

Our upgrade to 9i also went smoothly but for the allocation of the additional RAM for each database.

[A. Clay Stephenson]

I wouldn't do both at the same time. I would do the OS upgrade first and then the Oracle upgrade. Otherwise, should any problems occur, it would be difficult to know if it was Ella or if it was Memorex.

The Oracle 8i data will transfer perfectly with no more than a vgexport/vgimport but I would install/link the Oracle 8i binaries from scratch.

[Steven E. Protter]

It is advisable to not do two things at once.

If you want to bump up the OS, do that via a cold install. You can then to a fresh installation of Oracle 9i and migrate your data. You'll probably need new hardware or to borrow some hardware from HP during transition, but thats the way to go.

I recommend staying away from upgrade-ux.

SEP

[Edgar_8]

Hi Clay/SEP,

Thanks for the comments.My plan is as follows:
1.clean install 11i
2.clean install 9i

Do you think this will work?

[A. Clay Stephenson]

Edgar, your plan will almost certainly work and you can do the database migration "in-place" without an export/import but have a known good cold backup first.

Having said this, I wouldn't do it.

1) Cold install HP-UX 11.11 and latest Quality Packs. Tune kernel.

2) Cold Install Oracle 8i (and the same patchsets as on 11.0) but intentionally oversize your install location so that you can install 9i. I would have enough room (maybe in two filesystems) to install your current 8i and 9i binaries at the same time.

3) Startup Oracle 8i and test. If satisfied, NOW install Oracle 9i. You might consider loading the demo datatbase just so you know that you have valid binaries.

4) Finally, do the database migration. You should read the Oracle patchsets documentation carefully because often you cannot do a migration after a given patchset has been installed.

I would only do both simultaneously, iff (if and only if), I had do the exact migration first on a Sandbox.