Q
Manage Learn to apply best practices and optimize your operations.

Creating test cases for upgrade

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.

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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close