Question

Oracle 12c - Bad Packet Error Resolution

Forum|Forum|8 years ago
June 22, 2017
2 replies
521 views

+7

jbradfor
Contributor

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

+13

steveatsafe
Safer
Forum|Forum|8 years ago
June 22, 2017

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!

SteveatSafe