Copyright: Copyright (c) 1999-2001 ESRI


This help file provides context-sensitive help for the Setup program for installing ArcSDE.

The topics in this help file can only be accessed via the context-sensitive help controls in the Setup program.


Installation type

Select the installation type for your installation needs.

•	Install ArcSDE for Oracle9i - Select this option to install the ArcSDE software on your computer. This option allows you to define the license manager by installing the license manager or selecting an existing license manager on the network. The post installation options are also provided.

•	Install License Manager - Select this option to install only the license manager on your computer. If a license manager exists on your network with ArcSDE keycodes, it is not necessary to install one on your machine.


License manager

ArcSDE requires a license manager.  You can install the license manager locally during the installation or use an existing license manager on your network.  A network license manager can be running on Microsoft Windows or UNIX.  If you choose a license manager on your network, it must contain an ArcSDE feature (keycode).  Refer to the License Manager Reference Guide, LicenseManagerGuide.html in the documentation folder of the CD.

Choose the license manager installation type for your needs.

•	Install the License Manager - Select this option to start the license manager installation.  The license manager installation requires a reboot, the ArcSDE setup will continue after the reboot.

•	Browse for a License Manager on the Network - Select this option to use an operational license manager on the network.

•	Setup the License Manager later - Select this option to proceed with the ArcSDE installation. You may install ArcSDE without defining a license manager.  However, the ArcSDE service will not start until a license manager has been defined.  You can define a license manager after installation through the post installation setup.

When you purchase floating software products from ESRI, you will receive a license file (keycode) from customer service to use when installing the license manager. This file contains the licenses (keycodes) for the software products you have purchased to unlock the software.


Post installation

Select the post installation option for your installation needs

Complete - This option will create the SDE user and tablespace, set up the SDE repository, authorize ArcSDE and create the ArcSDE service.  All of these steps must be completed before the ArcSDE service will start.  Choose this option if you are upgrading your ArcSDE tablespace or would like the setup to guide you through these steps.

Custom - Choose this option to select from the available post installation options. This option is recommended for advanced users.

If you are performing an upgrade of an existing ArcSDE tablespace, you will have to grant additional permissions to the SDE user in Oracle for the upgrade to be successful.  Please refer to the upgrading ArcSDE topic in the ArcSDE for Oracle9i Install Guide for details.


Custom installation

Select from the following post installation options

Define SDE User Environment - This option connects to Oracle as the sys user to create the SDE tablespace, SDE user, and grant the required privileges to the SDE user to manage the SDE meta tables.

Selecting this option will:

-	Create the SDE user's default tablespace

-	Create the SDE user, if it does not already exist

-	Grant the SDE user specific privileges outlined in the install guide

-	Grant execute on DBMS_PIPE and DBMS_LOCK to public

The SDE user environment can be set up manually. Please see the ArcSDE for Oracle9i Install Guide for information on manually setting up the SDE user environment.

If you have manually performed these tasks, or if you are performing an upgrade to an existing ArcSDE tablespace, you do not need to define the SDE user environment. Please refer to the ArcSDE for Oracle9i Install Guide for further information.

Repository Setup - This option connects to Oracle as the SDE user to set up the repository. In order to set up the repository, the SDE user and tablespace must already exist.

If you are performing an upgrade to your existing ArcSDE tablespace this step is required.

The repository can be set up manually. Please see the ArcSDE for Oracle9i Install Guide for information on manually setting up the repository.

Authorize ArcSDE - ArcSDE requires an authorization file for use. Each machine installing ArcSDE  will require an authorization file. This post installation option can be used to obtain an authorization file and register ArcSDE for use. This post installation option can also be used to register ArcSDE for use using the authorization file you received from Customer Service.

For additional information on obtaining an authorization file, see the Install Guide.

To re-configure your machine with an updated authorization file, run through this post installation option again. To launch the post installation setup at a later time, go to Start > Programs > ArcGIS > ArcSDE > ArcSDE for oracle9i Post Installation.

Create ArcSDE Service - This option creates and starts the ArcSDE service by connecting to Oracle as the SDE user.  Before selecting this option, make sure the SDE user, tablespace and repository exist, and ArcSDE has been authorized for use.

The service can be manually created and started.  Please see the ArcSDE for Oracle9i Install Guide for information on manually creating/starting the ArcSDE service.


User information

Provide the Oracle sys user name and password to connect to Oracle and create the SDE tablespace, SDE user and grant privileges.  The net service name is also required to determine the Oracle instance to which you will be connecting. Contact your database administrator if you do not have this user information.   In some cases, your database administrator may want to manually create the SDE user environment. Sample scripts are provided in the ArcSDE for Oracle9i Install Guide for this purpose.


SDE user and tablespace information

Enter a password for the SDE user. This can be any password of your choice. You can optionally name the tablespace and datafile, or accept the defaults provided. Once this information has been provided the SDE tablespace and user will be created, and the SDE user will be granted the required privileges.

ArcSDE 9.0 requires an SDE tablespace of at least 200MB in size. If an ArcSDE tablespace already exists, the post installation wizard will detect it and increase its size to a minimum of 200MB.  If the tablespace is 200MB or larger, the tablespace size is not changed.


ArcSDE configuration files

ArcSDE services use several configuration files that reside in %SDEHOME%\etc.  In the ArcSDE post installation setup you can define custom configuration files if you have them or use the default files.

Giomgr.def - Contains a number of parameters that control the behavior of the ArcSDE service (For example, maximum number of connections).  Generally, the default values for the file are acceptable.  Changing the values in this file is recommended for advanced users only.

Dbinit.sde - Used to set environment variables for the service.

Dbtune.sde - Allows the database administrator to control physical storage of data in the database.  Also allows you to define the default geometry storage for the spatial data. Part of the repository setup takes the values from this file and loads them into a table called dbtune. See the ArcSDE for Oracle Configuration and Tuning Guide, config_tuning_guide_oracle.pdf, for more details on the dbtune.sde file.


Connect to create SDE repository

Provide your SDE user password and Oracle net service name to connect to Oracle as the SDE user and create the SDE repository.

The repository setup is a crucial step in the post installation setup.  The repository contains all the ArcSDE metadata for administering the ArcSDE database.  Please refer to the sdesetupora9i command reference in the ArcSDE Developer Help for specifics on what is occurring with this operation.

If you are performing an upgrade of an existing ArcSDE tablespace you will have to grant additional permissions to the SDE user in Oracle in order for the upgrade to take place successfully.  Please refer to the upgrading ArcSDE topic of the ArcSDE for Oracle9i Install Guide for details.


Authorize ArcSDE

ArcSDE requires an authorization file for use. Each machine installing ArcSDE will require an authorization file.

This post installation option can be used to obtain an authorization file and register ArcSDE for use. This post installation option can also be used to register ArcSDE for use using the authorization file you received from Customer Service.

For additional information on obtaining an authorization file, see the Install Guide.


ArcSDE service information

This information is required to create a service for ArcSDE.  You must enter a unique service name and TCP/IP service port number. Provide the SDE user password that you used for your SDE user.  The ORACLE SID and Server name are required. Your Oracle_SID is the Oracle System Identifier, the unique name for your Oracle instance. The server name is required to determine the server to which you will be connecting, by default your machine name is provided.

The ArcSDE service will be added to the system service file.