:

RSSRAT

RAT – Workload Analyzer

I have recently been playing around with Real Application Testing (RAT) and as part of the replaying of a captured workload it is advisable to run the Workload Analyzer if you are using the APIs to replay the workload. This is required to identify any potential problems by analyzing the workload capture files in the […]

Continue Reading

ORA-15567: replay user encountered an error during a sanity check

The Problem I was playing around with Real Application Testing (RAT) on my Oracle 11g database. I had captured a workload from my production database and was attempting to replay the workload into a development database which was a copy of PROD. While attempting to connect the workload replay client to the database, I received the following […]

Continue Reading

ORA-15590: encountered incomplete workload capture files

The Problem I had captured the workload from our production database, copied the workload  capture files to a development database server, upgraded the development database from 10g to 11g  and then attempted to run in this procedure and received the error below: SQL> BEGIN 2    DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE  (capture_dir => ‘WRC’); 3    END; 4    / BEGIN * ERROR at line […]

Continue Reading

Real Application Testing Hangs on Replay

Oracle Version: 11.2.0.3 Platform: Windows Server 2003 SP2 The Problem I was using Real Application Testing, and more specifically the Database Replay tool to get some performance comparison testing done. When running the replay it appeared to hang. I had changed one thing, and that was the following hidden parameter “_disable_flashback_archiver”. This is a hidden […]

Continue Reading

ORA-15557 workload replay client cannot access replay directory

The Problem I have been starting to use the Oracle 11g feature called Real Application Testing (RAT) recently. More specifically, the Database Replay feature of RAT. This appears to be a great tool for testing real PROD load on a DEV system, tweeking some parameters or statistics and then running the load again. I was […]

Continue Reading

ORA-15554: cannot start workload replay client because the database server is not in PREPARE mode

The Problem I was trying to start a replay client so that I was able to  then start the DB replay, but when running the command below I received an  error. D:\Oracle\Product\11.2.0\dbhome_1\BIN>wrc  wrc/wrc@test MODE=replay REPLAYDIR=U:\flash_recover_TEST\TEST\WRC Workload Replay Client: Release 11.2.0.2.0 – Production on  Thu Feb 17 09:16:04 2011 Copyright (c) 1982, 2009, Oracle and/or its […]

Continue Reading

ORA-20223: Invalid input. Database has not been INITIALIZED for REPLAY

The Problem As part of the set-up work you have to do before replaying a  captured workload into the DB using Real Application Testing, you have to run  various commands. This is one of them, but I was receiving errors: SQL> BEGIN 2     DBMS_WORKLOAD_REPLAY.PREPARE_REPLAY ( 3     synchronization           => ‘SCN’, 4     connect_time_scale        => 100, 5     think_time_scale          […]

Continue Reading

Error – Real Application Testing option is not available

The Problem You want to make use of Real Application Testing (RAT) in your 10g DB (this may apply to 11g as well but I haven’t had the same issue there), but it is not available in Enterprise Manager. You can check this by going to the targets -> Database -> Software and Support -> Database Reply […]

Continue Reading

Real Application Testing option is not available

The Problem You want to use Real Application Testing to capture and replay load against your Oracle database to test the effect of changes that you make. In the Enterprise manager you go to the “Software and Support” tab and click on “Database Replay” under the “Real Application Testing” header and you receive the following […]

Continue Reading

ORA-32012: SPFILE format is inconsistent with value of COMPATIBLE parameter

The Problem I was using Real Application Testing and I had just finished capturing a workload on a test database, while also having created a restore point. After capturing the workload, I attempted to run a query but it failed because the instance was down. I re-started the instance and then tried the query again […]

Continue Reading