Database - RAC/Scalability (MOSC)

MOSC Banner

How to configure RAC 19c Application Continuity for CC&B 2.7 application. Inflight DML transaction s

edited Sep 19, 2020 5:00AM in Database - RAC/Scalability (MOSC) 10 commentsAnswered

I am looking for recommendations or steps to configure 19c RAC application continuity feature.

we have 3 node RAC and application CC&B 2.7

Requirement is during the node/network failure, my inflight transactions (dml) should move to available node and complete. 

grant execute on DBMS_APP_CONT to user_name;

srvctl add service -db ORCL -service oracle_service -preferred rac11 -available rac2,rac3 -clbgoal SHORT -rlbgoal SERVICE_TIME -failoverretry 50 -failoverdelay 10 -commit_outcome TRUE -failover_restore LEVEL1 -failovertype TRANSACTION -replay_init_time 1800 -retention 86400 -notification TRUE -drain_timeout 300 -stopoption IMMEDIATE

Please check and let me know, what else we need to perform.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center