July 23, 2008

Can ArcGIS Server 9.3 Be Used With Oracle Express Edition?

[ 2 ] Comments
Share

ESRI has added a technical article to the ESRI Support Centre answering this question. I have had a few people ask about the support for Oracle Express Edition (XE) when using ArcGIS Server 9.3.

Question
Can ArcGIS Server 9.3 Enterprise (all editions) be used with Oracle Express Edition (XE)?

Answer
Yes, Oracle XE can be used as the DBMS platform to support an Enterprise ArcSDE geodatabase. Because of the DBMS limitations listed below, ESRI recommends that ArcGIS Server Enterprise and Oracle Express Edition (XE) should only be used together for developing and testing applications and not for production environments.

For those that don’t know about Oracle Express Edition.

Oracle Database 10g Express Edition (Oracle XE) is a no-cost edition of Oracle Database 10g. It is built with the same code base as Oracle Database 10g R2 and is available for 32-bit Linux and Windows platforms. It is free to deploy and embed in custom applications and upgradeable to other licensed Oracle editions.

Oracle Express Edition is similar to Microsoft SQL Server Express Edition. Using Oracle Express Edition does introduce some limitations

  • Oracle XE memory usage is limited to 1 GB RAM on 1 CPU.
  • Each Oracle XE database is limited to 4 GB in size.
  • No DBMS support for the following: Oracle Data Guard, Oracle RAC, Oracle clusterware, Java, Java server pages, Web services, 64-bit Itanium operating systems, iSQL*Plus, automatic storage management, partitioning, OLAP, data mining, transportable tablespaces, and synchronous/asynchronous change data capture.
  • Limited DBMS security, flashback availability, database backup options, change/configuration management, and database replication.

The one thing to note is that while ESRI supports this implementation, it should only be used to development or testing applications. The ESRI Support Centre technical article can be found here: http://support.esri.com/index.cfm…

2 Responses To Can ArcGIS Server 9.3 Be Used With Oracle Express Edition?

  1. Clay Wise says:
    January 1, 1970 at 12:00 PM

    I am not sure what has changed in 9.3, but when testing this in the past it was not possible due to the fact that when you install SDE on top of any Oracle box it creates an SDE tablespace similar to the system tablespace that Oracle provides out of the box. Oracle Express only lets you have a USER tablespace, thus the SDE install fails. Maybe some clarification needs to happen in regards to whether it is the workgroup SDE or enterprise.

  2. jhon says:
    January 1, 1970 at 12:00 PM

    Dear All.

    Please help me, how we can setup arcGis into oracle? because I want get data from oracle that a i want reading in geodatabase?

    thank’s