Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • Is there a recommended setting for SQLNET.EXPIRE_TIME when using FME with an Oracle 12c database?

A customer who is using FME to connect to our recently upgraded database is reporting that a process for pulling data that was working before the upgrade now seems to just hang after a few minutes. We have SQLNET.EXPIRE_TIME=4 in the server's sqlnet.ora which means we check for dead sessions at 4 minutes. The FME log does not report any errors. It just stops logging and performs no more work.

@dmallard, you may wish to see if the timeout works on the Server side. I'm wondering if the process is getting disconnected.

See: https://knowledge.safe.com/questions/46477/oracle-12c-bad-packet-error-resolution.html

Let us know if you resolved this some other way.

Regards,

Steve

Reply


Community Stats

30,108
Posts
114,294
Replies
37,743
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.