rami Posted July 3, 2015 Report Share Posted July 3, 2015 (edited) Hello friends, I have an old geodatabase created using Arcsde 9.2 on Oracle 10g. Now, I'm trying to migrate it to new system using ArcSDE 10.2 on Oracle 11g 2. Any guidance or advices please. Edited July 3, 2015 by rami Quote Link to comment Share on other sites More sharing options...
rahmansunbeam Posted July 4, 2015 Report Share Posted July 4, 2015 https://oracle-base.com/articles/11g/upgrading-to-11g It's quite straightforward. Consider upgrade the Oracle dbase before the SDE. You can even use RMAN to transfer in different server. BTW, why 11g. why not the latest 12c? Quote Link to comment Share on other sites More sharing options...
rami Posted July 5, 2015 Author Report Share Posted July 5, 2015 (edited) Thank you @rahmansunbeam,Actually, the difficulties appear when upgrading the SDE 9.2 schema to SDE 10.2, they are completely not compatible with each other (ArcSDE 10.2 can not read SDE 9.2 schema). So, I tried to setup a transition stage through ArcSDE 10.0. ie: SDE 9.2/Ora 10g ---> SDE 10.0/Ora 10g ---> SDE 10.2/Ora 11g r2 I'm facing a lot of troubles related to versions compatibility between ArcSDE, Oracle DB, Oracle client, Windows 32 bit, Windows 64 bit. I need some guidance. Edited July 6, 2015 by rami Quote Link to comment Share on other sites More sharing options...
rahmansunbeam Posted July 6, 2015 Report Share Posted July 6, 2015 As suggested here, upgrade 10g to 11g upgrade SDE 9.3 to 10 migrate ST_GEOMETRY to SDO_GEOMETRY Also don't forget to try the "Migrate Storage" tool of ArcCatalog. Quote Link to comment Share on other sites More sharing options...
rami Posted July 6, 2015 Author Report Share Posted July 6, 2015 Thank you very much for replay, When I tried to use direct connection from ArcCatalog 10.0 to GeoDatabase (Oracle 10g / SDE 9.2) I received the following error: Failed to connect to the specified server. Operation Failed [Connection failed when attempting to connect using a 10.0 direct connect driver to 9.2 geodatabase. Missing suitable direct connection driver for this connection type. Please install the 9.2 direct connection driver. ArcSde Direct Connect driver release - 100001; ArcSde database instance release - 92011; ArcSde low release for instance - 92005] Where to find this driver? I didn't find it on Esri download site. Or, Is there a workaround for this error? Any idea please. Quote Link to comment Share on other sites More sharing options...
rahmansunbeam Posted July 6, 2015 Report Share Posted July 6, 2015 That tool is for migrating from ST_GEOMETRY to SDO_GEOMETRY, not SDE. You need to complete step 2 before 3. Since you don't have ArcSDE 9.3, you'ill need to upgrade 9.2 to 10. Check whether you- have proper privileges for your user have correct path and storage type using only 32bit version of Oracle, since geodatabase doesn't support 64bit haven't changed the database already have understood the sde_setup.log and oracle log files Always consider the latest service packs for both Oracle and ESRI. Read these threads for more, https://geonet.esri.com/thread/73506 http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Upgrading_an_ArcSDE_geodatabase_in_Oracle/002n000000p8000000/ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.