Just got this item...
Software Alert for ArcGIS Server 9.2 with Oracle
April 4, 2008
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.