Skip to main content
Question

IFS Cloud can only function properly on one Oracle RAC node

  • December 15, 2025
  • 2 replies
  • 62 views
Do Gooder (Customer)
Forum|alt.badge.img+2

Hello,

Brief description of our problem:
our company recently migrated from IFS9 (Oracle 12) to IFS Cloud (Oracle 19c). Both databases run on Oracle RAC. IFS9 worked well with Oracle RAC, but IFS Cloud can only function properly on one Oracle RAC instance. When we run the application on two nodes, we start receiving errors like: ORA-20113: JtTaskTransaction.FND_LOCKED: Update could not be fetched because the work task transaction record is currently locked. Retry the operation.
JtTaskTransaction - is one of several tasks, provided only as an example.

Our DBA analyzed the database logs and found that there are no RAC waits at the top, but a lot of TX row lock contention, waits event in Oracle databases that occurs when multiple sessions attempt to modify the same row(s) simultaneously.

Have you encountered similar problem in your practice? If so, could you please share some advice on how we can solve it or what we can try to find a solution? Currently we have service update 24.2.1.

 

Thank you in advance for your help!

2 replies

mfrejik
Sidekick (Customer)
Forum|alt.badge.img+9
  • mfrejik
  • Sidekick (Customer)
  • August 20, 2026

We got rid of RAC in our environment even with Apps 9/10. Our performance didn’t improve anything substantial, but the reliability did. Ended up going with a 3 device architecture that was synced using Dataguard.

 

I spoke to a lot of people at IFS and other vendors - none of them really recommended RAC without a very specific use case. 

    Hero (Employee)
    Forum|alt.badge.img+10
    • Eugene Wager
    • Hero (Employee)
    • September 11, 2026

    ​@sergev78 and ​@mfrejik,

    When I noticed this post a few days ago I recalled having worked with IFS customers in the past who most definitely were running their Oracle databases on multi-node RAC.  So I did some inquiring around the DBA communities within IFS.  One of the responses I received came from one of our database architects who’s been involved with the design of various editions of IFS through the years.  I’ve included part of his response here:

    “Application behavior and database configuration can both have an impact on locking and transaction response times in a RAC environment. An application issue can sometimes be exposed or amplified by the additional coordination required between RAC nodes. Such issues should therefore be investigated based on their specific root cause, rather than interpreted as a general indication that RAC is ‘not supported.’ ”

    Know that other IFS customers are successfully using RAC with multiple nodes.  If your companies wish to pursue the additional capabilities of Oracle with RAC feel free to reach out to IFS Consulting Services or one of its database administration partners for assistance.

      Terms & ConditionsAccessibility statement