Upgrading from sde 9.2/oracle10g to sde 10.2/oracle11g

[المشرف العام]

I have an old geodatabase created using Arcsde 9.2 on Oracle 10g.

Now, I'm trying to update it to new system using ArcSDE 10.2 on Oracle 11g r2.

Because SDE 9.2 schema and SDE 10.2 are not compatible with each other, 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

What I did:

1. I made two vmware machines with win2003 installed on both, the first named dbserver and the second named sdeclient
2. On dbserver, I installed Oracle 10g.
3. On sdeclient, I installed Oracle client 10.2, ArcGIS Desktop 10, ArcSDE 10.
4. I creted new database named testdb On dbserver [while the original database name calgarydb].
5. I exported calgarydb from the real system and imported it to testdb.
6. I tested connection through oracle client on sdeclient to dbserver and it was succeeded.
7. From ArcCatalog 10.0 I tried to use direct connection to testdb on dbserver using the following parameters:
   • Server : none
   • Service : sderacle10g:testdb
   • Database: none
   • Username: system
   • Password: pass
   • Connection details: sde.DEFAULT

but 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]

Any idea please.



أكثر...