ArcSDE 10 Service Pack 4

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 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. 
   
   
4. 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
5. When the Setup installation wizard starts, follow the instructions on your screen to install ArcSDE 10 Service Pack 4.
6. 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)

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

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

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:

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:

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:
   
   

   User permissions for geodatabases in DB2

   User permissions for geodatabases in Informix

   User permissions for geodatabases in Oracle

   User permissions for geodatabases in PostgreSQL

   User permissions for geodatabases in SQL Server

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:
   
   

   Upgrading an ArcSDE geodatabase in DB2

   Upgrading an ArcSDE geodatabase for DB2 on z/OS

   Upgrading an ArcSDE 9.3 or later release geodatabase in Informix

   Upgrading an ArcSDE geodatabase in Oracle

   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.

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.

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.

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:

ArcGIS Server EGDB on Amazon EC2

How to identify which Service Pack is installed

Obtaining a DVD copy of the Service Pack

Service Pack Updates

Getting Help