English

ArcSDE 10 Service Pack 5

Summary

This Service Pack contains performance improvements, maintenance fixes, translation updates and includes all updates delivered since ArcGIS 10.0.

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

Installing this Service Pack

ArcSDE 10.0 Service Pack 5 can be installed on top of ArcSDE 10.0 or any ArcSDE 10.0 Service Pack. Service Pack 5 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     File Checksum
    AIX 64 sde10-sp5-db2-aix64.tar 21 MB E218AE20A9F90710BC570B3DB5548E8D
    Linux sde10-sp5-db2-lx.tar 17 MB B0D45CD2B47BF116DFFA8BD46CB36BF8
    Linux64 sde10-sp5-db2-lx64.tar 17 MB 8E7124587DABF7122B289E447FFCCB8A
    Solaris 64 sde10-sp5-db2-slrs64.tar 20 MB D4D6941CCF3EBDA78B78E71038CE852A
           
    Informix      
    AIX 64 sde10-sp5-inf-aix64.tar 21 MB F528828C2C091AF718E186049E454D1F
    Linux sde10-sp5-inf-lx.tar 17 MB E6F356115A0F59E12FD94B893E5D7121
    Linux 64 sde10-sp5-inf-lx64.tar 17 MB 3DCEAB62F0A30ECA5BFC73D21DE19821
    Solaris 64 sde10-sp5-inf-slrs64.tar 20 MB 5038032F5C9AB2069C22B2962593214B
           
    Oracle 10g      
    AIX 64 sde10-sp5-ora10g-aix64.tar 33 MB 13F7AD87DB59C746EE5A171BBA60FB19
    HP-UX Itanium 64 sde10-sp5-ora10g-hpia64.tar 48 MB 7515A44C5FE907868B675D011B7DC656
    Linux sde10-sp5-ora10g-lx.tar 23 MB F0FC96DDE490414D96CF6F3D416C6D2D
    Linux 64 sde10-sp5-ora10g-lx64.tar 24 MB 5B98111190692EB595CF80460B7FBE76
    Solaris 64 sde10-sp5-ora10g-slrs64.tar 28 MB B0FF4C55D8B5829C0932722B38B7153E
           
    Oracle 11g      
    AIX 64 sde10-sp5-ora11g-aix64.tar 32 MB 54CFB61246D92C37DE5BABDE14569A83
    HP-UX Itanium 64 sde10-sp5-ora11g-hpia64.tar 48 MB 844CC923D2BA6FBE40ACA65591DAE47A
    Linux sde10-sp5-ora11g-lx.tar 23 MB 85BBB621B2458FC8E8260C8088DDC752
    Linux 64 sde10-sp5-ora11g-lx64.tar 24 MB 58CEF94EB27006E563ED163DA64C664F
    Solaris 64 sde10-sp5-ora11g-slrs64.tar 28 MB 85BBB621B2458FC8E8260C8088DDC752
           
    PostgreSQL      
    Linux sde10-sp5-pg-lx.tar 27 MB E35CFF24B0F73BDC48DAB39B4E677CCA
    Linux 64 sde10-sp5-pg-lx64.tar 28 MB AA318F49EC827A57FC7B78551B51887B

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

    % sdemon -o shutdown

    NOTE (IBM 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-sp5-<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. If you have more than one ArcSDE Application Server, perform steps 2, 3, and 4 for each one.


ArcSDE Application Server Installation for Windows

ArcSDE 10.0 Service Pack 5 can be installed on top of ArcSDE 10.0 or any ArcSDE 10.0 Service Pack. Service Pack 5 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:



    File Checksum
    DB2 SDE10sp5-DB2.msp 11 MB E3C2EE0CD8DAF09E496A588BBA138428
    DB2 64 SDE10sp5-DB2-64.msp 12 MB FF5B4E6DEF1093662256E06121213C88
    DB2 z/OS SDE10sp5-DB2zOS.msp 11 MB C9E4776BFFCBE129C0F3B48E9DF3CCD2
    Informix SDE10sp5-Informix.msp 11 MB 2856A58BACA136F1A07155CB8AB5F305
    Informix 64 SDE10sp5-Informix-64.msp 12 MB 9AA7F8D59E047147A61226C4E45D6308
    Oracle 10g SDE10sp5-Oracle10g.msp 14 MB 2EA32CB8602CB132EA26634CD569EE31
    Oracle 10g 64 SDE10sp5-Oracle10g-64.msp 15 MB 5C5799E55D5E330DA73F821728A161ED
    Oracle 11g SDE10sp5-Oracle11g.msp 14 MB 89BC07A048AD6447AD9A76BB3FDCD061
    Oracle 11g 64 SDE10sp5-Oracle11g-64.msp 15 MB E353A4B1B63DCBFAB9D967F0264FFA77
    PostgreSQL SDE10sp5-PG.msp 16 MB 1EBD13A8A76D026A741D75A72C02F7D8
    SQL Server SDE10sp5-SqlServer.msp 11 MB 9F482E17A1B212558E68C1D801B4B1FC
    SQL Server 64 SDE10sp5-SqlServer-64.msp 12 MB 0E8321F0BE5BA3359A6B687FC057CE7E

  3. Double-click the SDE10sp5-<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]\SDE10sp5-<Database>.msp


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



  5. If you have more than one ArcSDE Application Server, perform steps 1, 3 and 4 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, 10.0 Service Pack 1, or 10.0 Service Pack 2, you must upgrade your geodatabase after applying Service Pack 5.

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

Oracle 10g
Oracle 11g
PostgreSQL

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)
    File Checksum
    Linux sde10-sp5-sdk-lx.tar 21 MB 90DA2978009E56F191EBF4B95E6294E7
           
    All Databases
    (64 bit Operating System)
         
    AIX 64 sde10-sp5-sdk-aix64.tar 28 MB 21405383A12F77213A3122EFDBB38695
    HP-UX Itanium 64 sde10-sp5-sdk-hpia64.tar 48 MB 12B8F49BAADF0519331392E29FDC5D3C
    Linux 64 sde10-sp5-sdk-lx64.tar 22 MB 71B77291385449E9A319171400734B4D
    Solaris 64 sde10-sp5-sdk-slrs64.tar 26 MB EBBEBFD1EB006360B51F9ED6B19DB893

  2. Extract the specified tar file by typing:

    % tar -xvf sde10-sp5-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:

    File Checksum
    ArcSDE SDK 64 SDE10sp5-CApiSDK-64.msp 14 MB EC894C563384866D8B70510929B20E23
    ArcSDE SDK SDE10sp5-CApiSDK.msp 15 MB B402D3A98C1AB1949733B18655FD8B7C
    ArcSDE Java SDK SDE10sp5-JavaSDK.msp 16 MB 0CB11ED9C3AAF9E09EE4B776315E8054
    ArcSDE Java SDK 64 SDE10sp5-JavaSDK-64.msp 15 MB CC84066EAC7D5CE0D8E388EA2D73EA23

  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:

    File Checksum
    sde10sp5-esri-win.zip
    11 MB
    DEF054BC4A287F81997B82EEA49DD50B

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

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

ArcGIS Server EGDB on Amazon EC2

If you would like to install 10.0 Service Pack 5 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.

August 21, 2012: Paragraph for ArcGIS Server on Amazon EC2 updated with new text.

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.