Back to ArcGIS Server System Requirements

ArcSDE Oracle Database Requirements

Supported Database Versions
Supported Operating Systems
Database Requirements
Operating System Limitations

Supported Database Versions

Standard One/Standard/Enterprise Editions:
Oracle 9i (32 bit) 9.2.0.7
Oracle 9i (64 bit) 9.2.0.7
Oracle 10g (32 bit) 10.2.0.3
Oracle 10g (64 bit) 10.2.0.3
Oracle 11g (32 bit) 11.1.0.6
Oracle 11g (64 bit) 11.1.0.6
Oracle 11g (64 bit) 11.1.0.7

Express Edition:
Oracle 10g (32 bit) 10.2.0.2 - Windows Only (For development and testing only, not for production deployment)

Click here for additional Oracle Patch Support information

Supported Operating Systems

All ArcGIS Server customers that are current on maintenance will receive the ArcGIS 9.3.1 Update package. Current ArcGIS Server (ArcSDE) users that have already requested and installed the 9.3 64 bit version may use this Update package. For those customers that have not requested the 9.3 64 bit DVD, please contact ESRI Customer Service for the full version ArcGIS Server 9.3.1 Enterprise, which includes ArcSDE. ArcGIS 9.3.1 full version install does not require ArcGIS 9.3, 9.3 SP1 or 9.3.1 Updates to be applied. International customers, please contact your local distributor.

Database Requirements

Oracle 9i R2 (9.2.0.x) Requirements

If your database is Oracle 9i R2 (9.2.0.x) you must use the ArcSDE 9.3 for Oracle 9i R2 software.

Oracle 9i Release 2 Database Patch Support
Database: Oracle 9.2.0.7 or higher Oracle9iR2 Patch. This includes Oracle 9i Release 2 patch set levels and Oracle Interim (One-Off) Patch as per Oracle Corporation's Patch Set Overview and Interim Patch documentation.

Oracle 10g R2 (10.2.0.x) Requirements

If your database is Oracle 10g R2 (10.2.0.x), you must use the ArcSDE 9.3 for Oracle 10gR2 release.

NOTE:
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 ESRI support site

Required Configuration: When ArcSDE (32-bit) 9.3 is installed on a Windows or Linux 32-bit operating system (OS), you must use an Oracle10gR2 32-bit client to access an Oracle10gR2 64-bit database. This must be done for both application server and direct connections (See Oracle Database Upgrade Guide, 10g Release 2 (10.2) Chapter 6). Instructions for setting up ArcSDE (32-bit) 9.3 using the Oracle10gR2 32-bit client to connect correctly to the Oracle10gR2 64-bit database are as follows:

• Install the 32bit Oracle 10gR2 (10.2.0.3) client software (see Oracle Metalink for download, install and setup instructions).
• Create a service name using the 32bit Oracle 10gR2 Net Manager you just installed to connect to your 64bit Oracle10gR2 database.
• Install and setup ArcSDE 9.3 making sure you are using the correct version of the 32bit Oracle 10gR2 install. Use the 32bit Oracle 10gR2 service name you defined above for the connection to the 64bit Oracle10gR2 database.

Oracle 10g R2 Database Patch Support
Oracle 10.2.0.3 or higher Oracle10gR2 Patch. This includes Oracle 10g Release 2 patch set levels and Oracle Interim (One-Off) Patch as per Oracle Corporation's Patch Set Overview and Interim Patch documentation.

Oracle 11g (11.1.0.x) Requirements

NOTE:
Oracle 11.1.0.6 ST_GEOMETRY users - need to apply Oracle Patch that fixes Oracle bug 6756089

Oracle 11g R1 Database Patch Support
Oracle 11.1.0.6 or higher Oracle 11g Patch. This includes Oracle 11g Release 1 patch set levels and Oracle Interim (One-Off) Patch as per Oracle Corporation's Patch Set Overview and Interim Patch documentation.

Windows Server 2008 64bit is supported on Oracle 11.1.0.7 64bit as the base version.

See Oracle Metalink 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 (B.11.11) PA-RISC

• Window System: CDE or HP VUE
• Mandatory HP-UX Operating System patches:
  PHSS_27700
  PHCO_31923
  PHCO_33711
  PHKL_33258

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 the following HP link:
https://h20392.www2.hp.com/portal/swdepot/displayProductInfo.do?productNumber=ONCplus

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.

Back to ArcGIS Server System Requirements