THREADS - ESRI Discussion Forums

You are here: Home > User Forums > arcgis server forums > Thread Replies

ArcGIS Server Forums

ArcGIS Server ArcSDE: General questions forum

ArcSDE on SQL Server using SDO_GEOMETRY?	Tyson Haverkort	Nov 03, 2009
Re: ArcSDE on SQL Server using SDO_GEOMETRY...	Vince Angelo	Nov 03, 2009
Re: ArcSDE on SQL Server using SDO_GEOMETRY...	Tyson Haverkort	Nov 03, 2009
Re: ArcSDE on SQL Server using SDO_GEOMETRY...	Vince Angelo	Nov 03, 2009
Re: ArcSDE on SQL Server using SDO_GEOMETRY...	Tyson Haverkort	Nov 03, 2009

Report Inappropriate Content • Top • Print • Reply
Subject	ArcSDE on SQL Server using SDO_GEOMETRY?
Author	Tyson Haverkort
Date	Nov 03, 2009
Message	Hi folks, I currently have ArcSDE installed on SQL Server. I would like to read and edit some Oracle Spatial data on another machine. Is this possible? Keep in mind that I have no ArcSDE on the Oracle machine, only on the SQL Server machine. With ArcSDE for Oracle installed on the Oracle machine, everything works as expected. Unfortunately, it's a requirement that nothing gets installed on the Oracle machine at the client site. What if I install ArcSDE for Oracle on the same machine as my current ArcSDE for SQL Server? Will SDE system data get written to the client's Oracle? Thanks, Tyson

Report Inappropriate Content • Top • Print • Reply
Subject	Re: ArcSDE on SQL Server using SDO_GEOMETRY?
Author	Vince Angelo
Date	Nov 03, 2009
Message	This isn't nearly as difficult as you've posed the problem -- just ignore the presence of ArcSDE for SQL-Server and follow the procedures for a "remote server" install of Oracle (including the part where you use Direct Connect, and virtually ignore the application server). - V

Report Inappropriate Content • Top • Print • Reply
Subject	Re: ArcSDE on SQL Server using SDO_GEOMETRY?
Author	Tyson Haverkort
Date	Nov 03, 2009
Message	Thanks Vince, Just one point I'd like to clarify.... When you say 'follow the procedures for a "remote server" install of Oracle' does Oracle refer to ArcSDE for Oracle? That's what I'm trying to avoid. What I'm asking, in a nutshell, is can I edit Oracle data: 1) without SDE (from what I've read, I would say no, unless I'm willing to write some MO code) 2) with ArcSDE for SQLServer where the oracle is on a remote database. Maybe the answer is a simple 'no', and like you suggest, I'll have to install ArcSDE for Oracle on the client and use that to connect remotely to the database. Thanks for your help. Tyson

Report Inappropriate Content • Top • Print • Reply
Subject	Re: ArcSDE on SQL Server using SDO_GEOMETRY?
Author	Vince Angelo
Date	Nov 03, 2009
Message	Sorry, "'remote server' install of ArcSDE for Oracle". 1) NO. 2) NO. Only ArcSDE for Oracle will function with an Oracle database. Futhermore, only ArcSDE for Oracle 10g will function with Oracle 10g (and ArcSDE for 11g with 11g). I really don't see what the big deal is: You've already configured the Oracle instance -- no more is necessary. [Just for the record, it's foolish to prevent installation of database extensions on the database server; the only possible exception is with RAC nodes, and given ST_GEOMETRY, it's really foolish to not install on both/all.] - V

Report Inappropriate Content • Top • Print • Reply
Subject	Re: ArcSDE on SQL Server using SDO_GEOMETRY?
Author	Tyson Haverkort
Date	Nov 03, 2009
Message	Thanks again Vince, That's exactly what I needed to know. Yes, I've configured an Oracle service, but all this was on my test machine. I won't have that luxury on the production server at the client site. I agree that the DBAs are being a bit overzealous, but unfortunately it's my clients requirement that I have to live with. Thanks, Tyson