Database Utilities (MOSC)

MOSC Banner

Getting ORA-15512 when processing a workload

edited Jan 21, 2015 9:45PM in Database Utilities (MOSC) 4 commentsAnswered ✓
Hi,  I'm new to Database Replay. I'm trying to build a simple test case.

Source: 10.2.0.5 on Linux x64

   connect dba@ora10g

   create user test1...
   create directory dbreplay as ... 
   
    begin
dbms_workload_capture.add_filter(
fname => 'include TEST1',
fattribute => 'USER',
fvalue => 'TEST1');
dbms_workload_capture.start_capture (
name => 'capture 1',
dir => 'DBREPLAY',
duration => null,
default_action => 'EXCLUDE');
end;
/

    connect test1@ora10g

    update t set a = 1;
    commit;

    connect dba@ora10g

     exec dbms_workload_capture.finish_capture;


After that I transfered all files to the 11g server.

Destination: ORacle 11.2.0.3 on Linux x64

    connect dba@ora11g

   create directory dbreplay as ....

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center