Skip to main content
  • EN

While converting from Oracle 11g to 12c, we executed a simple Oracle Non Spatial Workspace that moved 4 million rows from a CSV file to an Oracle table on 12c. It consistently threw the

ORA-12592: TNS:bad packet error after running for 30-40 seconds.

We ran the same workspace against 11g and it worked fine.

After researching the issue we ended up modifying the Oracle 12c Server SQLNET.ora file by adding this parm:

SQLNET.SEND_TIMEOUT=600

Modifying the client side SQLBET.ORA did not resolve the issue. Modifying the server side SQLNET.ORA file did.

Hi Jeff, I'm really happy you've shared this with the FME Community. This may help anyone else that has recently moved to Oracle 12c and finds the timeout has changed on them. Great find!

 

 

Thanks for sharing this information.

Might be a good help to other Oracle users.

Reply


Community Stats

30,092
Posts
114,247
Replies
37,720
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.