大量資料插入oracle串連中斷的問題

標籤：

這幾天在做大資料量入庫的儲存實驗，在大量資料執行擬造過程中資料庫出現了問題無法繼續執行，初步推斷是因為大資料量插入導致資料庫連接斷開，問題記錄如下：

原文地址：http://gis.stackexchange.com/questions/108297/oracle-error-when-copying-massive-feature-dataset

Oracle error when copying massive feature dataset

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!

大量資料插入oracle串連中斷的問題