Mapping and Charting Enterprise Databases

Now available the entire Docker RDBMS Enterprise Geodatabase Series, including PostgreSQL, SQL Server, and Oracle, on my community.esri.com blog channel.

Running a Linux Docker container with the Enterprise Enterprise Geodatabase is an effective way to manage spatial data environments. This setup allows for enhanced functionality and optimized performance in geographic information systems (GIS) applications.

Exporting a geodatabase using the Oracle 12c R2 Data Pump utility returns ORA errors (39127, 01422, 06512) due to multiple ST_DOMAIN_METHODS references in the SYS.OBJ$ table.

The limit on database object name size is the smaller of either the limit enforced by the database management system or the geodatabase limit. Limits vary from one database management system to the next. The types of characters allowed in object names vary by database management system but are also affected by how ArcGIS stores and queries the object information.

It is essential to ensure that your Cloud PostgreSQL instances and PostGIS extension are patched with the latest updates to maintain optimal performance and security.

Which are the release plans for Oracle 23ai (23c) Support for ArcGIS Enterprise?

• Oracle has not released Oracle 23ai On-Premises for Linux and Windows yet. 
• On Nov/01/2024 Oracle has postponed again the release, this time to 2025.
• Esri will certify and support Oracle 23ai with ArcGIS Pro and ArcGIS Enterprise in a future ArcGIS release after Oracle releases the Oracle 23ai On-Premises for Windows and Linux.

You do not have to keep your geodatabase and ArcGIS clients at the same release, but it is recommended that you do so. 

The Rebuild Network Topology tool was introduced with ArcGIS Pro 3.3 for utility network users and was also exposed as the Rebuild current extent option on the Validate dropdown. This tool and command provide the ability to rebuild the network topology in the current extent of an active map.  This Add-In enables users who remain on ArcGIS Pro 2.9 and 3.1 to benefit from this functionality.

Workflows have been identified that can cause inconsistencies in the branch versioning system tables. When such an issue is encountered, features with missing branch versioning metadata can cause data inconsistencies when the version is reconciled, posted, and/or deleted.

ArcSDE User-Schema Geodatabases in Oracle are deprecated