RE: ESRI ArcSDE application

Still think that having ArcIMS on a separate server is best.
 
Also, we do have ArcSDe installed on the same server as Oracle - SDE is the 
user for ArcSDE and Oracle - is the owner of the database.  That is quite 
manageable.  However, I also have taken on the role of ArcSDe ADmin. - makes 
life easier.
 
 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
Behalf Of Tom Brown
Sent: Friday, June 04, 2004 12:52 PM
To: fuadar@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: ESRI ArcSDE application


In response to Tom Mercadante's posting, ArcSDE can support various 
configurations -
 
1) Installing ArcSDE on the same node as the database server,
2) Installing ArcSDE on an application server,
3) Using a form of direct connect, where the SDE process is embedded as a DLL 
on the client (requires installing Oracle client on each workstation).
 
Each configuration provides various pros and cons.
 
In respect to 1) - It does not require an additional Oracle home. The software 
is installed as its own system user with its own executables. Does not require 
any access to the Oracle system user. All ArcSDE requires is an Oracle schema 
named SDE to create and manage a data dictionary.
 
You can find additional information, discussion forums, white papers, etc. 
http://support.esri.com/
 

Good luck.
 
Tom

-----Original Message-----
From: Fuad Arshad [mailto:fuadar@xxxxxxxxx]
Sent: Friday, June 04, 2004 9:39 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: ESRI ArcSDE application


paula any specific init.ora changes .
i know the dbtune defines tablespaces but other than that any thing specific to 
this application.


Paula_Stankus@xxxxxxxxxxxxxxx wrote:

Right on Tom!!!!!  ARcSDE by the way is ESRI's (vendor name) middle-tier that 
basically does "spatial" queries on geodatabases.  It is for supporting 
databases that have geographic components - like points, polygons, various type 
of shapes stored in your back-end RDBMS and on Oracle this is how it does it:
 
-You take a table with geographic coordinates - they call it a business table - 
it is basically a normal table with data elements that you can directly query 
(say list of streets in all of Florida) - it also has a shape_id.
-The shape-id is used to do a primary key join to a shape table called S999 
that corresponds to the business table.  It is basically an index table between 
the "business table" and the "feature table"
-There is also a F999 table that relates to the business table which has 
FID NOT NULL NUMBER(38)

NUMOFPTS NOT NULL NUMBER(38)

ENTITY NOT NULL NUMBER(38)

EMINX NOT NULL FLOAT(64)

EMINY NOT NULL FLOAT(64)

EMAXX NOT NULL FLOAT(64)

EMAXY NOT NULL FLOAT(64)

EMINZ FLOAT(64)

EMAXZ FLOAT(64)

MIN_MEASURE FLOAT(64)

MAX_MEASURE FLOAT(64)

AREA NOT NULL FLOAT(64)

LEN NOT NULL FLOAT(64)

POINTS LONG RAW

The FID above is a primary key feature id - it defines the "envelope" on which 
the "shape" will be drawn, - basically the "size" or your shape.  
 
-Then you have a number of indexes.
 
-When you load a "shapefile", "personal geodatabase", "coverage" into the 
Oracle database using ArcSde command line or the various ESRI tools you get 4 
tables for the price of 1 and associated indexes. 
 
-These tables are then used by the ArcSDE instance and its processes on your 
server to prepare a "secondary" query on the database for fast access.  
 
-There are a number of tools like ArcCatalog (very helpful) that can help you 
managing your ESRI geodatabase.
 
-Permissions - watch out for that.  There is a good starting manual called 
something like "ArcSde optimization for Oracle" - good place to start - read 
the whole thing.
 
 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
Behalf Of Mercadante, Thomas F
Sent: Friday, June 04, 2004 11:47 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: ESRI ArcSDE application


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@xxxxxxxxx] 
Sent: Friday, June 04, 2004 11:42 AM
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: