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.
Configure with Database Enterprise Manager
Automatic Memory Management
ALTER PROFILE "DEFAULT" LIMIT IDLE_TIME 60
Set Default profile for data owner users