Enabling enterprise geodatabase functionality in an existing database

You can connect from ArcGIS for Desktop to an existing, supported database and enable geodatabase functionality in it. This adds the geodatabase system tables, stored procedures, and functions needed to use geodatabase behavior.

You must use the Enable Enterprise Geodatabase tool described in this topic to create a geodatabase in a DB2 or Informix database. You can also use the Enable Enterprise Geodatabase tool to create a geodatabase in an existing Oracle, PostgreSQL, or Microsoft SQL Server database. You might do this if your database administrator wants to create and configure the database and geodatabase administrator manually; you can then run the Enable Enterprise Geodatabase to create a geodatabase in the preconfigured database.

The following steps describe enabling a geodatabase from a database connection in ArcGIS for Desktop.

Steps:

1. Using DBMS tools or SQL, the database administrator must do the following:
   1. Create a database.
   2. Create a geodatabase administrator user.

      See the topic appropriate to your database to determine what user qualifies as a geodatabase administrator for your database type:

      The geodatabase administrator in DB2The geodatabase administrator in InformixThe geodatabase administrator in OracleThe geodatabase administrator in PostgreSQLThe geodatabase administrator in SQL Server

   3. Grant the geodatabase administrator the privileges required to create a geodatabase.

      Required privileges differ depending on the type of database you are using. See the topic appropriate to your database:

      User privileges for geodatabases in DB2User privileges for geodatabases in InformixUser privileges for geodatabases in OracleUser privileges for geodatabases in PostgreSQLUser privileges for geodatabases in SQL Server

   4. If you will be enabling a geodatabase in a PostgreSQL or SQL Server database, the geodatabase administrator user must own a schema with the same name as the user name. Create that schema and grant the geodatabase administrator authority on it.
The geodatabase administrator completes the following steps:
2. Start ArcCatalog or ArcMap and open the Catalog window.
3. Create a database connection in the Catalog tree, connecting as the geodatabase administrator.

   If connecting as a database-authenticated user, be sure to save the user name and password on the Database Connection dialog box.

4. Right-click the database connection and click Enable Geodatabase.

   This opens the Enable Enterprise Geodatabase geoprocessing tool. The Input Database Connection is automatically populated with the database connection.

5. To authorize the geodatabase, browse to the ArcGIS for Server keycodes file that was created on your server when you authorized ArcGIS for Server Enterprise.

   This file is in the \\Program Files\ESRI\License<release#>\sysgen folder on Windows and /arcgis/server/framework/runtime/.wine/drive_c/Program Files/ESRI/License<release#>/sysgen directory on Linux. If you have not already done so, authorize ArcGIS for Server to create this file.

6. Click OK to run the tool.

A geodatabase is added to the database.

A log file (GDBCreateGeodatabase<#>.log) is created in the directory specified by the %TEMP% variable on the computer where the tool is run. If you have any problems running the tool, check this log file to troubleshoot the problem.