Creating an enterprise geodatabase
The server administrator needs to create a new geodatabase in Oracle that can be used as the NIS.
When implementing ArcGIS for Maritime: Charting, it is recommended that the NIS be implemented as a separate geodatabase from the nautical product library and other geodatabases that support Esri products such as ArcGIS Data Reviewer 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, NIS). In Oracle 12c, multiple geodatabases can be implemented as separate pluggable databases in a single container database.
For more information, see Set up a geodatabase in Oracle.
Recommendations for geodatabases in Oracle
It is recommended that the following parameter values be used when creating a geodatabase in Oracle.
| Parameter name | Value |
|---|---|
Configure with Database Enterprise Manager | Enabled |
Automatic Memory Management | Enabled |
Database Components | Oracle Text |
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 | Set Default profile for data owner users |
RECYCLEBIN | Off |