Creating an enterprise geodatabase
The server administrator needs to create a new geodatabase en Oracle that can be used as the NIS.
When implementing ArcGIS Maritime, it is recommended that the nautical product library be implemented as a separate geodatabase from the NIS and other geodatabases that support Esri products such as ArcGIS Data Reviewer Desktop or ArcGIS Workflow Manager. In Oracle 11g, multiple geodatabases can be implemented in a single Oracle instance using user-schema geodatabases. In this case, you will set up a master geodatabase under the sde schema and additional user-schema geodatabases in their own schemas (that is, prodlib). In Oracle 12c, multiple geodatabases can be implemented as separate pluggable databases in a single container database.
For more information, see Create a geodatabase in Oracle.
Recommendations for geodatabases in Oracle
Se recomienda utilizar los siguientes valores de parámetros al crear una geodatabase en Oracle.
| Nombre del parámetro | Valor |
|---|---|
Configurar con Database Enterprise Manager | Habilitado |
Administración de memoria automática | Habilitado |
Componentes de la base de datos | Texto de Oracle |
OPEN_CURSORS | 10000 |
SESSION_CACHED_CURSORS | 50-150 |
DEFERRED_SEGMENT_CREATION | False |
RESOURCE_LIMIT | True |
ALTER PROFILE "DEFAULT" LIMIT IDLE_TIME 60 PASSWORD_LIFE_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED | Establecer el perfil predeterminado para usuarios propietarios de datos |
RECYCLEBIN | Desactivado |