topic Re: 10.8.1 and Oracle version in ArcMap Questions

10.8.1 and Oracle version

KetanDoshi — Tue, 02 Mar 2021 18:58:49 GMT

Support is telling me ArcMap 10.8.1 is not supported on oracle version above 19.3.

Oracle database requirements for ArcGIS 10.8.x and ArcGIS Pro 2.5, 2.6, and 2.7—System Requirements | Documentation

We are on oracle 19.9 and have issues with Triggers on Parcel Fabric.

We don't have any issues with non parcel fabric triggers or editing fabric.

Has anyone faced any issues with ArcMap 10.8.1, parcel fabric and oracle version above 19.3 ?

Thanks

Re: 10.8.1 and Oracle version

RobertBorchert — Tue, 02 Mar 2021 19:06:18 GMT

Have you installed

Oracle 11203 64 bit client

Re: 10.8.1 and Oracle version

KetanDoshi — Tue, 02 Mar 2021 20:48:26 GMT

I think for ArcMap we need 32 bit client and that is installed.

Re: 10.8.1 and Oracle version

RobertBorchert — Wed, 03 Mar 2021 12:07:31 GMT

From the requirements link you posted in the original post it says 64 bit

Re: 10.8.1 and Oracle version

KetanDoshi — Thu, 18 Mar 2021 15:38:46 GMT

I don't think client is an issue as everything except and issue with fabric trigger on our delta table which started raising error after migrating to oracle 19c, is working fine.

Editors are able to edit fabric, reconcile/post and we are also able to create new versions as usual in our automated fashion every night and edits are pushed to base table.

Everything worked fine in our Oracle 12c environment and everything remains the same its only we migrated our oracle database to 19c

Trigger Error is related to SRID - Invalid SRID in the SDO_Geometry object

I would like to know if anyone had any issues on fabric after migrating to oracle 19c

Re: 10.8.1 and Oracle version

KetanDoshi — Mon, 03 May 2021 17:37:47 GMT

It turns out to be an Oracle issue.

SDO_GEOM.SDO_AREA function raised an exception on Fabric feature classes.

Same function worked fine on Non-Fabric feature classes.

All cumulative patches were applied to our 19.9 version as suggested by Oracle documentation during installation, on the top of that Oracle gave us a merge patch (snap shot attached) to be applied on 19.9 and everything is back to normal.