ArcGIS supports connections to Oracle databases and enterprise geodatabases in Oracle.
Visit Esri Technical Support for information on the Esri Supported Environment Policy.
Supported database versions
Oracle 19c is the only version supported with the latest ArcGIS software. The following Oracle 19c patch version is the minimum certified and supported with ArcGIS. Newer Oracle updates on this version, including patches, are supported.
Standard 2 (SE2)/Enterprise (EE) Editions:
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 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)
When the ST_Geometry shape library is on Windows, you need the latest Microsoft Visual C++ Redistributable for Visual Studio 2015, 2017, 2019, and 2022 installed on the Oracle database machine. See the latest supported Visual C++ downloads from Microsoft support for more information.
Note:
Support for the Oracle Exadata Database Machine is based on Oracle guidance that original equipment manufacturer (OEM) software that supports both Oracle Linux and Oracle real application clusters (RAC) is compatible with Oracle Exadata.
Database requirements/limitations
In an Oracle multitenant architecture, you can create geodatabases in pluggable databases only.
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 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:
It is recommended that ArcGIS clients use the newest Oracle client supported for the Oracle database version to which you connect.