1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

testing RAC

Discussion in 'Server Administration and Options' started by Tariq Bashir Malhi, May 14, 2010.

  1. Tariq Bashir Malhi

    Tariq Bashir Malhi Forum Advisor

    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    80
    We are testing RAC implemented by a vendor on oracle 11gr1. I observe following, kindly tell me whether it should be like this

    1. I update a column of a table on one node and terminate the session without commiting. I checked it was applied. (My understanding is that when we close s session without commit, it rollback )
    2. Same happens in insert case.

    3. I issue a time consuming update/Insert , and before it ends it close session. (Nothing was applied)

    Can you please help, what should i do for further testing.

    We are using
    Oracle Enterprise Linux 5.4
    DRBD 0.8.3 (Dual Primary Mode)
    OCFS2 1.4.4
    Oracle Clusterware 11.1
    Oracle RDBMS 11gr1
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    From sqlplus if you issue an 'exit' by default it is an 'exit commit'. You can also perform an 'exit rollback' and roll back any changes made during the session.