Upgrade plan for 8.1.7 to 9.2
We are currently building an upgrade plan for our 8.1.7 conversion to 9.2, and we are struggling with upgrading all the clients (MS, XP, NT, 2000 and 2003) from 8.1.7 to 9.2. Do you have a recommendation and do you have any Oracle links to review?
I've seen some places use custom software packagers (I think Symantec's Ghost Corporate Edition can do this) that take a snapshot of a system (including registry entries and filesystem files), then make the desired changes (deinstall old client, install new client), followed by a through "diff" of the whole system including the registry. The tool then uses this "diff" information to generate a set of actions (i.e. delete some files, create some files, modify some registry entries) and package that into an installer that resembles most Windows installs. That's worked well if your clients have their current software installed in a similar manner.
If your issue is related to having to run the Oracle Installer and make appropriate choices on each desktop, then you may consider using response files (http://download-west.oracle.com/docs/cd/B10501_01/em.920/a96697/rsp.htm) or make a custom install package using the Oracle Software Packager (http://otn.oracle.com/products/osp/index.html).
This was first published in March 2004