AnsweredAssumed Answered

Large table load to Oracle 12.1 geodatabase 10.3.1 fails with ORA-12592: TNS:bad packet

Question asked by Konopkaeh on Apr 23, 2018
Latest reply on Apr 24, 2018 by RRobichaux-esristaff

The geodatabases are on a 2-node RAC.  For loads to both test and production (on different racks in different buildings) tnsnames.ora pointing to one node only. For the test geodatabase, when we point to the node with the setting SQLNET.SEND_TIMEOUT = 600, the load is successful. When we point to the other node, it fails after varying numbers of records.

 

Our problem is that the DBA is nervous about using the SQLNET.SEND_TIMEOUT = 600 setting on the production database, where it will affect other production databases for other client agencies. Any experience anyone has had with this would be helpful. Also if this problem can be solved some other way, or if a later version of the desktop software has a fix. We have had problems with ArcCatalog 10.5.1 too.

 

I will submit a service ticket also.

Outcomes