English

ArcSDE 10 Service Pack 4

Summary

This Service Pack contains performance improvements and maintenance fixes. Please download and install this required Service Pack at your earliest convenience.

Description


Service Packs for ArcGIS client applications

First, apply the service pack to the ArcGIS client application from which you will upgrade your geodatabase. For client service packs, go to ArcGIS 10 (Desktop, Engine, Server) Service Pack 4. Follow the directions on that page for applying the client service pack.

Installing this Service Pack

ArcSDE 10.0 Service Pack 4 can be installed on top of ArcSDE 10.0 or any ArcSDE 10.0 Service Pack. Service Pack 4 is cumulative and contains the fixes from all previous ArcSDE 10.0 Service Packs and patches.

ArcSDE Application Server Installation for UNIX/Linux



Install the Service Pack for the ArcSDE Application Server

Now that you have installed the Service Packs for ArcGIS client applications, install this Service Pack using the account that owns the <ArcSDE Installation Directory>. Make sure that you have write access to the ArcSDE installation folder, the ArcSDE service is stopped, and no one is connected to the geodatabase. Then upgrade your geodatabase using your ArcSDE administrator account.

During installation, you can either save the original ArcSDE 10 files or overwrite them. It is recommended that you choose to save them; make sure you have enough disk space. The disk space requirements, for each platform, are displayed during the installation process.



  1. Download the appropriate tar file to a location other than $SDEHOME:

    DB2    
    IBM 64 sde10-sp4-db2-ibm64.tar
    21 MB
    Linux sde10-sp4-db2-lx.tar
    17 MB
    Linux64 sde10-sp4-db2-lx64.tar
    17 MB
    Solaris 64 sde10-sp4-db2-slrs64.tar
    20 MB
       
    Informix  
    IBM 64 sde10-sp4-inf-ibm64.tar
    21 MB
    Linux sde10-sp4-inf-lx.tar
    17 MB
    Linux 64 sde10-sp4-inf-lx64.tar
    17 MB
    Solaris 64 sde10-sp4-inf-slrs64.tar
    20 MB
       
    Oracle 10g  
    HP-UX Itanium 64 sde10-sp4-ora10g-hpia64.tar
    48 MB
    IBM 64 sde10-sp4-ora10g-ibm64.tar
    33 MB
    Linux sde10-sp4-ora10g-lx.tar
    23 MB
    Linux 64 sde10-sp4-ora10g-lx64.tar
    24 MB
    Solaris 64 sde10-sp4-ora10g-slrs64.tar
    28 MB
       
    Oracle 11g  
    HP-UX Itanium 64 sde10-sp4-ora11g-hpia64.tar
    48 MB
    IBM64 sde10-sp4-ora11g-ibm64.tar
    32 MB
    Linux sde10-sp4-ora11g-lx.tar
    23 MB
    Linux 64 sde10-sp4-ora11g-lx64.tar
    24 MB
    Solaris 64 sde10-sp4-ora11g-slrs64.tar
    28 MB
       
    PostgreSQL  
    Linux sde10-sp4-pg-lx.tar
    27 MB
    Linux 64 sde10-sp4-pg-lx64.tar
    28 MB

  2. Stop your current ArcSDE service, if one is running.

    % sdemon -o shutdown

    NOTE (AIX only): You must remove any inactive libraries that are loaded into memory before proceeding to the next step. Not doing so will result in an installation error. To remove them, as ROOT user, type:

    # /usr/sbin/slibclean

    (Optional) To list the libraries loaded into memory, as ROOT user, type:

    # /usr/sbin/genkld

    For further information on the slibclean and genkld commands please refer to your AIX system administrator documentation.

  3. Extract the specified tar file by typing:

    % tar -xvf sde10-sp4-<Database>-<Platform>.tar

  4. Start the installation with the applypatch command:

    % ./applypatch

    This starts the dialog for the menu-driven installation procedure. Default selections are noted in parentheses ( ). To quit the installation procedure, type 'q' at any time.

  5. This step only applies to Oracle users who have the ArcSDE Application Server and the DBMS installed on separate machines. All other users proceed to the next step.

    If you have the ArcSDE Application Server and Oracle installed on separate machines, there are two shared libraries used by EXTPROC that must be copied to the Oracle server for ArcSDE 10 Service Pack 4. Copy new versions of the files listed below to the Oracle server. Be sure the files copied are designed to run on the operating system of the Oracle server. See the ArcSDE for Oracle installation guide for instructions.

    Library Name OS-dependent file names
    st_shapelib st_shapelib.dll (Windows), libst_shapelib.so (Solaris, Linux, and HP-UX Itanium), libst_shapelib_64.so (IBM)
    st_raster libst_raster_ora.dll (Windows), libst_raster_ora.so (Solaris, Linux, and HP-UX Itanium), libst_raster_ora_64.so (IBM)


  6. This step only applies to PostgreSQL users. All other users proceed to the next step.

    If you have the ArcSDE Application Server and PostgreSQL installed on separate machines or a single machine, the following libraries must be copied to the PostgreSQL lib location. On Linux the location can vary depending on how PostgreSQL was installed. To determine the appropriate location for your installation, please use pg_config, and place the libraries in the location indicated by PKGLIBDIR.

    Library Name OS-dependent file names
    st_geometry st_geometry.so (Linux) st_geometry.dll (Windows)
    libst_raster_pg libst_raster_pg.so (Linux) libst_raster_pg.dll (Windows)

  7. If you have more than one ArcSDE Application Server, perform steps 2, 4, and 5 for each one.


ArcSDE Application Server Installation for Windows

ArcSDE 10.0 Service Pack 4 can be installed on top of ArcSDE 10.0 or any ArcSDE 10.0 Service Pack. Service Pack 4 is cumulative and contains the fixes from all previous ArcSDE 10.0 Service Packs and patches.


Install the Service Pack for the ArcSDE Application Server

Now that you have installed the Service Packs for ArcGIS client applications, install this Service Pack using a Windows administrator account and then upgrade your geodatabase using your ArcSDE administrator account. Also, make sure that you have write access to the ArcSDE installation folder, the ArcSDE service is stopped, and no one is connected to the geodatabase.


  1. Stop your current ArcSDE service, if one is running.

    sdemon -o shutdown


    NOTE: If you do not shut down the ArcSDE service before installing this Service Pack, you will be prompted and required to reboot your server machine to successfully complete the Service Pack installation. Stopping the ArcSDE service allows you to avoid rebooting the server machine.

  2. Download the appropriate file to a location other than the ArcSDE installation folder:



    DB2 SDE10sp4-DB2.msp 11 MB
    DB2 64 SDE10sp4-DB2-64.msp 12 MB
    DB2 z/OS SDE10sp4-DB2zOS.msp 11 MB
    Informix SDE10sp4-Informix.msp 11 MB
    Informix 64 SDE10sp4-Informix-64.msp 12 MB
    Oracle 10g SDE10sp4-Oracle10g.msp 14 MB
    Oracle 10g 64 SDE10sp4-Oracle10g-64.msp 15 MB
    Oracle 11g SDE10sp4-Oracle11g.msp 14 MB
    Oracle 11g 64 SDE10sp4-Oracle11g-64.msp 15 MB
    PostgreSQL SDE10sp4-PG.msp 16 MB
    SQL Server SDE10sp4-SqlServer.msp 11 MB
    SQL Server 64 SDE10sp4-SqlServer-64.msp 12 MB

  3. Double-click the SDE10sp4-<Database>.msp to start the install process.

    NOTE: If double clicking the MSP file does not start the Service Pack installation, you can run the Service Pack manually by using the following command:

    c:\msiexec.exe /p [location of service pack]\SDE10sp4-<Database>.msp


  4. When the Setup installation wizard starts, follow the instructions on your screen to install ArcSDE 10 Service Pack 4.


  5. This step only applies to Oracle users who have the ArcSDE Application Server and the DBMS installed on separate machine. All other users proceed to the next step.

    If you have the ArcSDE Application Server and Oracle installed on separate machines, there are two shared libraries used by EXTPROC that must be copied to the Oracle server for ArcSDE 10 Service Pack4. Copy new versions of the files listed below to the Oracle server. Be sure the files copied are designed to run on the operating system of the Oracle server. See the ArcSDE for Oracle installation guide for instructions.

    Library Name OS-dependent file names
    st_shapelib st_shapelib.dll (Windows), libst_shapelib.so (Solaris, Linux, and HP-UX Itanium), libst_shapelib_64.so (IBM)
    st_raster libst_raster_ora.dll (Windows), libst_raster_ora.so (Solaris, Linux, and HP-UX Itanium), libst_raster_ora_64.so (IBM)


  6. This step only applies to PostgreSQL users. All other users proceed to the next step.

    If you have the ArcSDE Application Server and PostgreSQL installed on separate machines or a single machine, the following libraries must be copied to the PostgreSQL lib location. On Windows the default location is: C:\Program Files\PostgreSQL\8.3\lib.

    Library Name OS-dependent file names
    st_geometry st_geometry.so (Linux) st_geometry.dll (Windows)
    libst_raster_pg libst_raster_pg.so (Linux) libst_raster_pg.dll (Windows)

  7. If you have more than one ArcSDE Application Server, perform steps 1, 3, and 5 for each one.

Upgrade the geodatabase (UNIX/Linux and Windows)

Your last step is to upgrade the geodatabase, if required.

If you are upgrading from 10 final or 10.0 Service Pack 1, you must upgrade your geodatabase after applying Service Pack 4.

If you are upgrading from 10.0 Service Pack 2, you must upgrade geodatabases in the following database management systems after applying Service Pack 4:

IBM DB2
Informix
Oracle 10g
Oracle 11g
SQL Server

If you are upgrading from 10.0 Service Pack 3, you must upgrade geodatabases in the following database management systems after applying Service Pack 4:

Oracle 10g
Oracle 11g

It is strongly recommended that you back up your database, including all ArcSDE geodatabase system tables, stored procedures, functions, and user data before upgrading your geodatabase.

  1. Specific database privileges must be granted to the ArcSDE administrator before upgrading the geodatabase. See the topic specific to your DBMS for a list of privileges required to upgrade a geodatabase:


  2. (Oracle only) If execute privileges on any of these packages were revoked from public, regrant them to the public role:

    DBMS_LOB
    DBMS_UTILITY
    DBMS_SQL
    UTL_RAW
    DBMS_PIPE
    DBMS_LOCK

  3. Log in to the ArcGIS client to which you applied the service pack and from which you will upgrade your geodatabase.


  4. To upgrade, run the Upgrade Geodatabase geoprocessing tool or a Python script. See the topic appropriate to your DBMS for instructions:

    NOTE: If you have user-schema geodatabases in Oracle, upgrade the sde master geodatabase first, then upgrade the user-schema geodatabases.

    Upgrading an ArcSDE geodatabase in PostgreSQL

    Upgrading an ArcSDE geodatabase in SQL Server



  5. (Oracle only) After the upgrade completes, you may revoke the following permissions from the ArcSDE administrator account:

    ADMINISTER DATABASE TRIGGER
    ALTER ANY INDEX
    CREATE ANY INDEX
    CREATE ANY TRIGGER
    CREATE ANY VIEW
    CREATE INDEXTYPE
    CREATE LIBRARY
    CREATE OPERATOR
    CREATE PUBLIC SYNONYM
    CREATE TYPE
    DROP ANY INDEX
    DROP ANY VIEW
    DROP PUBLIC SYNONYM
    SELECT ANY TABLE

  6. As the ArcSDE administrator user, run the following command to restart the ArcSDE service, if you are using one:

    sdemon -o start

    Or, on Windows servers, start the service from the Windows Services menu while logged in as a Windows Administrator.

  7. If you have more than one ArcSDE geodatabase, perform the upgrade steps for each geodatabase.

ArcSDE SDK Installation for UNIX/Linux


Installation Steps:


  1. Download the appropriate tar file to a location other than the ArcSDE SDK installation location:

    All Databases (32 bit Operating System)  
    Linux sde10-sp4-sdk-lx.tar
    21 MB
       
    All Databases (64 bit Operating System)  
    HP-UX Itanium 64 sde10-sp4-sdk-hpia64.tar
    48 MB
    IBM64 sde10-sp4-sdk-ibm64.tar
    28 MB
    Linux 64 sde10-sp4-sdk-lx64.tar
    22 MB
    Solaris 64 sde10-sp4-sdk-slrs64.tar
    27 MB

  2. Extract the specified tar file by typing:

    % tar -xvf sde10-sp4-sdk-<Platform>.tar

  3. Start the installation with the applypatch command:

    % ./applypatch

    This starts the dialog for the menu-driven installation procedure. Default selections are noted in parentheses ( ). To quit the installation procedure, type 'q' at any time.

ArcSDE SDK Installation for Windows


Installation Steps:


  1. Make sure you have write access to the ArcSDE SDK installation folder.


  2. Download the appropriate files to a location other than the ArcSDE SDK installation folder:

    ArcSDE SDK 64 SDE10sp4-CApiSDK-64.msp
    15 MB
    ArcSDE SDK SDE10sp4-CApiSDK.msp
    15 MB
    ArcSDE Java SDK SDE10sp4-JavaSDK.msp
    16 MB
    ArcSDE Java SDK 64 SDE10sp4-JavaSDK-64.msp
    16 MB

  3. Double-click the appropriate executable to start the install process.


  4. When Setup starts, follow the instructions on your screen.

ArcInfo Workstation

If you connect to ArcSDE 10.0 using ArcInfo Workstation 10.0, please follow the steps below to install this Service Pack to your ArcInfo Workstation 10.0 software installation location:

Windows

  1. Before you start, make sure you have write access to the installation folder, then download the zip file to that location:


  2. Use WinZip to extract the new files from sde10-sp4-esri-win.zip to the appropriate installation folder, see list below:

    ArcGIS Workstation - <installation-folder>\arcexe10\bin

ArcGIS Server EGDB on Amazon EC2

New ArcGIS Server on Amazon EC2 AMIs (Amazon Machine Images) that include 10.0 SP4 are available to existing ArcGIS Server on Amazon EC2 customers. If you would like to install 10.0 Service Pack 4 on your existing AMIs, see the ArcGIS Server on Amazon EC2 help topic Applying service packs and patches on Amazon EC2 for more information.



How to identify which Service Pack is installed

Windows

To determine which ArcGIS products are installed, download the PatchFinder utility and run it from your local machine.

UNIX/Linux

To determine which ArcGIS products are installed, download and extract the PatchFinder utility and run it from your local machine.

Obtaining a DVD copy of the Service Pack

A DVD of this Service Pack is available for users who experience difficulties downloading the Service Pack from the web site. Simply fill out the Request a Service Pack DVD order form. Sites outside of the United States, please contact your local ESRI software distributor.


Service Pack Updates

Check the ArcGIS Resource Center periodically for the availability of additional Service Packs. New information about this Service Pack will be posted here.

April 19, 2012: Upgrade the geodatabase (UNIX/Linux and Windows) section has been updated to provide additional information.

Getting Help

If you are in the United States, please contact Esri Technical Support at 1-888-377-4575, if you have any difficulty installing this Service Pack. Sites outside of the United States, please contact your local Esri software distributor.