These days in large data storage experiment, in a lot of data to perform the process of the database problems can not continue to execute, the preliminary inference is because the large data volume insertion causes the database connection to disconnect, the problem record is as follows:
Original address: 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 datasets with roughly 3 million objects as well as a few thousand tables and rel Ationship classes, my team is running to an
' Underlying DBMS error [Ora-03114:not connected to ORACLE][SDE. DEFAULT] '
Message 9 times out of 10 ... I ' m hoping someone have run into a similar issue. We are literally copying the feature datasets from one connection file and pasting it into another connection file/environm Ent. This works fine with smaller sets of data. However, for this bigger dataset transfer, we is running into this problem-the process copies all objects but fails in The late stages (I think when it was copying tables). This is killing us, since the process takes about 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 the Oracle DB team here and cannot seem to find any issue in Oracle logs. Our OS are Windows Server 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! |
Large amounts of data plugged into an Oracle connectivity outage