Patches and updates

ArcSDE 10 Service Pack 2

Published: April 28, 2011

Resumen

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

Descripción

ArcSDE 10 or ArcSDE 10 Service Pack 1 must be installed before you can install ArcSDE 10 Service Pack 2. If you have a hot fix installed on top of ArcSDE 10, check your hot fix instructions to be sure it does not conflict with Service Pack 2. If it does not, you can install ArcSDE 10 Service Pack 2 over it to update the required files.

It is strongly recommended that you back up your database including all ArcSDE system tables and user layer data before upgrading your ArcSDE installation.

ArcGIS Server on Amazon EC2 users:

New ArcGIS Server on Amazon EC2 AMIs (Amazon Machine Images) that include 10.0 SP2 are available to existing ArcGIS Server on Amazon EC2 customers.

Please Note: If you choose to apply the service packs to your existing 10.0 or 10.0 SP1 instances, please do not install ArcGIS License Manager SP2 due to a known problem when authorizing the ArcGIS License Manager on cloud platforms. Please see Technical Article 38948 for more information about the ArcGIS License Manager.

ArcSDE Server Installation for UNIX

Installation Steps:

During installation, you can either save the original ArcSDE 10 files or overwrite them. If 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.

Install this Service Pack using an administrator account, and then upgrade your geodatabase using your ArcSDE administrator account.

Copy the appropriate tar file to a location other than $SDEHOME:

DB2
IBM 64	sde10-sp2-db2-ibm64.tar	20 MB
Linux	sde10-sp2-db2-lx.tar	16 MB
Linux64	sde10-sp2-db2-lx64.tar	17 MB
Solaris 64	sde10-sp2-db2-slrs64.tar	19 MB

Informix
IBM 64	sde10-sp2-inf-ibm64.tar	19 MB
Linux	sde10-sp2-inf-lx.tar	16 MB
Linux 64	sde10-sp2-inf-lx64.tar	17 MB
Solaris 64	sde10-sp2-inf-slrs64.tar	19 MB

Oracle 10gR2
HP-UX Itanium 64	sde10-sp2-ora10g-hpia64.tar	46 MB
IBM 64	sde10-sp2-ora10g-ibm64.tar	32 MB
Linux	sde10-sp2-ora10g-lx.tar	23 MB
Linux 64	sde10-sp2-ora10g-lx64.tar	24 MB
Solaris 64	sde10-sp2-ora10g-slrs64.tar	27 MB

Oracle 11g
HP-UX Itanium 64	sde10-sp2-ora11g-hpia64.tar	47 MB
IBM64	sde10-sp2-ora11g-ibm64.tar	31 MB
Linux	sde10-sp2-ora11g-lx.tar	23 MB
Linux 64	sde10-sp2-ora11g-lx64.tar	24 MB
Solaris64	sde10-sp2-ora11g-slrs64.tar	27 MB

PostgreSQL
Linux	sde10-sp2-pg-lx.tar	27 MB
Linux 64	sde10-sp2-pg-lx64.tar	28 MB

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.
Extract the specified tar file by typing:
% tar -xvf sde10-sp2-<Database>-<Platform>.tar
Start the installation by typing:
% ./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.
(Oracle only) Before upgrading the geodatabase, you must grant the following additional permissions to the ArcSDE administrative user in Oracle:
- 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
(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

This step only applies to Oracle users who have the ArcSDE component and the DBMS installed on separate servers. All other users proceed to the next step.

If you have the ArcSDE component and Oracle installed on separate servers, there are two shared libraries used by EXTPROC that must be copied to the Oracle server for ArcSDE 10 Service Pack 2. 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)

Install ArcGIS Desktop, ArcGIS Engine, or ArcGIS Server 10 service pack 2 onto the machine from which you will upgrade your geodatabase.
To upgrade, run the Upgrade Geodatabase geoprocessing tool or Python script. Failure to do so may cause problems in starting the service or with connecting to the geodatabase. See Upgrade Geodatabase (Data Management) for instructions.

NOTE: If you have user-schema geodatabases in Oracle, upgrade the SDE master geodatabase first, then upgrade the user-schema geodatabases.
(Oracle only) After the upgrade completes, you may revoke the following permissions from the ArcSDE administrative user 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
Restart your service.
% sdemon -o start
If you have more than one ArcSDE geodatabase, perform steps 2 through 11 for each of your ArcSDE geodatabases.

ArcSDE Server Installation for Windows

Installation Steps

Install this Service Pack using an administrator account, then upgrade your geodatabase using your ArcSDE administrator account.

Make sure you have write access to the ArcSDE installation folder, that no one is using ArcSDE, and that the ArcSDE service is stopped.
Stop your current ArcSDE service, if one is running.
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.
Copy the appropriate file to a location other than the ArcSDE installation folder:

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

Double-click the SDE10sp2-<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]\SDE10sp2-<Database>.msp
When the Setup installation wizard starts, follow the instructions on your screen to install ArcSDE 10 Service Pack 2.
(Oracle only) Before upgrading the geodatabase, you must grant the following additional permissions to the ArcSDE administrative user in Oracle:
- 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
(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
Install ArcGIS Desktop, ArcGIS Engine, or ArcGIS Server 10 service pack 2 onto the machine from which you will upgrade your geodatabase.
To upgrade, run the Upgrade Geodatabase geoprocessing tool or Python script. Failure to do so may cause problems in starting the service or with connecting to the geodatabase. See Upgrade Geodatabase (Data Management) for instructions.

NOTE: If you have user-schema geodatabases in Oracle, upgrade the SDE master geodatabase first, then upgrade the user-schema geodatabases.
(Oracle only) After the upgrade completes, you may revoke the following permissions from the ArcSDE administrative user 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
As the ArcSDE user, run the following command to restart the ArcSDE service:

c:\sdemon -o start

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

This step only applies to Oracle users who have the ArcSDE component and the DBMS installed on separate servers. All other users proceed to the next step.

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)

If you have more than one ArcSDE geodatabase, perform steps 2 through 12 for each of your ArcSDE geodatabases.

ArcSDE SDK Installation for UNIX

Installation Steps:

Copy the appropriate tar file to a location other than the ArcSDE SDK installation location:

All Databases (32 bit Operating System)
Linux	sde10-sp2-sdk-lx.tar	22 MB

All Databases (64 bit Operating System)
HP-UX Itanium 64	sde10-sp2-sdk-hpia64.tar	50 MB
IBM64	sde10-sp2-sdk-ibm64.tar	29 MB
Linux 64	sde10-sp2-sdk-lx64.tar	23 MB
Solaris64	sde10-sp2-sdk-slrs64.tar	28 MB

Extract the specified tar file by typing:
% tar -xvf sde10-sp2-sdk-<Platform>.tar
Start the installation by typing:
% ./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:

Make sure you have write access to the ArcSDE SDK installation folder.
Copy the appropriate files to a location other than the ArcSDE SDK installation folder:

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

Double-click the appropriate executable to start the install process.
When Setup starts, follow the instructions on your screen.

ESRI Products connecting to ArcSDE (application server and direct connections)

If you connect to ArcSDE 10 Service Pack 2 from ArcGIS 10, you must install the corresponding ArcGIS 10 (Desktop, Engine, Server) Service Pack 2 for your client product. The client updates contained in ArcSDE 10 Service Pack 2 are also included in ArcGIS 10 (Desktop, Engine, Server) Service Pack 2. This is necessary to maintain version compatibility between the client and the server applications.

• If you have an ArcSDE geodatabase in IBM DB2, IBM Informix, Oracle, or Microsoft SQL Server, you must install ArcGIS 10 Service Pack 2 then upgrade your geodatabase to implement all Service Pack 2 fixes. See the ArcGIS 10 (Desktop, Engine, Server) Service Pack 2 page for information on installing ArcGIS 10 (Desktop, Engine, Server) Service Pack 2.

• Instructions on how to upgrade can be found in the Upgrade Geodatabase (Data Management) help topic.

• ArcSDE geodatabases in PostgreSQL do not have to be upgraded after installing ArcGIS 10 Service Pack 2.

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

UNIX

Before you start, make sure you have write access to the installation directory then copy the appropriate compressed tar file to that location:

Linux

sde10-sp2-esri-lx.tar.gz

14 MB

Gunzip and extract the specified tar file for your platform. Ensure that the last letters of the file name are ".gz". Otherwise, the gunzip command will not work. At the UNIX prompt type:

% cd <Workstation Installation Directory>/lib (i.e. cd $ARCHOME)
% gunzip sde10-sp2-esri-lx.tar.gz
% tar xvf sde10-sp2-esri-lx.tar

Windows

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

sde10sp2-esri-win.zip

12 MB

Use WinZip to extract the new files from sde10-sp2-esri-win.zip to the appropriate installation folder, see list below:
- ArcGIS Workstation - <installation-folder>\arcexe10\bin

How to identify which Service Pack is installed

Windows
- To find out what ArcGIS products are currently installed on your machine, copy the PatchFinder utility and run it from your local machine.

UNIX/Linux
- To find out what ArcGIS products are currently installed on your machine, 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.

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.

May 23, 2011: Updated ESRI Products connecting to ArcSDE (application serverand direct connections) section.

May 24, 2011: Update to ArcGIS Server on Amazon EC2 users section.

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.