Supported Database Versions
Standard/Standard One/Enterprise Editions:
Oracle 10g R2 (32-bit) 10.2.0.3
Oracle 10g R2 (64-bit) 10.2.0.3
Oracle 11g R1 (32-bit) 11.1.0.7
Oracle 11g R1 (64-bit) 11.1.0.7
Oracle 11g R2 (64-bit) 11.2.0.1
Express Edition:
Oracle 10g (32 bit) 10.2.0.1 - Windows Only (For development and testing only, not for production deployment)
Supported Operating Systems
| Database | Supported Operating System(s) | Minimum OS Version | Maximum OS Version |
|---|---|---|---|
| Oracle 10g R2 (32-bit)10.2.0.3 | Red Hat Enterprise Linux AS/ES 4 (32-bit) | Update 7 | Update 7 |
| Windows Server 2003 Standard, Enterprise & Datacenter (32-bit) | SP2 | SP2 | |
| Windows Server 2008 Standard, Enterprise & Datacenter (32-bit) | SP1 | SP1 | |
| Oracle 10g R2 (64-bit) 10.2.0.3 | HP HP-UX 11i v2 (B.11.23) Itanium | ||
| IBM AIX 5.3.0.0 | |||
| IBM AIX 6.1.0.0 | |||
| Red Hat Enterprise Linux AS/ES 4 (64-bit) | Update 5 | Update 5 | |
| Red Hat Enterprise Linux Server Release 5 (64-bit) | Update 5 | Update 5 | |
| Sun Solaris 9 (64-bit (SPARC)) | |||
| Sun Solaris 10 (64-bit (SPARC)) | |||
| Windows Server 2003 Standard, Enterprise & Datacenter (64-bit (AMD64/EM64T)) | SP2 | SP2 | |
|
Oracle 11g R1 (32-bit) 11.1.0.7 |
Red Hat Enterprise Linux AS/ES 4 (32-bit) |
Update 5 | Update 5 |
|
Red Hat Enterprise Linux AS/ES 5 (32-bit)** |
Update 5 | Update 5 | |
|
Windows Server 2003 Standard, Enterprise & Datacenter (32-bit) |
SP2 | SP2 | |
|
Windows Server 2008 Standard, Enterprise & Datacenter (32-bit) |
SP1 | SP1 | |
| Oracle 11g R1 (64-bit) 11.1.0.7 | HP HP-UX 11i v2 (B.11.23) Itanium | ||
| IBM AIX 5.3.0.0 | |||
| IBM AIX 6.1.0.0 | |||
| Red Hat Enterprise Linux AS/ES 4 (64-bit) | Update 6 | Update 6 | |
| Red Hat Enterprise Linux Server 5 (64-bit) | Update 4 | Update 4 | |
| Sun Solaris 9 (64-bit (SPARC)) | |||
| Sun Solaris 10 (64-bit (SPARC)) | |||
| Windows Server 2003 Standard, Enterprise & Datacenter (64-bit (AMD64/EM64T)) | SP2 | SP2 | |
| Windows Server 2008 Standard, Enterprise & Datacenter (64-bit (AMD64/EM64T)) | SP1 | SP1 | |
| Oracle 11g R2 (64-bit) 11.2.0.1 | HP HP-UX 11i v3 (B.11.31) Itanium* | ||
| IBM AIX 5.3.0.0 | |||
| IBM AIX 6.1.0.0 | |||
| IBM AIX 7.1.0.0** | |||
| Red Hat Enterprise Linux AS/ES 4 (64-bit) | Update 7 | Update 7 | |
| Red Hat Enterprise Linux Server 5 (64-bit) | Update 5 | Update 5 | |
| Red Hat Enterprise Linux AS/ES 6 (64-bit)*** | |||
| Solaris 10 (64-bit (SPARC)) | |||
| SUSE Linux Enterprise Server 10 (64-bit) | SP2 | SP2 | |
| SUSE Linux Enterprise Server 11 (64-bit)** | |||
| Windows Server 2008 R2 Standard, Enterprise & Datacenter (64-bit (AMD64/EM64T))* |
*Support begins at ArcSDE 10 SP1
**Support begins at ArcSDE 10 SP2
***Support begins at ArcSDE 10 SP3
Database Requirements
Important Note: The Oracle Text component must be installed. The Text component is installed by default in Oracle 10g and 11g; however, if you did not perform a default installation, the Text component may not have been installed.
Also note that if there is no native ArcSDE build for the operating system of the server hosting the Oracle database, then there is no support for SQL access to ST_Geometry or ST_Raster. ST_Geometry and ST_Raster storage can be used from ArcSDE clients, but SQL access to this data is not supported.
Oracle 10g R2 (10.2.0.x) Requirements
Oracle 10.2.0.3 ST_GEOMETRY users - need to apply Oracle Patch that fixes Oracle bug 6756089
Oracle 10.2.0.3 ST_GEOMETRY users - please see KB Article 34460 on the Esri Support site
Oracle 11g R1 (11.1.0.x) Requirements
NOTE: To use Oracle's native XML type, you must use Oracle 11.1.0.7 with one of the following patches applied:
- 8593954 - For Linux 32 bit and 64 bit, Sun Solaris, HP-UX Itanium, and IBM AIX
- 8655458 (patch 15) - For Windows 32 bit
- 8655460 - For Windows 64 bit
Windows Server 2008 SP1 64bit is supported on Oracle 11.1.0.7 64bit as the base version.
Oracle 11g R2 (11.2.0.x) Requirements
NOTE: Oracle 11.2.0.1 users - may need to apply Oracle Patch 8795792. See KB Article 38470 for more information.
NOTE: Oracle 11.2.0.2 users - See KB Article 38713 if using versioned Oracle Spatial feature classes.
Required Configuration: When ArcSDE 10 (32-bit) is installed on a Windows or Linux 32-bit operating system (OS), you must use an Oracle 32-bit client to access an Oracle 64-bit database. This must be done for both application server and direct connections. Instructions for setting up ArcSDE 10 (32-bit) using the Oracle 32-bit client to connect correctly to the Oracle 64-bit database are as follows:
- Install the Oracle 32-bit client software (see Oracle Support for download, install and setup instructions).
- Create a service name using the Oracle 32-bit Net Manager you just installed to connect to your Oracle 64-bit database.
- Install and setup ArcSDE 10 making sure you are using the correct version of the Oracle 32-bit install. Use the Oracle 32-bit service name you defined above for the connection to the Oracle 64-bit database.
Oracle Database Patch Support
Oracle 10.2.0.3, 11.1.0.7 and 11.2.0.1 or higher Oracle Patch. This includes Oracle patch set levels and Oracle Interim (One-Off) Patch as per Oracle Corporation's Patch Set Overview and Interim Patch documentation.
See Oracle Support for all Oracle patch set (and Interim Patch) documentation and install instructions. Esri recommends making a full back up of your Oracle database prior to applying any Oracle patch sets or interim patch. If functionality that was working prior to applying the Oracle patch set or interim patch stops working, return to the previous version of Oracle. Contact Oracle support as needed.
Operating System Limitations
HP HP-UX 11i v3 (B.11.31) Itanium
Mandatory Open Network Computing (ONC) plus version ONCplus B.11.31.08. For more information, please visit HP.
Linux
ArcSDE is only supported on
- Linux x86, on CPUs that adhere to the x86 architecture (32-bit), with supported Linux releases.
- Linux x86_64, on CPUs that adhere to the x86_64 architecture (64-bit), with supported Linux releases.
Windows 7
Windows 7 64-bit is supported with Oracle11gR2 64-bit at 10 SP1 for basic testing and application development use only. It is not recommended for deployment in a production environment.