Greetings! Great site. My company is looking to upgrade to Oracle 10g as well as do a hardware/OS upgrade. I don't have any more details on the hardware but I'm looking for some tips on testing. In other companies we have done a regression of the software when the hardware was upgraded to ensure the software was still functional. Not sure if we should that approach or look for some other method. Any ideas on hardware testing?
I like your idea of doing a software regression. We've also done this in the past for hardware upgrades, OS or DB upgrades, etc. This gives you confidence in the functionality of the application in its new configuration.
What are some other ideas you have about testing the hardware? Not sure what your role is on the project, but what expectations do your DBAs and System Admins have out of any sort of testing you might want to do and how will they support the effort? Are there any upgrade-specific features that need to be tested? What information do your users need before they will sign-off on the implementation?
One approach we've used is "before/after" performance testing. Run a performance test against the current system and another on the upgraded system. Would you expect your performance to improve and did it? If not, why?
How about a "burn-in" period for the hardware? Run it continuously under load for a week or so to make sure everything is stable. In my mainframe days, we'd implement all new hardware in development and let it stay there for a month or so to make sure no critical components would fail after having been powered up and in use.
Hope this is enough to get you started! I'm sure others will have more to add. [img]/images/graemlins/cool.gif[/img]