RAC failover

[Roshan]

Hi Erman,

we are testing an application when each of  the 2 nodes is brought down. The issue is when first node is shutdown, the user cannot see some forms despite application is up.

But when second node is shutdown, forms are available.

Please advise.

Regards,
Roshan

[ErmanArslansOracleBlog]

Hi Roshan,

There is no automatic failover for Forms session.

Read "Note:243303.1 Does Oracle Forms Support Oracle RDBMS High Availability and Failover (RAC / TAF)?" for more info.

[ErmanArslansOracleBlog]

It is all about the plsql state. When one db node is down, the forms screen which are connected to it, will not function properly.

So, if a database node failed and cannot be opened, then new connections would be redirected to the surviving nodes and the Forms users should restart their applications. (We can say that, their existing session information and uncommitted data are lost)

[Roshan]

Thank you so much for support and guidance :)