OraFAQ Forum: RAC & Failsafe » DML statement fails

Home » Server Options » RAC & Failsafe » DML statement fails (Oracle 11g,12c, Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DML statement fails [message #682244]

Tue, 13 October 2020 02:28

BalajiDBA
Messages: 130
Registered: October 2018
Location: India

Senior 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

Report message to a moderator

Re: DML statement fails [message #682245 is a reply to message #682244]

Tue, 13 October 2020 02:40

John Watson
Messages: 8718
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?

Report message to a moderator

Re: DML statement fails [message #682246 is a reply to message #682245]

Tue, 13 October 2020 02:44

BalajiDBA
Messages: 130
Registered: October 2018
Location: India

Senior Member

If I know the answer for this question, then I am posting it here.

Report message to a moderator

Re: DML statement fails [message #682247 is a reply to message #682246]

Tue, 13 October 2020 02:47

John Watson
Messages: 8718
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?

Report message to a moderator

Previous Topic:	ORA-12545: Connect failed because target host or object does not exist
Next Topic:	Service names in RAC

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 30 14:45:52 CDT 2022