X

Alejandro Vargas' Blog

  • October 3, 2008

Real Application Testing on 10g/11g Step-by-Step

Alejandro Vargas
Technical Leader, ACS Global Delivery, Infrastructure & BigData

In this post I'm reviewing Real Application Testing Database Reply and SQL Performance Analyzer step by step.

The initial understanding of the implementation process demand some work, but the results are excellent and worth the effort, we get valuable information to asses how our systems will behave after change, something much needed for production environments.

The document I'm attaching to this post cover the functional tests I did of both Database Replay and SQL Performance Analyzer, I'm still working on the following stages of evaluating a production load on a different platform.

The test steps can be followed on this document Real Application Testing on 10g and they are the following:

1.

Clone production database on test server, start it up



2.

Create 11g database on test server on Windows

3.

Download patch 6998002 for Windows 32 bit



4.

Download patch 6903335 for Windows 32 bit



5.

Download patch 7044721 for 11.0.6.1 on windows



6.

Download patch 6974999 for 10.2.0.3 on Linux



7.

Download RAT scripts and docs from OTN



8.

Install patch 6998002 on Windows 10g clone database



9.

Install patch 6903335 on Windows 10g clone database



10.

Install patch 7044721 on Windows 11g test database

11.

Install patch 6974999 on Linux 10g test database



12.

Configure and execute functional RAT tests on Windows

13.

Install 11g on Linux

14.

Create 11g Database on Linux



15.

Migrate clone of production Database from windows to Linux



16.

Configure and execute functional RAT tests on Linux



17.

Install patch 6903335 on production database



18.

Capture load on production Database



19.

Replay production load on Linux

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services