Skip to main content
Question

Oracle 12c - Bad Packet Error Resolution

jbradfor
Contributor
Forum|alt.badge.img+7

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
Safer
Forum|alt.badge.img+12
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
Contributor
Forum|alt.badge.img+18
  • erik_janContributor
  • Contributor
  • June 22, 2017

Thanks for sharing this information.

Might be a good help to other Oracle users.

Reply


Helpful Members This Week

Community Stats

31,372
Posts
118,976
Replies
39,000
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.