English

ArcSDE 10 Service Pack 3

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 3. Follow the directions on that page for applying the client service pack.

Installing this Service Pack

ArcSDE 10.0 Service Pack 3 can be installed on top of ArcSDE 10.0, ArcSDE 10.0 Service Pack 1, or ArcSDE 10.0 Service Pack 2. Service Pack 3 is cumulative and contains the fixes from all previous 10.0 Service Packs and patches, therefore if you have a previous version 10.0 patch/service pack installed, simply apply Service Pack 3 over it to update the required files.

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:


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

  3. Stop your current ArcSDE service, if one is running.
  4. % 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.

  5. Extract the specified tar file by typing:
  6. % tar -xvf sde10-sp3-<Database>-<Platform>.tar

  7. Start the installation with the applypatch command:
  8. % ./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.

  9. 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 3. 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)

  10. This step only applies to PostgreSQL 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 PostgreSQL installed on separate machines, the following libraries must be copied to the PostgreSQL lib location. On windows the default location is: C:\Program Files\PostgreSQL\8.3\lib. 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. See the ArcSDE for PostgreSQL installation guide for instructions.

    Library Name OS-dependent file names
    st_geometry st_geometry (Linux and Windows)
    st_raster st_raster (Linux and Windows)

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


  12. Start your ArcSDE service.
  13. % sdemon -o start



ArcSDE Application Server Installation for Windows

ArcSDE 10.0 Service Pack 3 can be installed on top of ArcSDE 10.0, ArcSDE 10.0 Service Pack 1, or ArcSDE 10.0 Service Pack 2. Service Pack 3 is cumulative and contains the fixes from all previous 10.0 Service Packs and patches, therefore if you have a previous version 10.0 patch/service pack installed, simply apply Service Pack 3 over it to update the required files.


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:


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

  4. Double-click the SDE10sp3-<Database>.msp to start the install process.


  5. 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]\SDE10sp3-<Database>.msp
  6. When the Setup installation wizard starts, follow the instructions on your screen to install ArcSDE 10 Service Pack 3.


  7. 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 3. 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)

  8. This step only applies to PostgreSQL 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 PostgreSQL installed on separate machines, the following libraries must be copied to the PostgreSQL lib location. On windows the default location is: C:\Program Files\PostgreSQL\8.3\lib. 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. See the ArcSDE for PostgreSQL installation guide for instructions.

    Library Name OS-dependent file names
    st_geometry st_geometry (Linux and Windows)
    st_raster st_raster (Linux and Windows)

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


  10. Start your ArcSDE service.
  11. % sdemon -o start

Upgrade the geodatabase (UNIX/Linux and Windows)

Your last step is to upgrade the geodatabase, if required. If you are upgrading from 10.0 Service Pack 2, you must upgrade geodatabases in the following database management systems after applying Service Pack 3:

    IBM DB2
    Informix
    Oracle 10g
    Oracle 11g
    PostgreSQL

If you are upgrading from 10.0 or 10.0 Service Pack 1, geodatabases in other database management systems may also need to be upgraded after applying Service Pack 3. Please connect to your geodatabase in ArcCatalog and view the Properties of your geodatabase. If the “Upgrade Status” on the General tab indicates that the geodatabase needs upgrading the “Upgrade Geodatabase” option will be active. The “Upgrade Geodatabase” option will be inactive if the geodatabase does not need to be upgraded.

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_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:




  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:
  7. sdemon -o start

    Or, as a Windows Administrator, start the service from the Windows Services menu.

  8. 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-sp3-sdk-lx.tar
    21 MB
       
    All Databases (64 bit Operating System)  
    HP-UX Itanium 64 sde10-sp3-sdk-hpia64.tar
    48 MB
    IBM64 sde10-sp3-sdk-ibm64.tar
    28 MB
    Linux 64 sde10-sp3-sdk-lx64.tar
    22 MB
    Solaris 64 sde10-sp3-sdk-slrs64.tar
    27 MB

  2. Extract the specified tar file by typing:
  3. % tar -xvf sde10-sp3-sdk-<Platform>.tar

  4. Start the installation with the applypatch command:
  5. % ./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:


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

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


  5. 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:

      sde10sp3-esri-win.zip
      12 MB

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

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

ArcGIS Server EGDB on Amazon EC2

New Enterprise Geodatabase (EGDB) Amazon Machine Images (AMIs) that include 10.0 Service Pack 3 are available to existing ArcGIS Server on Amazon EC2 customers. See the ArcGIS Server on Amazon EC2 help topic Applying service packs to an existing EGDB Amazon EC2 instance 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.

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.