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!
Best Answer
look for the autocommit parameter in the dbtune file.
I am still looking for the 10.1 version of that documentation.
here is a link for the dbtune configuration keywords.
And the server config parameters are here.
Of course I cant give you a specific value that will work for your server, and hardware.
It will be a function of the tablespaces involved, available ram, and definition of your tablespace growth