Home » Server Options » RAC & Failsafe » DML statement fails (Oracle 11g,12c, Unix)
DML statement fails [message #682244] Tue, 13 October 2020 02:28 Go to next message
BalajiDBA
Messages: 84
Registered: October 2018
Location: India
Member
Hi Oracle gurus,

This is an interview question.

What will happen when DML transaction fails on 1 node.

This is 2 node RAC instance.

Regards,
Balaji
Re: DML statement fails [message #682245 is a reply to message #682244] Tue, 13 October 2020 02:40 Go to previous messageGo to next message
John Watson
Messages: 8426
Registered: January 2010
Location: Global Village
Senior Member
If I were the interviewer, I would ask you:

What do you think will happen? Why do you think that? Any other possibilities? How would you test, to find out if you are correct?
Re: DML statement fails [message #682246 is a reply to message #682245] Tue, 13 October 2020 02:44 Go to previous messageGo to next message
BalajiDBA
Messages: 84
Registered: October 2018
Location: India
Member
If I know the answer for this question, then I am posting it here.
Re: DML statement fails [message #682247 is a reply to message #682246] Tue, 13 October 2020 02:47 Go to previous message
John Watson
Messages: 8426
Registered: January 2010
Location: Global Village
Senior Member
OK, let us try to work on your problem solving skills. Begin by simplifying the problem: forget the RAC. In a single instance database, what happens if a transaction fails on the one node?
Previous Topic: ORA-12545: Connect failed because target host or object does not exist
Next Topic: Service names in RAC
Goto Forum:
  


Current Time: Fri Nov 27 12:04:15 CST 2020