1 2 Previous Next 15 Replies Latest reply: Mar 25, 2010 7:05 AM by user4164559 RSS

    db replay

    user3266490
      Hi,

      I got the following error while db replay in oracle 11g.
      ORA-15554: cannot start workload replay client because the database server is not in PREPARE mode

      SQL> select id,name from dba_workload_replays;

      no rows selected

      SQL> host
      [oracle@sys ~]$ wrc mode=calibrate replaydir='/home/oracle/capture3'

      Workload Replay Client: Release 11.1.0.6.0 - Production on Wed Feb 24 02:49:36 2010

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


      Report for Workload in: /home/oracle/capture3



      --------------------------------------------------------------------------------

      Recommendation:
      Consider using at least 1 clients divided among 1 CPU(s).

      Workload Characteristics:
      - max concurrency: 1 sessions
      - total number of sessions: 1

      Assumptions:
      - 1 client process per 50 concurrent sessions
      - 4 client process per CPU
      - think time scale = 100
      - connect time scale = 100
      - synchronization = TRUE

      [oracle@sys ~]$ exit
      exit

      SQL> BEGIN
      DBMS_WORKLOAD_REPLAY.initialize_replay (
      replay_name => 'RE_CAPTURE3',
      replay_dir => 'CAPTURE3');
      DBMS_WORKLOAD_REPLAY.prepare_replay (
      synchronization => TRUE);
      END;
      / 2 3 4 5 6 7 8

      PL/SQL procedure successfully completed.

      SQL> select id,name,capture_id,status from dba_workload_replays;
      ID

      --------------------------------------------------------------------------------
      NAME

      --------------------------------------------------------------------------------
      CAPTURE_ID STATUS

      --------------------------------------------------------------------------------
      ----------------------------------------
      12
      RE_CAPTURE3
      21 PREPARE

      SQL> host
      [oracle@sys ~]$ wrc cap1/cap1 mode=replay replaydir='/home/oracle/capture3'

      Workload Replay Client: Release 11.1.0.6.0 - Production on Wed Feb 24 02:52:32 2010

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


      Errors in file :
      ORA-15554: cannot start workload replay client because the database server is not in PREPARE mode
      [oracle@sys ~]$


      the db is prepare mode while executing select id,name,capture_id,status from dba_workload_replays;

      why can't execute that?
      please help me out that.i tried to find in metalink.but there is no gain
        • 1. Re: db replay
          Helios-GunesEROL
          Hi user;

          Did you check this before:

          ORA-15554: cannot start workload replay client because the database server is not in PREPARE mode
          Cause: The Workload Replay Client could not connect to the database server because the database server was not in the PREPARE mode.
          Action: Put the database in PREPARE mode by using DBMS_WORKLOAD_REPLAY.PREPARE_REPLAY, and restart the Workload Replay Client.

          If no please test it

          Hope it helps

          Regard
          Helios
          • 2. Re: db replay
            Helios-GunesEROL
            Hi again;

            In addition to my post please check:
            db replay

            Compare your steps wiht link which is posted in upper thread

            Regard
            Helios
            • 3. Re: db replay
              user3266490
              Hi,

              SQL> begin
              DBMS_WORKLOAD_REPLAY.prepare_replay (
              synchronization => TRUE);
              END; 2 3 4
              5 /
              begin
              *
              ERROR at line 1:
              ORA-20223: Invalid input. Database already in PREPARE mode.
              ORA-06512: at "SYS.DBMS_WORKLOAD_REPLAY", line 1355
              ORA-06512: at line 2


              I got the same error.........


              SQL> select id,name,capture_id,status,to_char(prepare_time,'dd-mm-ss hh:mm:ss'),start_time,end_time from dba_workload_replays;

              ID
              ----------
              NAME
              --------------------------------------------------------------------------------
              CAPTURE_ID STATUS TO_CHAR(PREPARE_T START_TIM
              ---------- ---------------------------------------- ----------------- ---------
              END_TIME
              ---------
              12
              RE_CAPTURE3
              21 PREPARE 24-02-13 02:02:13



              any patch for oracle11.1.0.6?please help me out that? any further info from me>

              Edited by: user3266490 on Feb 25, 2010 2:39 PM
              • 4. Re: db replay
                Helios-GunesEROL
                Hi user;

                Please check Note:DATABASE CAPTURE AND REPLAY COMMON ERRORS AND REASONS [ID 463263.1]

                Regard
                Helios
                • 5. Re: db replay
                  Helios-GunesEROL
                  Hi again;

                  Also check Note:How to Use Database Replay Feature to Help With The Upgrade From 10.2.0.4 to 11.1. [ID 748895.1]

                  Hope it helps

                  Regard
                  Helios
                  • 6. Re: db replay
                    user3266490
                    Hi,

                    I am getting same error.

                    In oracle 10g, i used CAP1 schema only for workload capture.then took the export only CAP1 schema.
                    Then import into oracle 11g CAP1. Is it correct procedure?


                    I used the followings in oracle 10.2.0.4

                    BEGIN
                    DBMS_WORKLOAD_CAPTURE.ADD_FILTER (
                    fname => 'wk_capture3',
                    fattribute => 'USER',
                    fvalue => 'CAP1');
                    END;
                    /

                    SELECT id, name,status from dba_workload_Captures;

                    BEGIN
                    DBMS_WORKLOAD_CAPTURE.START_CAPTURE (name => 'wk_capture3',
                    dir => 'CAPTURE3',
                    duration => 250,
                    default_action => 'EXCLUDE');
                    END;
                    /
                    • 7. Re: db replay
                      user3266490
                      Hi,
                      Thanks for reply.As per docu 748895.1.

                      I have some doubts about that.

                      10g- workload capture ---> test server.
                      11g:db replay ---> newly installed one.

                      Restore the back up means.How the 11g is synchronized.

                      the following word are confusing me about SCN

                      Take backup of production before Load capture, so we can restore database on test environment and will run replay on same SCN level of database to minimize data divergence.

                      please anyone explain that.
                      • 8. Re: db replay
                        669464
                        Hi,

                        When ever there is a activity on the database the new SCN(system change number )is generated.
                        ake backup of production before Load capture, so we can restore database on test environment and will run replay on same SCN level of database to minimize data divergence.
                        it mean that when u take a backup of production it will have SCN chnage number suppose 1234...then restore it on the test env and then run replay till SCN number 1234...from this the data will be same as production till SCN 1234

                        Regards
                        • 9. Re: db replay
                          user3266490
                          Hi,
                          Thanks for replay.

                          oracle 10g in running in windows 2000.(production)
                          oracle 11g is installed in red hat 5.(test)

                          so 11g scn is same as 10g.

                          while import in oracle 11g,how the oracle treat the scn?please anyone explain that.

                          our needs move the 10g data to 11g.which method is simple do  for real application testing

                          Edited by: user3266490 on Feb 26, 2010 10:42 AM
                          • 10. Re: db replay
                            user3266490
                            Hi,
                            Thanks for reply.

                            I got the solution.

                            i executed the followings in another terminal

                            SQL>BEGIN
                            DBMS_WORKLOAD_REPLAY.start_replay;
                            END;
                            /
                            while executing wrc system/oracle mode=replay replay=/home/oracle/capture3 in a terminal

                            The output

                            [oracle@sys /]$ wrc system/oracle mode=replay replaydir=/home/oracle/capture3

                            Workload Replay Client: Release 11.1.0.6.0 - Production on Fri Feb 26 11:26:02 2010

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

                            Wait for the replay to start (11:26:02)

                            Replay started (12:41:39)
                            Replay finished (12:43:49)


                            And also i generated the report in 11g.i could n't understand the followings and its values.


                            Error Divergence:



                            Session Failures Seen During Replay 0 0.00

                            Errors No Longer Seen During Replay 2 0.78

                            Errors Mutated During Replay 0 0.00

                            New Errors Seen During Replay 0 0.00




                            Data Divergence:



                            DMLs with Different Number of Rows Modified 0 0.00

                            SELECTs with Different Number of Rows Fetched 2 0.78

                            Edited by: user3266490 on Feb 26, 2010 2:37 PM
                            • 11. Re: db replay
                              user4164559
                              Hello,

                              I am new to Real Application Testing and have been attempting to:

                              Execute a test script/cycle in a 10.2.0.3 db with capture enabled (Stored procs invoked from sqlplus scripts).
                              Disable capture saving output.
                              Restore db to the condition it was in before test cycle
                              Upgrade db to 11.1.0.6
                              Pre-process the capture files
                              Perform replay.

                              When i look at the replay report it states the capture duration was 2.5 hours (which is true), the replay duration was 13 seconds which indicates nothing got updated/executed in the upgraded db.

                              Everything was successful but the replay did not update the 11g db.

                              I reviewed the common mistakes note and the RAT documentation but have not seen anything indicating what would cause this behavior. I assume i am missing something obvious. Any pointers are appreciated.

                              Regards.
                              • 12. Re: db replay
                                Hussein Sawwan-Oracle
                                Hi,

                                Please see if (Note: 748895.1- How to Use Database Replay Feature to Help With The Upgrade From 10.2.0.4 to 11.1.) helps.

                                Regards,
                                Hussein
                                • 13. Re: db replay
                                  user4164559
                                  Thanks Hussein.

                                  Note 748895.1 example references oracle 10.2.0.4, our capture db was 10.2.0.3

                                  Is 10.2.0.4 the minimum version capable of performing data capture to ultimately replay on 11g or was 10.2.0.4 simply the release chosen for the example?

                                  If 10.2.0.4 is the minimum version I would of expected an error/warning at some point in the capture/pre-process/replay. I believe I am doing the steps in the referenced in the example except that capture is performed against a 10.2.0.3 database.

                                  Thanks again for your quick response!

                                  Andy
                                  • 14. Re: db replay
                                    Hussein Sawwan-Oracle
                                    Andy,

                                    I beleive the database version mentioned in the document is just an example, and the document should be applicable to 11.2.0.3 version. If youw ant, you could log a SR and confirm this with Oracle support.

                                    Regards,
                                    Hussein
                                    1 2 Previous Next