jbradfor

ArcGIS Server 10.1 & SDE Architecture

Discussion created by jbradfor on Mar 1, 2013
We are preparing for a 10.1 upgrade.

Right now, we have SDE running standalone on 4 different Linux boxes, for example:

devbox1 ??? points to SDE schema on our Oracle 11g DEV tier
intbox1 - points to SDE schema on our Oracle 11g INT tier
qabox1 - points to SDE schema on our Oracle 11g QA tier
prodbox1 - points to SDE schema on our Oracle 11g PROD tier

We use Oracle Spatial (SDO_GEOMETRY col) tables and register them with SDE.

We have 2 ArcGIS Servers ??? DEV & PROD

SDE now comes with ArcGIS Server, however, we have a need to maintain these different tiers.  If we only have 1 ArcGIS Server DEV box (with embedded SDE), how would we handle registering of the tables on each of the remaining Pre-Prod tiers (int & qa)?

Right now, I run this command 4 times (only changing the server name), once the table is ready and populated in Oracle.

sdelayer -o register -l SCHEMA1.TABLE1,GEOM -e na+ -C MAP_ID,USER -u useridx -p pwdx -s devbox1 -i port:5151 -t SDO_GEOMETRY -k SCHEMA1 -R 8
sdelayer -o register -l SCHEMA1.TABLE1,GEOM -e na+ -C MAP_ID,USER -u useridx -p pwdx -s intbox1 -i port:5151 -t SDO_GEOMETRY -k SCHEMA1 -R 8
sdelayer -o register -l SCHEMA1.TABLE1,GEOM -e na+ -C MAP_ID,USER -u useridx -p pwdx -s qabox1 -i port:5151 -t SDO_GEOMETRY -k SCHEMA1 -R 8
sdelayer -o register -l SCHEMA1.TABLE1,GEOM -e na+ -C MAP_ID,USER -u useridx -p pwdx -s prodbox1 -i port:5151 -t SDO_GEOMETRY -k SCHEMA1 -R 8

Outcomes