RAT
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]