Oracle error when copying massive feature dataset

المشرف العام

Administrator
طاقم الإدارة
In ArcCatalog 10.1, when copying a feature dataset with roughly 3 million objects as well as a few thousand tables and relationship classes, my team is running into an

'Underlying DBMS error [ORA-03114: not connected to ORACLE][SDE.DEFAULT]'

message 9 times out of 10... I'm hoping someone has run into a similar issue.

We are literally copying the feature dataset from one connection file and pasting it into another connection file/environment. This works fine with smaller sets of data. However, for this bigger dataset transfer, we are running into this problem - the process copies all objects but fails in the late stages (I think when it is copying tables). This is killing us, since the process takes about 20 hours and then bombs! X(

I also get a Paste Failed Message each time:

'Failed to paste GEODATA.NA_US_SOIL_MUPOLYGON_2013 Invalid function arguments Underlying DBMS error [SDE.GDB_ITEMS] Underlying DBMS error [ORA-03114: not connected to ORACLE][GEODATA.NA_US_SOIL_MUPOLYGON_x] Underlying DBMS [ORA-03114: not connected to ORACLE] Underlying DBMS error [ORA-03113: end-of-file on communication channel Process ID: 7804 Session ID: 205 Serial number: 52647][GEODATA.NA_US_SOIL_MUPOLYGON_x]

We've discussed this issue at length with Oracle DB team here and cannot seem to find any issue in Oracle logs. Our OS is Windows Server 2008 Std64 bit SP2, ArcSDE 10.1 SP1, and the server is a DellR710. Has anyone encountered a similar error? We're at our wits' end here. Thanks for any suggestions!



أكثر...
 
أعلى