Professional Web Applications Themes

SIMULATING DISTRIBUTED TRANSACTION FAILURE - Oracle Server

Hi all, has anybody ever simulated a distributed transaction failure? I would like to make some test, and in order to have the views DBA_2PC_PENDING and DBA_2PC_NEIGHBORS populated, I've been suggested to use the statement COMMIT COMMENT 'ORA-2PC-CRASH-TEST-n' , where n=1,2, etc. However, this method doesn't seem widely doented. Any comment about? Thanks, BritPop -- Posted via Mailgate.ORG Server - [url]http://www.Mailgate.ORG[/url]...

  1. #1

    Default SIMULATING DISTRIBUTED TRANSACTION FAILURE

    Hi all,

    has anybody ever simulated a distributed transaction failure?

    I would like to make some test, and in order to have the views
    DBA_2PC_PENDING and DBA_2PC_NEIGHBORS populated, I've been suggested
    to use the statement COMMIT COMMENT 'ORA-2PC-CRASH-TEST-n' , where
    n=1,2, etc.

    However, this method doesn't seem widely doented.

    Any comment about?

    Thanks,

    BritPop




    --
    Posted via Mailgate.ORG Server - [url]http://www.Mailgate.ORG[/url]
    Brit Pop Guest

  2. #2

    Default Re: SIMULATING DISTRIBUTED TRANSACTION FAILURE


    The last time I did this was in Oracle 7.
    I think I used events 10271 to 10276 - the
    last digit matches the N in the comment
    ora-2pc-crash-test-N, I think.

    Things may have changed since then, but
    I remember I had to kill RECO somehow
    to do this - otherwise it kicked in so fast
    that I never had time to see the side-effects
    of the 2PC failing.

    --
    Regards

    Jonathan Lewis
    [url]http://www.jlcomp.demon.co.uk[/url]

    Coming soon a new one-day tutorial:
    Cost Based Optimisation
    (see [url]http://www.jlcomp.demon.co.uk/tutorial.html[/url] )

    Next Seminar dates:
    (see [url]http://www.jlcomp.demon.co.uk/seminar.html[/url] )

    ____England______January 21/23


    The Co-operative Oracle Users' FAQ
    [url]http://www.jlcomp.demon.co.uk/faq/ind_faq.html[/url]





    Brit Pop wrote in message
    <189eb8c37353ba33c4dd88d3ca9d902d.117233mygate.ma ilgate.org>...
    >Hi all,
    >
    >has anybody ever simulated a distributed transaction failure?
    >
    >I would like to make some test, and in order to have the views
    >DBA_2PC_PENDING and DBA_2PC_NEIGHBORS populated, I've been
    suggested
    >to use the statement COMMIT COMMENT 'ORA-2PC-CRASH-TEST-n' , where
    >n=1,2, etc.
    >
    >However, this method doesn't seem widely doented.
    >
    >Any comment about?
    >
    >Thanks,
    >
    >BritPop
    >
    >
    >
    >
    >--
    >Posted via Mailgate.ORG Server - [url]http://www.Mailgate.ORG[/url]

    Jonathan Lewis Guest

Similar Threads

  1. Distributed Transaction in different web services
    By Avanish Pandey in forum ASP.NET Web Services
    Replies: 1
    Last Post: November 10th, 08:21 AM
  2. Replies: 0
    Last Post: June 25th, 02:31 PM
  3. Replies: 1
    Last Post: April 5th, 10:55 AM
  4. Distributed Transaction Error
    By dh kim in forum ASP Database
    Replies: 1
    Last Post: September 9th, 03:38 AM
  5. Transaction id and transaction isolation
    By Alex in forum Informix
    Replies: 3
    Last Post: July 23rd, 09:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139