ArcGIS Pro and ArcGIS Enterprise on Microsoft Windows and Linux support connections to Oracle databases and enterprise geodatabases in Oracle.
Tip:
For ArcGIS versions prior to 10.9 and 2.8, see the system requirements on the ArcGIS Desktop website.
Visit Esri Technical Support for information on the Esri Supported Environment Policy.
Supported database versions
The following Oracle releases are the minimum certified patched versions supported with ArcGIS. Newer Oracle patches on these versions, including patch set levels and Interim (One-Off) Patches, are supported.
Standard 2 (SE2)/Enterprise (EE) Editions:
Oracle 12c R1 (64 bit) 12.1.0.2
Oracle 12c R2 (64 bit) 12.2.0.1
Oracle 18c (64 bit) 18.3.0.0, 18.4.0.0
Oracle 19c (64 bit) 19.3.0.0
Supported operating systems
If your database management system is installed where ArcGIS products are installed, the operating system must meet the ArcGIS product system requirements as well as the operating system requirements for your Oracle version.
If your database is not installed on the same server as an ArcGIS product, see the Oracle documentation for operating system requirements for your Oracle version.
Additional requirements for the ST_Geometry shape library
Esri supports the following four operating systems when you use the ST_Geometry shape library and configure Oracle external procedure (extproc).
- IBM AIX (64 bit)
- Linux (64 bit)
- Solaris (64 bit)
- Microsoft Windows (64 bit)
On Windows, you need the latest Microsoft Visual C++ Redistributable for Visual Studio 2015, 2017, and 2019 installed on the Oracle database machine. See the latest supported Visual C++ downloads from Microsoft support for more information.
- Support for Oracle Linux is based on Oracle documentation that Oracle Linux is compatible—both source and binary—with Red Hat Enterprise Linux Server.
- 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 starting with 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.
Database requirements/limitations
Branch versioning is supported at Oracle 12.1.0.2 and later releases; however, branch versioning is not supported in user-schema geodatabases.
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.
Oracle database patch support
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 patches. 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.
Cloud support
See Requirements for using ArcGIS with databases in the cloud for information on support for database services and databases deployed in the cloud.
Software required to connect to a DBMS
Your client machine (for example, the one running ArcGIS Pro, ArcMap, or ArcGIS Server) must have the appropriate database client files installed for the RDBMS you are using. These client files are available from their respective RDBMS vendors. See Database clients for more information.
Note:
ArcGIS clients connecting to Oracle must use an Oracle 12c or newer client.