HOW TO

Install a user-schema geodatabase into a remote Oracle database

Last Published: March 10, 2021

Summary

This article describes the steps on how to install a user-schema geodatabase into a remote Oracle database (an Oracle instance that resides on a remote server node).

Note:
ArcSDE software, including the application server, command tools, and SDK with C and Java APIs, was deprecated at ArcGIS 10.2.2 and is no longer distributed.

Procedure

When installing an ArcSDE geodatabase for Oracle, into either the primary ArcSDE schema or a user-schema, and the Oracle instance is located on a remote server from where the installation is being performed, the Oracle net service name (or TNS name) of the remote Oracle instance must be specified.

There are two ways to set the Oracle instance for a remote server.

  • Specify the remote Oracle instance service name or TNS name in the SDEHOME/etc/dbinit.sde file.
    • On Windows: set LOCAL= net_service_name
    • On Unix: set TWO_TASK= net_service_name
  • Specify the remote Oracle service name, or TNS name in -p parameter, after the user password when executing this sdesetup command:
sdesetup -o install -u username -p *****@net_service_name

The syntax to install user-schema geodatabase is by specifying the -i option in sdesetup command is:

-i service_name: user_schema_owner

For example:

sdesetup -o install -u mysde -p **** -i 5151:mysde -d oracle10g -N -q

When installing locally, the service name (or port number) must be the one used by the primary SDE geodatabase service. When installing remotely, the service name and port number pair must be a valid service/port entry for your system. On Windows, it must be a valid entry in the %WINDIR%\SYSTEM32\Drivers\etc\services file. On Unix, it must be a valid entry in the /etc/services file.

Article ID:000009817

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic