topic Re: ArcGis 10 Installing Oracle on Exadata, and then ArcSDE on PC server? in Data Management Questions

ArcGis 10 Installing Oracle on Exadata, and then ArcSDE on PC server?

huazheng — Thu, 05 May 2011 12:34:47 GMT

Recently, we designed the Arcgis Architecture as attached drawings.   It is a scenarios of Installing Oracle and ArcSDE on separate servers .

   For the Oracle server, we choose oracle Exadata as DB server:
hardware�?Oracle Exadata
DB�? 11.2.0.2.0 RAC
OS�? Oracle EL

   Because Oracle EL is not certified as a Geodatabase & ArcSDE platform.   so we need use another server to install ArcSDE:
ArcSDE 10
Oracle 11g R2 client
PC Server
CPU/MEM:   2x Intel Xeon 5600 /32GB
OS�? Red Hat Enterprise
Linux AS/ES 4 (64-bit) Update 7

     I have some concern about the architecture:
It is workable?
How about the performance?
What do us need focus on for delivery?

     Thank you for your suggestion.

Re: ArcGis 10 Installing Oracle on Exadata, and then ArcSDE on PC server?

VinceAngelo — Thu, 05 May 2011 13:29:52 GMT

In order to get ST_GEOMETRY available through non-ArcGIS clients, you'll need to install at
least the ArcSDE libraries on the listener hosts; installing ArcSDE is optional but recommended.

With Direct Connect a possibility from clients (recommended to RAC servers), there is no
requirement that an ArcSDE application server be installed, though if you have an ArcGIS
server host, then I'd recommend you install ArcSDE for an application server there (it helps
with install management).

Most 10.x upgrades are done through ArcCatalog, so the location of ArcSDE is less critical.

Keep an eye out for the hotfix for 11.2.0.2 support.

- V

Re: ArcGis 10 Installing Oracle on Exadata, and then ArcSDE on PC server?

huazheng — Fri, 06 May 2011 13:21:57 GMT

Hi V�?

thank you for your comments, BTW, would you like to share me the link of hotfix for oracle 11.2.0.2 ? I am not so familiar with ESRI website.

Re: ArcGis 10 Installing Oracle on Exadata, and then ArcSDE on PC server?

VinceAngelo — Fri, 06 May 2011 14:14:20 GMT

There is a known issue with Oracle 11.2.0.2 and versioned SDO_GEOMETRY layers.
No solution has been published, hence you should look for one in the future.

- V