Dear all,

Is it possible to upgrade from 11.5.2 to 11.5.9 ?  Should we first upgrade from 11.5.2 to 11.5.x and then to 11.5.9 ? Thanx in advance for the help i wud get…

Regards,
Manjunath

Hi Manjuanth
If you have access to Oracle support then I would raise a Tar on this as they should quickly be able to clarify this for you. They should have an upgrade matrix which will tell you quickly what the path should be.
Let me know if you do not and I will try to help get the information for you. If you have the 11.5.9 doco you may find it in there on the CD’s under the upgrade notes.
One further question do you need to start with 11.5.2?
Good luck Cel

Hi Cel,

Well i think it good to start learning from 11.5.2,..Explore...Discover...really to try Hard..

Thanx
Manjunath

Hi,

Yes, you should be able to upgrade form 11.5.2 to 11.5.9 or even the latest release of 11.5.10.  Given the numerous functional and technical enhancements since 11.5.2, I would suggest making a clone of your production environment and running through a couple of iterations of a mock upgrade.  There will certainly be issues encountered along the way, and an iterative process will allow you to work them out as well as give you an estimate of the downtime required when you do your production envirlonment.

You should read all the release notes.  You might be able to take a phased approach - upgrade the database first, then apache, JInitiator, then apply the maintenance patches, etc.  If you have a limitied down time window, this may be your best approach.

The maintenance packs from Oracle have been cumulative so far, which means you can upgrade any prior release of 11.5.X up to the the maintenance pack you’ve chosen to apply.  The down side to this is that the current maintenance packs are quite large since they are designed to allow anyone on 11i to upgrade.  I’ve heard in the future that some patches will require a baseline in order to apply them.  In other words, you might have to be on 11.5.8 or higher in order to apply a particular patch.  So far I haven’t seen a patch that supports this yet.

Good Luck and keep us posted on your progress!

Regards,
Michael Siebert

Hi Manjunath,

upgrading from 11.5.2 to a recent release is for sure possible and is a real interesting exercise.

You must choose first your destination release.

Your RDBMS need to be a 9i to be able to upgrade to 11.5.10. 11.5.2 does not support 9i RDBMS. 11.5.7 release is the first release upgradable to 9i. So I would recommand you to choose your destination release to 11.5.9 or (at least) 11.5.7 as a intermediate realase.

To upgrade, you have to follow the maintenance pack. The most important step is the technology stack check (in the pre-upgrade part). You should do these pre-upgrade before starting the real upgrade phase Since this part is only upgrading the technology stack it should have few effect on the application functionnalities. The non regression tests should be simple for this pre-upgrade part.

After the technology stack requirements passed, you must think of running (at least) two iterations. The fisrt iteration (technical instance) improves the upgrade process, lets you resolving the technical problems. You might check the upgrade without including the end-user side. Then, you should be able to establish a road map for the upgrade. Run a second iteration (functional instance) to improve your road map and provide a real test instance for functional tests. If you did a good roadmap, you should be able to run in a short time. At this time, log all the timestamps to be able to decide later the downtime of the production database for the upgrade. You would have to add few post-patches after the upgrade.

Try to consider the upgrade of the customizations separetely.

If you upgrade to a recent release (11.5.9) you should include the consolidated path (over 11.5.9).

Keep in mind that every node and language increase the upgrade process.

Don’t forget the side effect on the client side (upgrade of jinitiator is mandatory, included in the technology stack phase) and the ADI must be upgraded two.

The main enhancement for administrators is the context file which manage almost everthing related to the technology stack. This allow you to easilly create a clone and move the node to different operating system (move to linux as an example).

I just did a upgrade from 11.5.4 to 11.5.9 from Unix Tru64 to Linux RHE9. Don’t hesitate to contact me.

Have fun,

PiJi

Thanx Piji...Sure i will keep in touch…

Regards,
Manjunath