Execute privileges on required Oracle builtin package DBMS_UTILITY must be granted directly to the SDE DBA user, granting them a ROLE with execute access is insufficient. ERROR in checking system st_geometry type (-25).

check my esri forum thread replay: http://forums.arcgis.com/threads/60398-ArcSDE-execute-privilege-be-removed-from-public-on-Oracle-packages?p=329097#post329097

 

be careful in the order of executing the steps.

 

granting the following packages to “PUBLIC” role is always a security issue:

 

dbms_pipe 
dbms_lock 
dbms_lob 
dbms_utility
dbms_sql 
utl_raw

ArcGIS 10.2 Deprecation plan

you can find the deprecation plan here: http://downloads2.esri.com/support/TechArticles/W26496_W25918_DEPRECATION_PLAN_FOR_ARCGIS_101_and_102_FINAL_050713.pdf

REMARK: ArcGIS 10.2 will be the last for ArcSDE as an “application server”. This means companies/organizations using ArcSDE tehcnology as an application server, should start migrating to “Direct Connection” , which is a 2-tier architecture.