Registering an Oracle database with the server

As a server administrator, you have the option to register your data folders, databases, and geodatabases with ArcGIS Server. Data registration gives the server a list of locations that the server administrator has verified that the GIS server can access. Data registration also helps the GIS server understand how to adjust data paths when publishing across machines.

The following sections describe how to prepare your ArcGIS client to connect to an Oracle database (whether the database contains a geodatabase or not) and register the database with ArcGIS Server.

Installing the Oracle client software

Oracle client software must be installed on all ArcGIS client machines that will connect directly to the database. See Setting up a connection to Oracle for instructions on installation and configuration of the Oracle client software. Use the following table to determine the appropriate configuration for your site:

Installation combinations

Configuration to use

ArcGIS Server (single server site) and Oracle are installed on the same server; ArcGIS for Desktop is installed on a different machine.

Install a 32-bit Oracle client on the ArcGIS for Desktop machine, and make sure the PATH variable is set to the Oracle client home directory.

You do not need to install an Oracle client on the server because files to connect are installed with the Oracle DBMS. Just be sure the LD_LIBRARY_PATH (Linux server) or PATH (Windows server) system variable is set to the Oracle home directory.

If you set a tnsname for the Oracle client, you must use the same name on the ArcGIS Server machine and the ArcGIS for Desktop computer.

ArcGIS Server is installed on one or more servers that are separate from the DBMS. ArcGIS for Desktop is on a computer separate from both Oracle and ArcGIS Server.

You must install the 64-bit Oracle client on all ArcGIS Server machines and be sure the PATH (Windows) or LD_LIBRARY_PATH (Linux) system variable is set to the Oracle client home directory.

You must also install a 32-bit Oracle client on the ArcGIS for Desktop machine, and be sure the PATH variable is set to the Oracle client home directory.

If you set a tnsname for the Oracle client, you must use the same name on all of the servers in the ArcGIS Server site and the ArcGIS for Desktop computer.

ArcGIS Server and ArcGIS for Desktop are installed on the same server; Oracle is installed on a different server.

You must install both the 64-bit and 32-bit Oracle clients on the ArcGIS machine.

Set the PATH variable so that the 64-bit Oracle client home directory is listed first.

If your ArcGIS Server site includes additional servers, you must install the 64-bit Oracle client on each of the servers in the site, and set the PATH variable to the Oracle client home directory.

ArcGIS Server, ArcGIS for Desktop, and Oracle are all installed on one machine.

Install the 32-bit Oracle client so that ArcGIS for Desktop can connect to the database.

ArcGIS Server will use the 64-bit client files installed with the Oracle DBMS to connect.

Make sure that the 64-bit Oracle home directory is listed first in the PATH system variable.

If your ArcGIS Server site includes additional servers, you must install the 64-bit Oracle client on each of the servers in the site, and set the PATH variable to the Oracle client home directory.

If you will be registering the geodatabase as a managed database, the user with which you connect must have privileges sufficient to create data in the geodatabase. See User privileges for geodatabases in Oracle for more information.

Setting variables

There are variables you must set in the ArcGIS Server init_user_param.sh script to reference the Oracle client libraries when connecting from ArcGIS for Server (Linux). Which variables you set depends on the type of Oracle client you install and how you configure it.

See the "Reference the database client libraries in the init_user_param.sh script" section of Configuring a connection to a database in ArcGIS Server for more information.

Connecting to Oracle

To register a database with the server, you must provide connection information. There are two ways you can do this:

No matter which way you choose, you must provide the following information to connect directly to Oracle:

If you want to connect to a geodatabase in Oracle using an ArcSDE service, you must create a .sde file using the Create ArcSDE Connection File geoprocessing tool or a Python script. Then you must import the connection when you register the geodatabase with ArcGIS Server.

Granting privileges

The database user, role, or ArcGIS Server account (if you're using operating system authentication) with which you connect to the database must be granted privileges in the database to access the data to be published. The privileges and the circumstances under which you need to grant them are as follows:

Privilege

Reason

CREATE SESSION

Required to connect to the database.

CREATE TABLE

Selection sets of over 100 records cause a log file table to be created in the database by default. You can change log file settings to avoid having to grant this privilege. See Log file table configuration options for geodatabases in Oracle for more information.

SELECT privileges on the datasets to be published.

The user or ArcGIS account must have at least SELECT privileges on the datasets to be published.

See Granting and revoking privileges on datasets for instructions on granting privileges.

INSERT, UPDATE, and/or DELETE privileges on data published to editable feature services

To edit data through a feature service, privileges sufficient to edit must be granted on the datasets in the database.

See Granting and revoking privileges on datasets for instructions on granting privileges.

Registering the database with ArcGIS Server

You can register the database from Server Manager or the Catalog tree in ArcGIS for Desktop. See the following topics for an explanation of registration options and how to register the database:

9/1/2015