Create ArcGIS Enterprise Geodatabase in Oracle 11g R2

In this tutorial I am going to explain in short and easy way how to create an enterprise geodatabase in Oracle 11g R2 with ArcMap.

First we need to have Oracle 11g R2 installed (click here for how to install oracle 11g R2).

After having Oracle 11g R2 installed, we will open the "Create Enterprise Geodatabase" tool from ArcCatalog window from the following path:

Toolboxes --> Data Management Tools --> Geodatabase Administration --> Create Enterprise Geodatabase

The tool will appear as in the following image:

The options are explained as following:

1. Database Platform : is the type of the database we are using, which in our case is Oracle.
2. Instance : the address to the database we are using.
3. Database Administrator Password : is the password of the user "SYS".
4. Geodatabase Administrator Password : the password of the user who is going to administer the whole geodatabase.
5. Authorization File : browse to select the keycodes file that you get from you installation of ArcGIS for Server. (How to Make a "keycodes" File)".

After setting all options, press "OK" (step 7) to start the process of creating a new enterprise geodatabase in Oracle 11g R2.

The tool will check if the "SYS" user has enough privileges to create the enterprise geodatabase or not as shown in the folling picture:

After that wait till the process finishes and you get the following screen:

Congratulations, you have just created a new enterprise geodatabase in Oracle 11g R2.