Software Alert for ArcGIS Server 9.2
with Oracle 10.2.0.4
April 4, 2008
Introduction
Recently two ESRI customers have reported
problems to ESRI Technical Support after upgrading to Oracle 10.2.0.4. The
Oracle upgrade appears to be deleting some schema elements we require for the
spatial type (ST_GEOMETRY). Uninstalling the upgrade to restore the prior
version of Oracle does not work. ESRI is in contact with Oracle and we are
working together to understand and quickly resolve the problem in this Oracle
10.2.0.4 patch upgrade.
ESRI is strongly recommending that all
Oracle based customers do not upgrade to Oracle patch version 10.2.0.4 until
ESRI has certified this Oracle patch release with ArcGIS Server 9.2. If you
have already upgraded to Oracle 10.2.0.4 and have questions, please contact
ESRI Technical Support or your local international distributor as soon as
possible.
Summary of the Problem:
ArcSDE 9.2 instances create
PUBLIC synonyms for the SDE ST_GEOMETRY and subtypes; along with several
geometry, relation and assessor operators and functions. Upgrading to Oracle
10.2.0.4 causes ArcSDE 9.2 instances to fail during several operations
including “create feature class” when the reference to ST_GEOMETRY now refers
to MDSYS.ST_GEOMETRY (a.k.a. SDO_GEOMETRY).
Please note: At ESRI, we have
not been able to successfully roll back from the Oracle 10.2.0.4 to the
previous Oracle release.
