English

How To: Install a user-schema geodatabase into a remote Oracle database

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).

Procedure

When installing an ArcSDE geodatabase for Oracle, into either the master 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.

  1. 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
  2. Specify the remote Oracle service name, or TNS name in -p parameter, after the user password when executing the 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:

    -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 master 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.