How To: Install a user-schema geodatabase into a remote Oracle database
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).
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.
Specify the remote Oracle instance service name or TNS name in the SDEHOME/etc/dbinit.sde file:
set LOCAL= net_service_name
set TWO_TASK= net_service_name
Specify the remote Oracle service name, or TNS name in -p parameter, after the user password when executing the sdesetup command: