【Oracle123】Oracle升级至13的应用程序相关集成测试计划

项目应用的Oracle数据库面临新的升级(12to13)。

作为应用程序的测试人员，需要准备一套应用程序层面的集成测试计划。

为了避免落入先入为主的傻瓜式断论，需要系统的梳理一下如果做这个计划。

How to prepare for Oracle Database Upgrade

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/develop-a-test-plan-for-upgrading-database.html#GUID-1CE27BA9-26B0-491D-89EB-A01F06CEC9D2

由于公司组织架构的关系，有专门的DBA团队负责Oracle Instance的升级。

故这里会摘出省略油管DBA操作和测试的环节，其实严格来讲，作为应用程序的QA，是需要了解DBA做了哪些测试工作，作为集成测试的前期测试。这里着重应用层面的测试计划。

Become Familiar with New Oracle Database Features 

Choose an Upgrade Method for Oracle Database (DBA)

Develop a Test Plan for Upgrading Oracle Database

• • Upgrade Testing (DBA)
    Create, test, and validate an upgrade plan.
  • Minimal Testing (QA)
    Minimal testing can find application startup or invocation problems.
  • Functional Testing After Upgrades (DBA & QA)
    Perform functional testing of the upgraded Oracle Database after the upgrade is complete.
  • High Availability Testing 
    Plan to perform High Availability testing on your upgraded system.
  • Integration Testing to Ensure Applications are Compatible
    Integration testing for Oracle Database examines the interactions among components of the system.
  • Performance Testing an Upgraded Oracle Database
    Plan performance testing comparisons between your earlier release and new release Oracle Database.
  • Volume and Load Stress Testing for Oracle Database Upgrades
    Use Database Replay to perform volume and load stress testing of the entire upgraded Oracle database under high volume and loads.
  • Test Plan Guidelines for Oracle Database Upgrade Planning
    Perform planned tests on your current database and on the test database that you upgraded to the new Oracle Database release.

Practice upgrading the database using the test environment. The best practice is to perform testing of the upgrade process on an exact copy of the database that you want to upgrade, rather than on a downsized copy or test data. If an exact copy is impractical, then carefully chose a representative subset of your data to move over to your test environment and test the upgrade on that data.