How To: Manually install ArcSDE for Oracle on Windows
Instructions provided describe how to manually install ArcSDE for Oracle on Windows. These steps are not meant to take the place of the wizard, but are meant to offer an optional approach of installing ArcSDE. This article summarizes the procedure, so it is required that the user has read the ArcSDE install guide before attempting to perform the post installation manually.
Before proceeding, read this entire document, the ArcSDE installation guide, and the relevant sections from the ArcSDE documentation. For more information on these topics, please refer to the ArcGIS Desktop Help link in the Related Information section below.
Check the System Requirements Web site, as referred to in the Related Information section of this article, to verify a certified environment is present. Verify the version of ArcSDE is certified for the Oracle release and operating system to install to.
Verify that the Oracle instance has been configured to run ArcSDE. Refer to the ArcSDE Configuration and Tuning Guide (ArcSDE 8.2 - 9.1) or the ArcGIS Desktop or Server help (9.2 and higher) for details.
Create the 'SDE' user, with the required Oracle permissions as per the ArcSDE installation guide.
From the ArcSDE installation guide: ------------------- To set up your SDE user environment, you may modify and use the createsdeoracle.sql script to manually create the SDE user and tablespace. The createsdeoracle.sql script is located at %SDEHOME%\tools\oracle.
Verify that the public role has execute privileges on the dbms_pipe and dbms_lock packages. This is done as the Oracle SYS user:
Code: sqlplus sys/****** as sysdba grant execute on dbms_pipe to public; grant execute on dbms_lock to public;
Log in as a user with administrative privileges on the server. Close all applications on the computer. Insert the ArcSDE for the version of Oracle CD/DVD and follow the directions to install only the ArcSDE software. After the ArcSDE installation completes, the setup program provides the opportunity to begin the post installation setup. Exit without performing this step. This is done manually in the following steps.
The ArcSDE installer sets an environment variable SDEHOME to store the path to the ArcSDE software. It also adds %SDEHOME%\bin to the PATH variable, so ArcSDE commands can be executed from any location in the file system. Check that these variables are set correctly using:
Code: echo %sdehome% echo %path%
Modify one or more files: C:\WINNT\system32\drivers\etc\services or C:\windows\system32\drivers\etc\services - System file requires administrative access to change. Add a line defining the TCP/IP port number and the name to use for the ArcSDE application service. Add a line similar to the example below:
Code: esri_sde 5151/tcp
%SDEHOME%\etc\services.sde Enter the same line in this file that was entered for the \etc\services file.
Other configuration files in %SDEHOME%\etc to edit: dbinit.sde.
Set the variables that the application server uses. The syntax is:
Code: set <variablename>=<value>
Set the Oracle SID that ArcSDE connects to. For example, if the Oracle SID is ORCL:
Code: set ORACLE_SID=ORCL
'dbtune.sde' controls physical storage parameters for tables in the database. For further information, refer to the ArcSDE Configuration and Tuning Guide for Oracle (ArcSDE 8.2 - 9.1) or ArcGIS Desktop or Server help (ArcSDE 9.2 and higher).
Manually create the SDE repository.
Execute the %SDEHOME%\bin\sdesetup command at the DOS prompt. Refer to the 'sdesetup' command reference in the ArcSDE Administration Command Reference for information.
Note: Syntax for the 'sdesetup' command is different in versions prior to 9.2. See the previous installation guides to ensure that the correct syntax is used.
Provide the SDE user password and Oracle net service name to connect to Oracle as the SDE user and create the SDE repository.
The 'sdesetup' command: . creates the ArcSDE and geodatabase metadata tables. . creates ArcSDE stored procedures. . populates the LOCATORS and METADATA system tables with data from %SDEHOME%\geocode\templates.
The 'sdesetup' command must execute successfully or the ArcSDE service will not start and the geodatabase cannot be connected to.
Note: For Oracle 8i/9i, use the sdesetupora8i/sdesetupora9i commands.
In ArcSDE 8x versions only, verify there is an ArcSDE license manager to connect to.
Use the 'sdeservice' command to create the ArcSDE service. The command can be found in the ArcSDE Administration Command Reference, which is provided with ArcSDE.
Start the ArcSDE service from the Windows Services window or using the 'sdemon' command.
If the ArcSDE service fails to start, review the above steps, then refer to the FAQ found in the Related Information section below.