Error - Real Application Testing Option is not Available.

(Doc ID 464815.1)

Last updated on JANUARY 25, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.6 [Release 11.1]
Information in this document applies to any platform.

Symptoms

In Oracle Enterprise Manager Database Control, clicking "Database Replay" or "SQL Performance Analyzer" results in

Error
Real Application Testing option is not available.



+ Optionally running dbms_workload_capture.add_filter from SQL*Plus also results in the error ORA-00438: Real Application Testing Option not installed


SQL*Plus: Release 11.1.0.6.0 - Production on Mon Sep 15 13:02:43 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL> SQL> Connected.
SQL> SQL> BEGIN dbms_workload_capture.add_filter('Oracle Management Service (DEFAULT)', 'PROGRAM', 'OMS'); END;

*
ERROR at line 1:
ORA-00438: Real Application Testing Option not installed
ORA-06512: at "SYS.PRVT_SMGUTIL", line 80
ORA-06512: at "SYS.DBMS_WORKLOAD_CAPTURE", line 1248
ORA-06512: at line 1


Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning option
Failed to add workload capture filter Oracle Management Service (DEFAULT).

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Sep 15 13:02:43 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL> SQL> Connected.
SQL> SQL> BEGIN dbms_workload_capture.add_filter('Oracle Management Agent (DEFAULT)', 'PROGRAM', 'emagent%'); END;

*
ERROR at line 1:
ORA-00438: Real Application Testing Option not installed
ORA-06512: at "SYS.PRVT_SMGUTIL", line 80
ORA-06512: at "SYS.DBMS_WORKLOAD_CAPTURE", line 1248
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms