Jump to content

Migrate ArcSDE 9.2/Oracle 10g Geodatabase


rami

Recommended Posts

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 by rami
Link to comment
Share on other sites

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 by rami
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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/
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

Disable-Adblock.png

 

If you enjoy our contents, support us by Disable ads Blocker or add GIS-area to your ads blocker whitelist