nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Enterprise Geodatabase in Oracle CDB & PDB - Best Practices and Recommendations

MMBR

📕 Documentation:

Geodatabases in Oracle—ArcGIS Pro | Documentation

Connect to Oracle from ArcGIS—ArcGIS Pro | Documentation

Multiple Geodatabases in Oracle—ArcGIS Pro | Documentation

🔍 Question: Is it possible to use Oracle 19c container database (CDB) with PDB (Pluggable Database) to manage the different production geodatabase in multi user & multi geodatabase version production environments? Does Esri recommended to use it?

🌍 Marcelo's Answer:

Yes, it is recommended to use Oracle Pluggable Databases to store the Oracle ArcSDE Geodatabase.

To enhance the process of consolidation, it is highly recommended to adopt the advanced capabilities offered by the Oracle 19c multi-tenant architecture. In this framework, the container database, commonly referred to as CDB, will serve as the central host for multiple pluggable databases, known as PDBs. Each of these pluggable databases operates independently, functioning as a standalone geodatabase that comes equipped with the necessary ArcSDE repository installed for optimal performance and management of spatial data. Furthermore, it is advisable to discontinue the use of Esri user-schema geodatabases, as shifting to this new architecture promises more efficient data management and scalability

Find more posts tagged with

Enterprise geodatabase

ArcSDE

Oracle

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.