Question

Oracle cluster fallover not working?

  • 13 September 2018
  • 1 reply
  • 5 views
M
Badge

We have an Oracle RAC cluster with 8 threads each for two nodes. It appears that the Oracle driver (non-spatial) runs out of threads on the first node, but never falls over to the second node.

Is there a way to configure the FME workflow to do this, or perhaps the driver itself? We have intermittent failures during our overnight process that magically "fix" themselves the next time this workflow runs. And after a lot of testing and trial-and-error, we came to the conclusion that the 8 threads on the first node are probably filled by other processes, and FME gets denied access because it never goes over to the second node. The error we get (not exact wording) is that the data source is unavailable.

Has anyone experiences this and has a solution or a hint at what might help?

Thanks!

1 reply

steveatsafe
Rank
Badge +11
Hi @michaeljb, Thanks for sharing this. We don't hear a lot about these sorts of issues.

 

Which Writer/Transformer are you using in the workspace? I'm thinking I would like to connect with you through our support to learn more about your environment and workspaces. The error you the FME log would be helpful to see as well. The most common issue I see is from the network dropping for a moment during long-running translations.
SteveatSafe

Reply


Community Stats

28,731
Posts
109,530
Replies
36,566
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.