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.
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Step 2 of 2:
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
-
![]()
How to manage Oracle database upgrades and annual releases
By: George Lawton
-
![]()
Oracle 19c database software promises stability, compatibility
By: George Lawton
-
![]()
DBA offers tips for navigating murky Oracle EBS 12.2.5 upgrade waters
By: Adam Hughes
-
![]()
Simple steps to follow for an Oracle 12c upgrade
By: Brian Peasland
Start the conversation
0 comments