Oracle database requirements for ArcGIS 10.5.x

Visit Esri Support for the Esri Supported Environment Policy, as well as information on earlier versions.

Supported database versions

Standard/Standard One/Enterprise Editions:

Oracle 11g R2 (64 bit) 11.2.0.4

Oracle 12c R1 (64 bit) 12.1.0.2

Oracle 12c R2 (64 bit) 12.2.0.1*

Click here for Oracle Patch Support

*You must install ArcGIS 10.5.1 (Desktop, Engine, Server) Oracle critical issues and 12.2.01 Support Patch on all 10.5.1 client machines to use Oracle 12.2.01 with ArcGIS.

Supported operating systems

Database	Supported operating systems	Latest update or service pack tested
Oracle 11g R2 (64 bit) 11.2.0.4 Click here for Database Requirements	IBM AIX 6.1.0.0 (64 bit)
	IBM AIX 7.1.0.0 (64 bit)
	Oracle Linux Server 5 (64 bit) (see note below)	Update 10
	Oracle Linux Server 6 (64 bit) (see note below)	Update 8
	Red Hat Enterprise Linux AS/ES 5 (64 bit)	Update 11
	Red Hat Enterprise Linux AS/ES 6 (64 bit)	Update 8
	Oracle Solaris 10 (64 bit [SPARC])
	Oracle Solaris 11 (64 bit [SPARC])
	SUSE Linux Enterprise Server 11 (64 bit)	SP2
	Windows Server 2008 R2 Standard, Enterprise, and Datacenter (64 bit [EM64T])	SP1
	Windows Server 2012 Standard and Datacenter (64 bit [EM64T])	Update: April 2017
	Windows Server 2012 R2 Standard and Datacenter (64 bit [EM64T])	Update: April 2017
Oracle 12c R1 (64 bit) 12.1.0.2 Click here for Database Requirements	IBM AIX 7.1.0.0 (64 bit)
	Oracle Linux Server 5 (64 bit)	Update 10
	Oracle Linux Server 6 (64 bit)	Update 8
	Red Hat Enterprise Linux AS/ES 5 (64 bit)	Update 11
	Red Hat Enterprise Linux AS/ES 6 (64 bit)	Update 8
	Red Hat Enterprise Linux AS/ES 7 (64 bit)	Update 2
	Oracle Solaris 10 (64 bit [SPARC])
	Oracle Solaris 11 (64 bit [SPARC])
	SUSE Linux Enterprise Server 11 (64 bit)	SP4
	Windows Server 2008 R2 Standard, Enterprise, and Datacenter (64 bit [EM64T])	SP1
	Windows Server 2012 Standard and Datacenter (64 bit [EM64T])	Update: April 2017
	Windows Server 2012 R2 Standard and Datacenter (64 bit [EM64T])	Update: April 2017
Oracle 12c R2 (64 bit) 12.2.0.1 Click here for Database Requirements	IBM AIX 7.1 (64 bit)	Level 3 Service Pack 4
	IBM AIX 7.2 (64 bit)	Level 0 Service Pack 1
	Oracle Linux Server 6.4 (64 bit)
	Oracle Linux Server 7 (64 bit)
	Oracle Linux Server 7.2 (64 bit)
	Red Hat Enterprise Linux AS/ES 6.4 (64 bit)
	Red Hat Enterprise Linux AS/ES 7 (64 bit)
	Oracle Solaris 10 (64 bit [SPARC])	Update 11
	Oracle Solaris 11.2 (64 bit [SPARC])	SRU 5.5
	SUSE Linux Enterprise Server 12 (64 bit)	SP1
	Windows Server 2012 Standard and Datacenter (64 bit [EM64T])	Update: April 2017
	Windows Server 2012 R2 Standard and Datacenter (64 bit [EM64T])	Update: April 2017

Future updates or service packs on these operating systems are supported unless otherwise stated. The operating system version and updates must also be supported by the operating system provider.

Note:

• Support for Oracle Linux is based on Oracle documentation that Oracle Linux is compatible—both source and binary—with Red Hat Enterprise Linux.
• Support for the Oracle Exadata Database Machine is based on Oracle guidance that OEM software that supports both Oracle Linux and Oracle RAC is compatible with Oracle Exadata.
• A new option in Oracle 12c, called Multitenant Architecture, consisting of a container database that can hold many pluggable databases, is supported at the pluggable database level. ArcGIS supports the same functionality in pluggable databases as is supported for Oracle 11g R2. Esri is evaluating new Oracle 12c features that are appropriate for the ArcGIS platform and will add support for them based on suitability and customer demand.

Database requirements

Note:

• The Oracle Text component must be installed. The Text component is installed by default in Oracle; 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 ArcGIS 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 ArcGIS clients, but SQL access to this data is not supported.

Oracle database patch support

Oracle 11.2.0.4 and 12.1.0.2 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 installation instructions. Esri recommends making a full backup 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.

Software required to connect to a DBMS

Your client machine (for example, the one running ArcMap) will need to have the appropriate client files installed for the RDBMS you are using. These client files are available from their respective RDBMS vendors, but some are also available on My Esri as a convenience. RDBMS client files available from My Esri are IBM DB2 and Microsoft SQL Server. Client files for ALTIBASE, Dameng, IBM Informix, IBM Netezza, Oracle, SAP HANA, and Teradata are not available on My Esri and must be obtained from the RDBMS vendors. See Database clients for more information.

Note:

ArcGIS clients connecting to an Oracle 12.2.0.1 database must use Oracle 11.2.0.4 or newer client.