My Oracle Support Banner

Mandatory Patches for Database Testing Functionality for Current and Earlier Releases (Doc ID 560977.1)

Last updated on OCTOBER 25, 2018

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Details

Oracle Database 11g introduces Database Replay and SQL Performance Analyzer as part of the Real Application Testing option. Real Application Testing provides businesses with the  the capability of identifying  issues with system and database  changes before production deployment. The main goal of making Real Application Testing functionality available in earlier releases is to enable customers to upgrade to higher database releases.

This note provides information on the Real Application Testing functionality available for pre-11g database releases as well as mandatory patches that are required for 11g databases.

SQL Performance Analyzer allows users to identify SQL performance regressions caused by system changes such as adding an index, gathering optimizer statistics, implementing partitioning, RDBMS upgrades, etc. SQL Performance Analyzer assesses the impact of change on SQL response times by executing each SQL serially with production context (bind variables, optimizer environment, etc.) before and after a change and then providing a report highlighting any performance divergences.

Database Replay allows users to perform comprehensive testing of database and infrastructure changes using real application workloads. It allows capture of production workload including concurrency, think time, and transactions dependencies, and allows users to replay the workload on a test system with the exact same production characteristics so that all problems can be identified and remediated in test before deploying the change to production.

Please check the Licensing Information manual on OTN for details regarding licensing of Real Application Testing Option.

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Tuning.

Actions

Real Application Testing on Earlier Releases

To install Real Application Testing functionality on pre-11g database releases, opatch utility should be used. Follow the instructions for the generic and platform specific README for the patches. If you want to only use Database Replay or SQL Performance Analyzer, then only the patch(es) for that particular functionality need to be applied. If you want to use both Database Replay and SQL Performance Analyzer, the patches for both the functionalities need to be applied.

Database Replay

To assist customers in upgrading to Oracle Database 11g and higher, the capture functionality of Database Replay has been made available in previous releases as shown in the table below.
NOTE: The replay of the captured workload can only be done on Oracle Database 11g and higher.
Please refer to Oracle documentation on OTN for information on the capture part of Database Replay available for the earlier releases.

Table 1: Database Replay Availability Information for All Platforms except Windows

NOTE:

  • These are mandatory patches
  • Table may not show all possible combinations
  • Any new Fixes, patches or merge patches for Real Application Testing will be provided as per Oracle’s Error Correction Support Policy documented in Database, FMW, EM Grid Control, and OCS Software Error Correction Support Policy Document 209768.
  • This note is available only for the DB that can download and apply patch 9373986.

 

Source DB Upgrade from releaseDestination DB Upgrade to any releaseWhat patch you need to apply?Download InformationComments
9.2.0.8.0 >=11.1.0.6.0 9.2.0.8.0 + one-off patch 9373986

For AIX platform one-off patch 13370576 (it includes 9373986)
One-off patch can be downloaded or requested from MOS
Please use bug number when downloading patch if patch does not appear for your version
One-off patch can be downloaded from MOS
9.2.0.8.0 >=11.1.0.7.0 9.2.0.8.0 + one-off patch 9373986 +

For AIX platform one-off patch 13370576 (it includes 9373986)


one-off patch
8712466 on top of 11.1.0.7.0
One-off patch can be downloaded or requested from MOS 8712466 is a merge patch on top of 11.1.0.7.0
9.2.0.8.0 >=11.2.0.1.0 9.2.0.8.0 + one-off patch 9373986

For AIX platform one-off patch 13370576 ( it includes 9373986)
One-off patch can be downloaded or requested from MOS One-off patch can be downloaded from MOS
9.2.0.8.0 >=11.2.0.2.0

9.2.0.8.0 + one-off patch 9373986

For AIX platform one-off patch 13370576 (it includes 9373986)


and 11.2.0.2.0 + patch 13947480

One-off patch can be downloaded from MOS

One-off patch can be downloaded from MOS

 

9.2.0.8.0 >=11.2.0.3.0 9.2.0.8.0 + one-off patch 9373986

For AIX platform one-off patch 13370576 ( it includes 9373986)

and 11.2.0.3.0 + patch 17411249
One-off patch can be downloaded or requested from MOS

One-off patch can be downloaded or requested from MOS

 

9.2.0.8.0 >=11.2.0.4.0

9.2.0.8.0 + one-off patch 9373986

For AIX platform one-off patch 13370576 ( it includes 9373986)

and 11.2.0.4.0 + patch 17411249

or

11.2.0.4.0 + patch 19383974 (It includes 17411249)

One-off patch can be downloaded or requested from MOS

One-off patch can be downloaded or requested from MOS

10.2.0.2.0 >=11.1.0.6.0 10.2.0.2.0 + one-off patch 9373986 One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
10.2.0.2.0 >=11.1.0.7.0

10.2.0.2.0 + one-off patch 9373986 and

one-off patch 8712466 on top of 11.1.0.7.0

One-off patch can be downloaded or requested from MOS 8712466 is a merge patch on top of 11.1.0.7.0
10.2.0.2.0 >=11.2.0.1.0 10.2.0.2.0 + one-off patch 9373986 One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
10.2.0.2.0 >=11.2.0.2.0

10.2.0.2.0 + one-off patch 9373986

and 11.2.0.2.0 + patch 13947480

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
10.2.0.2.0 >=11.2.0.3.0

10.2.0.2.0 + one-off patch 9373986

and 11.2.0.3.0 + patch 17411249

One-off patch can be downloaded or requested from MOS

One-off patch can be downloaded or requested from MOS

10.2.0.2.0  >=11.2.0.4.0

10.2.0.2.0 + one-off patch 9373986

and 11.2.0.4.0 + patch 17411249

or

11.2.0.4.0 + patch 19383974 (It includes 17411249)

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
10.2.0.3.0 >=11.1.0.6.0 10.2.0.3.0 + one-off patch 9373986 One-off patch can be downloaded from MOS One-off patch can be downloaded from MOS
10.2.0.3.0 >=11.1.0.7.0 10.2.0.3.0 + one-off patch 9373986+ one-off patch 8712466 on top of 11.1.0.7.0 One-off patch can be downloaded from MOS 8712466 is a merge patch on top of 11.1.0.7.0
10.2.0.3.0 >=11.2.0.1.0 10.2.0.3.0 + one-off patch 9373986 One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
10.2.0.3.0 >=11.2.0.2.0

10.2.0.3.0 + one-off patch 9373986

and 11.2.0.2.0 + patch 13947480

One-off patch can be downloaded from MOS One-off patch can be downloaded from MOS
10.2.0.3.0 >=11.2.0.3.0

10.2.0.3.0 + one-off patch 9373986

and 11.2.0.3.0 + patch 17411249

One-off patch can be downloaded or requested from MOS

One-off patch can be downloaded or requested from MOS

 

10.2.0.3.0 >=11.2.0.4.0

10.2.0.3.0 + one-off patch 9373986

and 11.2.0.4.0 + 17411249

or

11.2.0.4.0 + patch 19383974 (It includes 17411249)

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
10.2.0.4.0 >= 11.1.0.6.0 10.2.0.4.0 Patchset + one-off patch 10239989 Patchset can be downloaded from MOS Functionality already exists in Patchset, download from MOS
Enable workload capture by following instructions below
10.2.0.4.0 >=11.1.0.7.0 10.2.0.4.0 patchset+ one-off patch 10239989 + one-off patch 8712466 on top of 11.1.0.7.0 Patchset can be downloaded from MOS

Functionality already exists in Patchset, download from Metalink


Enable workload capture by following instructions below

8712466 is a merge patch on top of 11.1.0.7.0

10.2.0.4.0 >=11.2.0.1.0 10.2.0.4.0 Patchset + one-off patch 10239989 Patchset can be downloaded from MOS Functionality already exists in Patchset, download from MOS


Enable workload capture by following instructions below
10.2.0.4.0 >=11.2.0.2.0

10.2.0.4.0 Patchset + one-off patch 10239989

and 11.2.0.2.0 + patch 13947480

Patchset can be downloaded from MOS Functionality already exists in Patchset, download from MOS

Enable workload capture by following instructions below
10.2.0.4.0 >=11.2.0.3.0

10.2.0.4.0 Patchset + one-off patch 10239989

and

11.2.0.3.0 + patch 17411249

Patchset can be downloaded from MOS

Functionality already exists in Patchset, download from MOS

Enable workload capture by following instructions below

10.2.0.4.0 >=11.2.0.4.0

10.2.0.4.0 Patchset + one-off patch 10239989

and

11.2.0.4.0 + patch 17411249

or

11.2.0.4.0 + patch 19383974 (It includes 17411249)

Patchset can be downloaded from MOS

Functionality already exists in Patchset, download from MOS

Enable workload capture by following instructions below

10.2.0.5.0 >=11.2.0.1.0

10.2.0.5.0 Patchset + one-off patch 9373986

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
10.2.0.5.0 >=11.2.0.2.0 10.2.0.5.0 Patchset + one-off patch 9373986
and
11.2.0.2.0 + patch 13947480
One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
10.2.0.5.0 >=11.2.0.3.0

10.2.0.5.0 Patchset + one-off patch 9373986


and
11.2.0.3.0 + patch 17411249

One-off patch can be downloaded or requested from MOS

One-off patch can be downloaded or requested from MOS

 

10.2.0.5.0 >=11.2.0.4.0

10.2.0.5.0 Patchset + one-off patch 9373986
and

11.2.0.4.0 + patch 17411249

or

11.2.0.4.0 + patch 19383974 (It includes 17411249)

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
11.1.0.6.0 >=11.2.0.1.0 11.1.0.6.0  + one-off patch 8712466 + 9373986 One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
11.1.0.6.0 >=11.2.0.2.0 11.1.0.6.0 + one-off patch 8712466 + 9373986

and

11.2.0.2.0 + patch 13947480
One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
11.1.0.6.0 >=11.2.0.3.0

11.1.0.6.0 + one-off patch 8712466 + 9373986

and

11.2.0.3.0 + patch  17411249

One-off patch can be downloaded or requested from MOS

One-off patch can be downloaded or requested from MOS

 

11.1.0.6.0 >=11.2.0.4.0

11.1.0.6.0 + one-off patch 8712466 + 9373986

and

11.2.0.4.0 + patch 17411249

or

11.2.0.4.0 + patch 19383974 (It includes 17411249)

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
11.1.0.7.0 >=11.2.0.1.0 11.1.0.7.0 + one-off patch 8712466 + 9373986 One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
11.1.0.7.0 >=11.2.0.2.0 11.1.0.7.0 + one-off patch 8712466 + 9373986

and

11.2.0.2.0 + patch 13947480
One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
11.1.0.7.0 >=11.2.0.3.0

11.1.0.7.0 + one-off patch 8712466 + 9373986

and

11.2.0.3.0 + patch 17411249

One-off patch can be downloaded or requested from MOS

One-off patch can be downloaded or requested from MOS

 

11.1.0.7.0 >=11.2.0.4.0

11.1.0.7.0 + one-off patch 8712466 + 9373986

and

11.2.0.4.0 + patch 17411249

or

11.2.0.4.0 + patch 19383974 (It includes 17411249)

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
11.2.0.1.0 >=11.2.0.2.0

11.2.0.1.0 + one-off patch 9373986

and

11.2.0.2.0 +  patch 13947480

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
11.2.0.1.0 >=11.2.0.3.0

11.2.0.1.0 + one-off patch 9373986

and

11.2.0.3.0 + patch 17411249

One-off patch can be downloaded or requested from MOS

One-off patch can be downloaded or requested from MOS

 

11.2.0.1.0 >=11.2.0.4.0

11.2.0.1.0 + one-off patch 9373986

and

11.2.0.4.0 + patch 17411249

or

11.2.0.4.0 + patch 19383974 (It includes 17411249)

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
11.2.0.2.0 >= 11.2.0.2.0

Capture side

No capture side patches are needed for 11.2.0.2.0

and

Replay Side

11.2.0.2.0 + patch 13947480

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
11.2.0.2.0 >=11.2.0.3.0

Capture side

No capture side patches are needed for 11.2.0.2.0

and

Replay Side

11.2.0.3.0 + patch 17411249

One-off patch can be downloaded or requested from MOS

One-off patch can be downloaded or requested from MOS

 

11.2.0.2.0 >=11.2.0.4.0

Capture side

No capture side patches are needed for 11.2.0.2.0

and

Replay Side

11.2.0.4.0 + patch 17411249

or

11.2.0.4.0 + patch 19383974 (It includes 17411249)

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
11.2.0.3.0 >=11.2.0.3.0

Capture side

No capture side patch are needed for 11.2.0.3.0

and

Replay side

11.2.0.3.0 + patch 17411249

One-off patch can be downloaded or requested from MOS

One-off patch can be downloaded or requested from MOS

 

11.2.0.3.0 >=11.2.0.4.0

Capture side

No capture side patch are needed for 11.2.0.3.0

and

Replay side

11.2.0.4.0 + patch 17411249

or

11.2.0.4.0 + patch 19383974 (It includes 17411249)

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
11.2.0.4.0 >=11.2.0.4.0

Capture side

No capture side patch is needed for 11.2.0.4.0

and

Replay side

11.2.0.4.0 + 17411249

or

11.2.0.4.0 + patch 19383974 (It includes 17411249)

One-off patch can be downloaded or requested from MOS One-off patch can be downloaded or requested from MOS
9.2.0.8.0 and till 11.2.0.1.0 >=12.1.0.2.0

Capture side

Please apply respective capture side patch as documented in one of the above boxes

and Replay side

12.1.0.2.0 + 19562893

 or

12.1.0.2.0 + 21117072 (This includes 19562893)

 One-off patch can be downloaded or requested from MOS  One-off patch can be downloaded or requested from MOS
11.2.0.2.0 and above =12.1.0.1.0

Capture side

No capture side patch is needed for 11.2.0.2.0 and above

and Replay side

** There is no RAT Patch Bundle 1 for 12.1.0.1.0 as patches are no longer being released by Oracle for 12.1.0.1.0.  Customers are encouraged to upgrade to 12.1.0.2.0 or later.
No Replay side Patches available for 12.1.0.1.0 for RAT Patch Bundle 1.  Patches are no longer being released for 12.1.0.1.0, therefore cannot be requested.  
11.2.0.2.0 and above >=12.1.0.2.0

Capture side

No capture side patch is needed for 11.2.0.2.0 and above

and Replay side

12.1.0.2.0 + 19562893

or

12.1.0.2.0 + 21117072 (This includes 19562893)

 One-off patch can be downloaded or requested from MOS  One-off patch can be downloaded or requested from MOS
11.2.0.2.0 and above >=12.2.0.1.0

Capture side

No capture side patch is needed for 11.2.0.2.0 and above

and Replay side

No replay side patch is needed for 12.2.0.1.0 and above at this time

   
11.2.0.2.0 and above >=18.1.0.1.0

Capture side

No capture side patch is needed for 11.2.0.2.0 and above

and Replay side

No replay side patch is needed for 18.1.0.1.0 and above at this time

   
         
Table 2: Database Replay Availability Information Windows Platform

Note:

Source DB Upgrade from releaseDestination DB Upgrade to any releaseWhat patch you need to apply?Download InformationComments
9.2.0.8.0 For Windows 32-bit

>=11.1.0.6.0

including 11.2.X

9.2.0.8.0 + patch bundle 7047008 Patch bundle can be downloaded from MOS Patch Available as part of Bundle 18.
9.2.0.8.0 For Windows Itanium 64-bit

>=11.1.0.6.0

including 11.2.X

9.2.0.8.0 + patch bundle 7047015 Patch bundle can be downloaded from MOS Patch Available as part of Bundle 18.
10.2.0.3.0 For Windows 32-bit

>=11.1.0.6.0

including 11.2.X

10.2.0.3.0 + patch bundle 6998002 Patch bundle can be downloaded from MOS Patch Available as part of Bundle 23.
10.2.0.3.0 For Windows Itanium 64-bit

>=11.1.0.6.0

including 11.2.X

10.2.0.3.0 + patch bundle 6998003 Patch bundle can be downloaded from MOS Patch Available as part of Bundle 23.
10.2.0.3.0
For Windows 64-bit AMD64 AND Intel EM64T XP AND 2003

>=11.1.0.6.0

including 11.2.X

10.2.0.3.0 + patch bundle 6998004 Patch bundle can be downloaded from MOS Patch Available as part of Bundle 23.
10.2.0.4.0
(Windows 32-bit, Windows Itanium Windows 64-bit AMD64 AND Intel EM64T XP AND 2003)

>= 11.1.0.6.0

including 11.2.X

10.2.0.4.0 Patchset + one-off patch 8542772 Patchset can be downloaded from MOS: 6810189

Functionality already exists in Patchset, download from MOS.


One-off patch 8542772 needs to be requested.

Enable workload capture by following instructions

10.2.0.5.0 ( all windows platform )

>=11.1.0.6.0

including 11.2.X

No mandatory patches needed.

Functionality already exists in Patchset.
Patchset can be downloaded from MOS Functionality already exists in Patchset, download from MOS.
Enabling Workload Capture (Only Required for 10.2.0.4.0)

By default, the workload capture is disabled on the pre-11g database releases. Database workload capture functionality is enabled on the system by specifying the PRE_11G_ENABLE_CAPTURE initialization parameter. In order to enable workload capture on 10.2.0.4  run the wrrenbl.sql script at the SQL prompt as SYS or SYSTEM as follows:

@$ORACLE_HOME/rdbms/admin/wrrenbl.sql

The wrrenbl.sql script calls the ALTER SYSTEM SQL statement to set the PRE_11G_ENABLE_CAPTURE initialization parameter to TRUE.
This step is NOT required for version lower then 10.2.0.4.0
Please check the OTN documentation mentioned above for more details.

SQL Performance Analyzer

SQL Performance Analyzer functionality has been enhanced and made available in earlier releases to help customers upgrade their databases from Oracle 9.x, 10.1.x, and 10.2.x to higher releases. Applying the one-off patches shown below will install the SQL Performance Analyzer functionality for that release. After the functionality has been installed, customers can then leverage Oracle Database 11g SQL Performance Analyzer functionality to upgrade from any database releases 9.x, 10.1.x, 10.2.x to 10.2 or higher release. The one-off patches that need to be applied depend on the version of the source and the destination databases as indicated in the table below.

Further information on this topic is available in the technical white paper:

It is recommended to review this document before using SQL Performance Analyzer functionality for earlier releases.

Table 3: SQL Performance Analyzer Availability Information

Note:

Source DB Upgrade from releaseDestination DB Upgrade to releaseWhat patch you need to apply?DownloadComments
9.x 10.2.0.2.0

i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809
or

Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594

or


Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.

Using the latest version of Oracle database is Recommended.



AND

ii) Destination DB 10.2.0.2 + one-off patch 6903322

 

One-off patch can be Downloaded from MOS No patches are needed on the source side 9.x

11g test database does not need to have application schema /data
9.x 10.2.0.3.0

i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809

or

Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594

or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.


Using the latest version of Oracle database is Recommended.

 
AND

ii) Destination DB 10.2.0.3 + one-off patch 6903335

 

One-off patch can be Downloaded from MOS No patches are needed on the source side 9.x

11g test database does not need to have application schema /data
9.x 10.2.0.4.0

i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809

or

Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594

or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.


Using the latest version of Oracle database is Recommended.


AND
ii) Destination DB 10.2.0.4 + one-off patch: 6893073

 

 

One-off patch can be Downloaded from MOS No patches are needed on the source side 9.x

11g test database does not need to have application schema /data
9.x 10.2.0.5.0

i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809

or

Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594

or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.


Using the latest version of Oracle database is Recommended.


AND
ii) Destination DB 10.2.0.5 wit RAT option.

 

 

One-off patch can be Downloaded from MOS No patches are needed on the source side 9.x

11g test database does not need to have application schema /data
9.x 11.1.0.6.0 i) 11.1.0.6 DB with Real Application Testing Option + one-off patch: 6865809 One-off patch can be Downloaded from MOS No patches are needed on the source side 9.x

Test DB not required, 11.1.0.6 is the destination db upgraded to
9.X 11.1.0.7.0 Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594 One-off patch can be Downloaded from MOS No patches are needed on the source side 9.x

Test DB not required, 11.1.0.7 is the destination db upgraded to
9.X 11.2.0.1.0 Use 11.2.0.1.0 with Real Application Testing option +8867819 One-off patch can be Downloaded or requested from MOS No patches are needed on the source side 9.x

Test DB not required, 11.2.0.1 is the destination db upgraded to
9.X 11.2.0.2+ Use 11.2.0.2+ with Real Application Testing option   No patches are needed on the source side 9.x

Test DB not required, 11.2.0.2+ is the destination db upgraded to
10.1.0.x 10.2.0.2.0

i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809

or

Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594

or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.


Using the latest version of Oracle database is Recommended.

AND

ii) Destination DB 10.2.0.2 + one-off patch: 6903322

 

One-off patch can be Downloaded from MOS No patches are needed on the source side 10.1.x

11g test database does not need to have application schema /data
10.1.0.x 10.2.0.3.0

i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809
or

Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594

or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.


Using the latest version of Oracle database is Recommended.


AND

ii) Destination DB 10.2.0.3 + one-off patch: 6903335

 

One-off patch can be Downloaded from MOS No patches are needed on the source side 10.1.x

11g test database does not need to have application schema /data
10.1.0.x 10.2.0.4.0

i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809
or

Use 11.1.0.7.0 test db with Real Application Testing Option + one off patch:8756594

or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.
Using the latest version of Oracle database is Recommended.

AND

ii) Destination DB 10.2.0.4 + one-off patch :6893073

 

One-off patch can be Downloaded from MOS No patches are needed on the source side 10.1.x.

11g test database does not need to have application schema /data
10.1.0.x 10.2.0.5.0

i) 11.1.0.6 test DB with Real Application Testing Option + one-off patch: 6865809
or

Use 11.1.0.7.0 test db with Real Application Testing Option + one off patch:8756594

or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.


Using the latest version of Oracle database is Recommended.



AND

ii) Destination DB 10.2.0.5 wit RAT option.

 

One-off patch can be Downloaded from MOS No patches are needed on the source side 10.1.x.

11g test database does not need to have application schema data
10.1.0.x 11.1.0.6.0 i) 11.1.0.6 DB with Real Application Testing Option + one-off patch: 6865809 One-off patch can be Downloaded from MOS No patches are needed on the source side 10.1.x
10.1.0.x 11.1.0.7.0 11.1.0.7.0 with Real Application Testing Option + one-off patch:8756594 One-off patch can be Downloaded from MOS No patches are needed on the source side 10.1.x
10.1.0.x 11.2.0.1.0 Use 11.2.0.1.0 with Real Application Testing option+8867819 One-off patch can be Downloaded or requested from MOS No patches are needed on the source side 10.1.x
10.1.0.x 11.2.0.2+ Use 11.2.0.2+ with Real Application Testing option   No patches are needed on the source side 10.1.x
10.2.0.2.0 10.2.0.3.0

i) 11.1.0.6 + one-off patch: 6865809
or

Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594

or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.


Using the latest version of Oracle database is Recommended.



ii) 10.2.0.2 + one-off patch: 6903322

AND
iii) 10.2.0.3 + one off patch: 6903335

 

One-off patch can be Downloaded from MOS Patch Required for source, destination and test databases.

11g test database does not need to have application schema data
10.2.0.2.0 10.2.0.4.0

i) 11.1.0.6 + one-off patch: 6865809

or

Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594

or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.


Using the latest version of Oracle database is Recommended.



AND

ii) 10.2.0.2 + one-off patch: 6903322
AND
iii) 10.2.0.4 + one-off patch: 6893073

 

One-off patch can be Downloaded from MOS Patch Required for source, destination and test databases

11g test database does not need to have application schema /data
10.2.0.2.0 10.2.0.5.0

i) 11.1.0.6 + one-off patch: 6865809

or

Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594

or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.


Using the latest version of Oracle database is Recommended.

AND

ii) 10.2.0.2 + one-off patch: 6903322

AND

iii) 10.2.0.5 with RAT option.

 

One-off patch can be Downloaded from MOS 11g test database does not need to have application schema data
10.2.0.2.0 11.1.0.6.0 ) 11.1.0.6 + one-off patch: 6865809

AND

ii) 10.2.0.2 + one-off patch: 6903322
One-off patch can be Downloaded from MOS Test DB not required, 11.1.0.6.0 is the destination db upgraded to
10.2.0.2.0 11.1.0.7.0 11.1.0.7.0 db with Real Application Testing Option + one-off patch:8756594

AND

ii) 10.2.0.2 + one-off patch: 6903322
One-off patch can be Downloaded from MOS Test DB not required, 11.1.0.7.0 is the destination db upgraded to
10.2.0.2.0 11.2.0.1.0 Use 11.2.0.1.0 with Real Application Testing option +8867819

AND

ii) 10.2.0.2 + one-off patch: 6903322
One-off patch can be Downloaded from MOS Test DB not required, 11.2.0.1 is the destination db upgraded to
10.2.0.2.0 11.2.0.2+

Use 11.2.0.2+ with Real Application Testing option

AND

ii) 10.2.0.2 + one-off patch: 6903322

 

One-off patch can be Downloaded from MOS Test DB not required, 11.2.0.2+ is the destination db upgraded to
10.2.0.3.0 10.2.0.4.0

i) 11.1.0.6 + one off patch: 6865809

or

 

Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594

or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.


Using the latest version of Oracle database is Recommended.  



AND

ii) 10.2.0.3 + one off patch 6903335

AND

ii) 10.2.0.4 + one off patch: 6893073 

One-off patch can be Downloaded from MOS 11g test database does not need to have application schema /data
10.2.0.3.0 10.2.0.5.0

i) 11.1.0.6 + one off patch: 6865809

or



Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594



or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.


Using the latest version of Oracle database is Recommended.


AND


ii) 10.2.0.3 + one off patch 6903335


AND


ii) 10.2.0.5  with RAT option. 

One-off patch can be Downloaded from MOS

11g test database does not need to have application schema data

10.2.0.3.0 11.1.0.6.0

10.2.0.3 + one off patch 6903335

and

11.1.0.6 db with Real Application Testing Option + one off patch: 6865809

One-off patch can be Downloaded from MOS Test DB not required, 11.1.0.6.0 is the destination db upgraded to
10.2.0.3.0 11.1.0.7.0

10.2.0.3 + one off patch 6903335

and

11.1.0.7.0 db with Real Application Testing Option + one-off patch:8756594

One-off patch can be Downloaded from MOS Test DB not required, 11.1.0.7.0 is the destination db upgraded to
10.2.0.3.0 11.2.0.1.0

10.2.0.3 + one off patch 6903335

and

Use 11.2.0.1.0 with Real Application Testing option +8867819

 

 

One-off patch can be Downloaded from MOS Test DB not required, 11.2.0.1.0 is the destination db upgraded to.
10.2.0.3.0 11.2.0.2+

10.2.0.3 + one off patch 6903335


and

Use 11.2.0.2+ with Real Application Testing option

One-off patch can be Downloaded from MOS One-off patch can be Downloaded
from MOS
Test DB not required, 11.2.0.2+ is the destination db upgraded to.
10.2.0.4.0 10.2.0.5.0

i) 10.2.0.4 + one-off patch: 6893073

and

ii) 11.1.0.6 + one-off patch: 6865809

or

Use 11.1.0.7.0 test db with Real Application Testing Option + one-off patch:8756594

or

Use 11.2.0.2.0 or higher version test db with Real Application Testing Option.


Using the latest version of Oracle database is Recommended.


AND


iii) 10.2.0.5 with RAT option.

 

One-off patch can be Downloaded from MOS 11g test database does not need to have application schema /data
10.2.0.4.0 11.1.0.6.0 i) 11.1.0.6 + one off patch: 6865809

AND

ii) 10.2.0.4 + one-off patch: 6893073
One-off patch can be Downloaded from MOS Test DB not required, 11.1.0.6.0 is the destination db upgraded to
10.2.0.4.0 11.1.0.7.0 11.1.0.7.0 db with Real Application Testing Option + one-off patch:8756594

AND

10.2.0.4 + one-off patch: 6893073
One-off patch can be Downloaded from Metalink Test DB not required, 11.1.0.7.0 is the destination db upgraded to
10.2.0.4.0 11.2.0.1.0 Use 11.2.0.1.0 with Real Application Testing option +8867819

AND

10.2.0.4 + one-off patch: 6893073
One-off patch can be Downloaded or requested from MOS Test DB not required, 11.2.0.1.0 is the destination db upgraded to
10.2.0.4.0 11.2.0.2+

Use 11.2.0.2+ with Real Application Testing option


AND

10.2.0.4 + one-off patch: 6893073

One-off patch can be Downloaded or requested from MOS Test DB not required, 11.2.0.2+ is the destination db upgraded to
10.2.0.5.0 11.1.0.6.0 11.1.0.6 + one off patch: 6865809 One-off patch can be Downloaded or requested from MOS Test DB not required, 11.1.0.6.0 is the destination db upgraded to
10.2.0.5.0 11.2.0.1.0

Use 11.2.0.1.0 with Real Application Testing option +8867819

One-off patch can be Downloaded or requested from MOS Test DB not required, 11.2.0.1.0 is the destination db upgraded to
10.2.0.5.0 11.2.0.2+ Use 11.2.0.2+with Real Application Testing option   Test DB not required, 11.2.0.2+ is the destination db upgraded to
11.1.0.6.0 11.1.0.7.0 i) 11.1.0.6 + one off patch: 6865809

and

11) 11.1.0.7.0 db with Real Application Testing Option + one-off patch:8756594  
One-off patch can be Downloaded or requested from MOS  
11.1.0.6.0 11.2.0.1.0 i) 11.1.0.6 + one off patch: 6865809

and

ii) Use 11.2.0.1.0 with Real Application Testing option +8867819
One-off patch can be Downloaded or requested from MOS  
11.1.0.6.0 11.2.0.2+ i) 11.1.0.6 + one off patch: 6865809

and

ii)Use 11.2.0.2.0 with Real Application Testing option
One-off patch can be Downloaded or requested from MOS  
11.1.0.7.0 11.1.0.7.0 11.1.0.7.0 db with Real Application Testing Option + 8756594 One-off patch can be Downloaded or requested from MOS  
11.1.0.7.0 11.2.0.1.0 i) 11.1.0.7.0 db with Real Application Testing Option 

and

ii) Use 11.2.0.1.0 with Real Application Testing option +8867819
One-off patch can be Downloaded or requested from MOS  
11.1.0.7.0 11.2.0.2+ i) 11.1.0.7.0 db with Real Application Testing Option

and

ii) Use 11.2.0.2+ with Real Application Testing option
One-off patch can be Downloaded or requested from MOS  
11.2.0.1.0 11.2.0.2+ i) Use 11.2.0.1.0 with Real Application Testing option +8867819

and

ii) Use 11.2.0.2+ with Real Application Testing option
One-off patch can be Downloaded or requested from MOS  
EM Grid control

If using EM Grid control for SQL Performance Analyzer with 11.2.0.2.0 database it is recommended to apply:

<Patch 10402264> ORA-00911 WHEN CLICKING ON LINK ON SPA COMPARISON REPORT WITH 9I GENERATED STS        

Windows Platforms

11.1.0.6 Patch 4 or higher should be applied on Windows: For details on Windows patches see:

<Document 560295.1> 11.1.0.x Oracle Database and Networking Patches for Microsoft Platforms
11.1.0.7.0 Database

Please check  the following note:

<Document 879659.1>Real Application Testing Recommended PATCH FOR 11.1.0.7.0

 

For more information on Real Application see:

<Document 1453789.1>  Real Application Testing: Consolidated Database Replay Feature
<Document 787658.1>    SCALE_UP_MULTIPLIER:DATABASE CAPTURE AND REPLAY
<Document 1287620.1>  Database Replay Diagnostic information
<Document 1536143.1>  Slow DBMS_Workload_Replay.Process_Capture
<Document 463263.1>    DATABASE CAPTURE AND REPLAY COMMON ERRORS AND REASONS
<Document 760402.1>    SCRIPTS TO DEBUG SLOW REPLAY
<Document 1388309.1>  How To Find Database Replay Divergence Details
<Document 1538269.1>  Slow Database Replay with Waits on "WCR: replay clock"
<Document 1268920.1>  Real Application Testing:Workload Analyzer
<Document 1535885.1>  Real Application Testing: Best Practices 

 

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
 Ask Questions, Get Help, And Share Your Experiences With This Article
Actions
 Real Application Testing on Earlier Releases
 Database Replay
 Table 1: Database Replay Availability Information for All Platforms except Windows
 Table 2: Database Replay Availability Information Windows Platform
 Enabling Workload Capture (Only Required for 10.2.0.4.0)
 SQL Performance Analyzer
 Table 3: SQL Performance Analyzer Availability Information
 EM Grid control
 Windows Platforms
 11.1.0.7.0 Database
Contacts
 Discuss Real Application Testing!
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.