| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ESRI ArcSDE application
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.
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Arghadeep Chatterjee
Sent: Saturday, June 05, 2004 2:20 AM
To: oracle-l_at_freelists.org
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.
Deep
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 [mailto:fuadar_at_yahoo.com]
Sent: Friday, June 04, 2004 11:42 AM
To: oracle-l_at_freelists.org
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 ?.
Thanks
Fuad Arshad
 |
 |