Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ESRI ArcSDE application

RE: ESRI ArcSDE application

From: Mark W. Farnham <>
Date: Sat, 5 Jun 2004 06:19:41 -0400
Message-ID: <>

MessageThere is a 200-plus page pdf document on the ESRI web site discussing machine layout considerations. There is an excellent chance that a database server being accessed by ArcSDE is exclusively serving a GIS community. ArcSDE is among the class of applications that receives a fairly terse client request, does potentially a *LOT* of interaction with the database engine, and then delivers a response to the client. So while the security concern is always valid, I believe this is really a load balancing and network bandwidth question that cannot be answered in a vacuum. If most or all of the other applications supported by your applications server only talk to the database via ArcSDE requests (and probably in shorthand), then there is a good chance ArcSDE should fall on the database server side of the network boundaries.

This gets more interesting, however, if you are deploying a "grid." Which database server would get ArcSDE? In that case, you'd probably want ArcSDE participating in the database grid communications segment, but on its own server.

I'm not sure how ArcSDE would force multiple Oracle homes, and I would love to be enlightened in regard to that comment.

  -----Original Message-----
[]On Behalf Of Arghadeep Chatterjee   Sent: Saturday, June 05, 2004 2:20 AM
  Subject: Re: ESRI ArcSDE application

  I dont think you should install app in the database server it would complicate things just as Thomas mentioned and would also be a security breach.

    Never heard or ArcSDE. But I would not let them install apps on the database server. No real reason to do so. It would force multiple Oracle homes, would open up the door to allowing them access to the server (you *know* they will want full access to the server), and just complicate managing the server.

    You have an app server machine. Force them to use it.

    just my 2 cents.

    Tom Mercadante
    Oracle Certified Professional

      -----Original Message-----
      From: Fuad Arshad []
      Sent: Friday, June 04, 2004 11:42 AM
      Subject: ESRI ArcSDE application

      We're working on an ArcSde migration from sqlserver to oracle. i
believe the version is 8.2
      i was wondering if  anyone had  any gotchas  or  any information that
we shoudl know. mind you the consultant we have has no clue of either unix nor oracle.

      Also the consultants are recommending installing app on the database server instead of an app server. This is something i dont like and if anyone has done so reason why is it necessary ?.


      Fuad Arshad

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at FAQ is at
Received on Sat Jun 05 2004 - 05:22:26 CDT

Original text of this message