We are upgrading Oracle and will want to create test cases to verify that the upgrade has not adversely affected the data or the applications that access this data.
I cannot emphasize enough the importance of testing prior to upgrading an Oracle database in production. Sometimes even a minor upgrade can uncover bugs or enhancements that cause application code to behave differently. Not only will you want to test the entire upgrade procedure from start to finish several times, but you will also want to create test cases as you've mentioned to test the applications supported by the Oracle database. Ensure that the application support teams have thoroughly tested after the database is upgraded, and also involve the business users if possible, since they may test different functionality that the application support teams are unaware of.
Dig Deeper on Oracle database installation, upgrades and patches
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."
Can I use /var/opt/oracle/oratab to specify listener information?
How many database instances can be created on an Oracle server with an installation drive containing 15 GB free space?