topic Re: Synchronize Replica Failed | ORA-3114: not connected to Oracle in ArcGIS Enterprise Questions

Synchronize Replica Failed | ORA-3114: not connected to Oracle

HiteshJilka — Mon, 05 Dec 2016 08:14:00 GMT

Hello,

ArcSDE v. 10.3

RDBMS: Oracle Db Enterprise 12c (12.1.0.2)

We have replicas with full extent and some with extent to their city boundaries.

Full extent replica synchronizes successfully even if I sync it in same day or after few days or even a week.

Extent based replica synchronizes successfully if I sync in same day or a gap of two days. But if I skip sync for more days (say 4 days) it fails with error "ORA-03114 not connected to Oracle" error after processing data. As there is loads of transactions saved daily, thus size of data transfer increases and as per my understanding, for extent boundaries replicas, data filtering before transfer causes long wait and thus results in error. It took more than 4 hours to filter data and then sync failed. Attached error screenshot FYR...

There is no connection timeout configuration done on Oracle side.

Will anyone please help me whether its a bug or any connection settings need to be done to prevent the same error.

Thanks,

Hitesh

Re: Synchronize Replica Failed | ORA-3114: not connected to Oracle

Asrujit_SenGupta — Mon, 05 Dec 2016 10:16:04 GMT

Does it fail in both cases: Disconnected synchronization and Connected Synchronization?

Re: Synchronize Replica Failed | ORA-3114: not connected to Oracle

HiteshJilka — Mon, 05 Dec 2016 10:27:01 GMT

I haven't tried disconnected sync. Not sure whether it will sync complete changes or from last sync state.

Re: Synchronize Replica Failed | ORA-3114: not connected to Oracle

Asrujit_SenGupta — Mon, 05 Dec 2016 12:51:27 GMT

Give it a try and let us know. It should sync all changes done after the last successful sync.

Note: Keep a backup, just in case.

Re: Synchronize Replica Failed | ORA-3114: not connected to Oracle

HiteshJilka — Mon, 12 Dec 2016 07:00:59 GMT

Hello Asrujit, I tried using disconnected sync but seems it takes alot of time similar to connected sync (more than 2 hours). I am facing slowness only on extent boundaries replica sync. Even it seems its hung on ArcMap session, but internally on DB side, its on event of retrieving data.

Even if there are few changes inserted, it takes long time to retrieve. Is there any way to improve sync process on extent based replicas ?

Thanks!