I’m sure most ESRI customers received the following email from ESRI regarding the Oracle 10.2.0.4 patch and ArcSDE:
If you are a user of the ArcGIS Server 9.2 ST_GEOMETRY data type with Oracle, we would like to make you aware of the following issue:
The recently released Oracle patch version 10.2.0.4 may make unexpected changes to the ST_GEOMETRY schema. 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 strongly recommends that all Oracle-based customers not upgrade to the Oracle 10.2.0.4 patch 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 think you may be experiencing this issue, contact ESRI Support.
What is humorous about the whole issue (well at least funny to those not caught up in it) is that Oracle includes the following statement on their readme for 10.2.0.4 patch.
“Patch sets are a mechanism for delivering fully tested and integrated product fixes. Patch sets provide bug fixes only; they do not include new functionality and they do not require certification on the target system.”
Guess that isn’t the case, eh Oracle?
It seems that every time we meet, I have nothing but bad news. I’m sorry about that, I surely am.
8 responses so far ↓
1
rtm
// Apr 18, 2008 at 9:42 am
“ESRI recommends making a full back up of your Oracle database prior to applying any Oracle patch sets or interim patch. If functionality that was working prior to applying the Oracle patch set or interim patch stops working, return to the previous version of Oracle. Contact Oracle support as needed.”
http://support.esri.com/index.cfm?fa=knowledgebase.systemRequirements.formList&PN=ArcSDE&pvName=9.2&productID=19&PID=19&DN=&count=1&PVID=372&hn=PC-Intel+Windows+2003+Server+Standard%2C+Enterprise+%26+Datacenter&VID=1508
2
Cellulose
// Apr 18, 2008 at 6:09 pm
Ouch. I had some performance problems with Oracle Spatial a few months back and got in touch with Oracle. Before they would even give me the time-of-day, they forced me upgrade to the latest patch set… Glad I’m not working on that project anymore.
3
good buddy
// Apr 19, 2008 at 5:01 am
hello Oracle, this is Cell. How can we help you? i have a performance problem (with my database). Oh sounds like problem we have solved with Patch 77, have you applied patch 77. No, by the way do you have the time? Um, no we’re Oracle not Chronos, why dont you apply the patch and let us know how it goes. OK. Hi boss - Oracle told me they wont talk to me unless i apply the patch. OK lets give it whirl on our production database. I’ve got 20 years experience with this, and there has never been an issue with Oracle versions and ArcGIS at the service pack level. Hey by the way, anyone ever back this thing up?
4
Cellulose
// Apr 19, 2008 at 8:00 am
LOL! Sadly, that wasn’t too far from reality…
I guess I’m just glad that didn’t end with a call to ESRI: “Boss, I just got off the phone with ESRI and they told me all of my problems with be solved by ST_GEOMETRY… Let’s switch…” or they’d be really ticked right now.
5
Abe
// Apr 20, 2008 at 2:07 pm
Your Matrix quote made me lulz profusely.
6
AlbertW
// Apr 20, 2008 at 3:10 pm
Abe, I didn’t get it until now. That is absolutely hilarious.
James, you images and quotes are really what makes me read every post you write.
7
vinod Pathak
// May 21, 2008 at 5:42 am
from where i can download the patch file required to run arcSDE9.2 on oracle 10g
8
Rohit
// Jun 17, 2008 at 9:20 am
Oracle always recommends for such upgrades. In the mean time, DBAs or Developers try to solve database issues on their own and may get it solved. So less work for Oracle.
Leave a Comment