Direct connections from ArcSDE commands to a geodatabase in Oracle
Administration commands are used primarily by the ArcSDE administrator user to monitor and alter the ArcSDE geodatabase. You can read the command reference provided with the ArcSDE component of ArcGIS Server at the Enterprise level for complete information on using these commands.
When these commands make connections to the geodatabase, they use the options –s for the server name, –i for the service or direct connection string, –u for the connecting user's name, and –p for the user's password (if using database authentication).
If you are connecting to a local ArcSDE geodatabase (one that is on the same machine as the client), you do not need to specify the –s option; it is assumed to be the local server. For connections to remote geodatabases, provide the name of the server with the –s option.
The –i option corresponds to the Service field on the Spatial Database Connection Properties dialog box in ArcCatalog; you provide either the ArcSDE service port or name or the direct connection syntax string for your database with this option. Therefore, what you type with the –i option varies based on the type of authentication you use and where and what version the Oracle DBMS is.
In the connection string syntax, you must provide information in place of the following variables:
- Replace <rel> with either 10g or 11g depending on which release of the Oracle client you are using to connect to the database.
- Replace <SQL_Net_alias> with the SQL Net alias that was set when your Oracle client was configured to connect to the database.
- Replace <schema_name> with the schema name of the geodatabase owner. This is used only with user-schema geodatabases.
|
Type of authentication |
Connection string |
|---|---|
|
Direct connections to the master geodatabase |
–i sde:oracle<rel>:<SQL_Net_alias> |
|
Direct connections to a user-schema geodatabase |
–i sde:oracle<rel>:<SQL_Net_alias>:<schema_name> |
For the –u option, you should include the database user name if using database authentication. If using operating system authentication, do not supply a –u or –p option.