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

1488
4
12-05-2016 12:14 AM
HiteshJilka
New Contributor III

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

0 Kudos
4 Replies
Asrujit_SenGupta
MVP Regular Contributor

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

0 Kudos
HiteshJilka
New Contributor III

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

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor

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.

0 Kudos
HiteshJilka
New Contributor III

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!

0 Kudos