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:
- I made two vmware machines with win2003 installed on both, the first named
dbserverand the second named
dbserver, I installed Oracle 10g.
sdeclient, I installed Oracle client 10.2, ArcGIS Desktop 10, ArcSDE 10.
- I creted new database named
dbserver[while the original database name
- I exported
calgarydbfrom the real system and imported it to
- I tested connection through oracle client on
dbserverand it was succeeded.
- From ArcCatalog 10.0 I tried to use direct connection to
dbserverusing the following parameters:
- Server : none
- Service : sde:oracle10g: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.