Moving from SDE 9.1 to 9.2

[sushmakavarthapu]

Good Morning All:


We have VB 6.0 application which uses MapObjects 2.3 and have Oracle 10g and ArcSDE 9.1 as back end. We are upgrading to oracle 11g which requires us to upgrade SDE to 9.2.

I have few questions regarding the upgrade:

1. For doing the above changes, do we have to upgrade to MO 2.4?
2. Do you see any potential problems if we remain at M02.3?
3. If I have to move to MO 2.4, How do I go through the process (such as dowload MO2.4 etc)?
4. Do I have to make any code changes as MapObjects 2.3 may not recognize?
5. How does that work with WIN 7 environment?

Any help will be greatly appreciated!

Thanx
Sushma

[VinceAngelo]

Support for Oracle 11g was added at ArcSDE 9.3 (not 9.2), with 64-bit support introduced
at 9.3.1.  Given that ArcGIS 9.2 will be retired with the release of ArcGIS 10.1, I'd normally
suggest a more recent ArcGIS release, but MapObjects 2.4 was retired nearly two years ago,
so there isn't any combination of ArcSDE and MapObjects which will work together under
Oracle 11g.  If you want to go with all-retired software, then your versions would be
Oracle 10.2.0.3/10.2.0.4, ArcSDE 9.2, and MO 2.4, but I wouldn't suggest trying to run
this software stack on anything more recent than Windows Server 2003.

- V

[sushmakavarthapu]

Thanx Vagelo for your quick response.

I need few clarifications

1. Oracle 11g works only with SDE 9.3 but not with 9.2. If we move to 9.3 does MO2.4 works with SDE 9.3?
2. You stated that "there isn't any combination of ArcSDE and MapObjects which will work together under
Oracle 11g ", So, you meant Oracle 11g does not work with SDE 9.3 and MO2.4 at all OR you meant to say it is not supported by ESRI. If it does not work, we shall halt our upgrade. Can you please confirm that.
3. Which version of SDE works with Oracle 11g?

Thanx a lot!
Sushma

[VinceAngelo]

I haven't used MapObjects since 2.0 was released, so all I can do is direct you to the support pages.

MapObjects 2.4 was last supported with ArcSDE 9.2. Oracle 11g support did not begin until ArcSDE 9.3.
What was supported with what is of limited use, because support for MapObjects 2.4 ended in July 2010
(MO 2.3 support ended in 2007),  Oracle's support for 10gR2 ended in May 2010, and ArcSDE 9.2 support
ends with 10.1 release this summer, so you're still deep in Unsupportedland.

You can prototype the upgrade to see if it might work (some 9.2 ArcSDE clients [post SP4] were supported
to connect to 9.3/9.3.1 ArcSDE servers, so there's some hope), but it's probably not wise to pursue a full
upgrade if your app doesn't work perfectly under rigorous testing on a modern host running 9.3.1SP2 on
Oracle 11.1.0.2.

I should also point out that ArcSDE 9.3 won't function without a license key, so you'll need to engage
your local Esri office to get the evaluation license to test this configuration.
 
- V