Question

Oracle 12c - Bad Packet Error Resolution

  • 22 June 2017
  • 2 replies
  • 36 views
J
Badge +1

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.

2 replies

steveatsafe
Rank
Badge +11
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
erik_jan
Rank
Userlevel 2
Badge +16

Thanks for sharing this information.

Might be a good help to other Oracle users.

Reply


Community Stats

28,681
Posts
109,402
Replies
36,540
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.