ArcSDE 10 Service Pack 1
This Service Pack contains performance improvements and maintenance fixes. Please download and install this required Service Pack at your earliest convenience.
Description
- Issues Addressed with ArcSDE Service Pack 1
- Files Updated with ArcSDE Service Pack 1
- Installing this Service Pack
ArcSDE Server
UNIX
Windows
ArcSDE SDK
UNIX
Windows
ESRI Products connecting to ArcSDE (application server and direct connections)
UNIX
Windows
- How to identify which Service Pack is installed
- Obtaining a DVD copy of the Service Pack
- Important Note for DB2 users who are upgrading from 10 to 10 SP1 ONLY.
- Service Pack Updates
- Getting Help
Installing this Service Pack
ArcSDE 10 must be installed before you can install ArcSDE 10 Service Pack 1. 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 1. If it does not, you can install ArcSDE 10 Service Pack 1 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.
Attention - Important Note for DB2 users who are upgrading from 10 to 10 SP1 ONLY. All others can proceed to the ArcSDE Server Installation instructions.
ArcGIS Server on Amazon EC2 users:New ArcGIS Server on Amazon EC2 AMIs (Amazon Machine Images) that include SP1 are available to existing ArcGIS Server on Amazon EC2 customers. Please see Technical Article 38569 for the latest information on the release of these new AMIs.
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:
- Stop your current ArcSDE service, if one is running.
- Extract the specified tar file by typing:
- Start the installation by typing:
- (Oracle only) Before upgrading the geodatabase, you must grant the following additional permissions to the ArcSDE administrative user in Oracle:
- (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 1. 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.so (Solaris, Linux, and HP-UX Itanium), libst_raster_ora_64.so (IBM) - Install ArcGIS Desktop, ArcGIS Engine, or ArcGIS Server 10 service pack 1 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:
-
ANALYZE ANY
ALTER ANY INDEX
ALTER ANY TABLE
CREATE ANY INDEX
CREATE ANY TRIGGER
CREATE ANY VIEW
DROP ANY INDEX
DROP ANY TABLE
DROP ANY VIEW
DROP ANY PROCEDURE
DROP ANY SEQUENCE
EXECUTE ANY PROCEDURE
SELECT ANY SEQUENCE
CREATE INDEXTYPE
CREATE LIBRARY
CREATE OPERATOR
CREATE TYPE
- Restart your service.
- If you have more than one ArcSDE geodatabase, perform steps 2 through 11 for each of your ArcSDE geodatabases.
DB2 | ||
IBM 64 | sde10-sp1-db2-ibm64.tar | 20 MB |
Linux | sde10-sp1-db2-lx.tar | 16 MB |
Linux64 | sde10-sp1-db2-lx64.tar | 17 MB |
Solaris 64 | sde10-sp1-db2-slrs64.tar | 19 MB |
Informix | ||
IBM 64 | sde10-sp1-inf-ibm64.tar | 19 MB |
Linux | sde10-sp1-inf-lx.tar | 16 MB |
Linux 64 | sde10-sp1-inf-lx64.tar | 17 MB |
Solaris 64 | sde10-sp1-inf-slrs64.tar | 19 MB |
Oracle 10gR2 | ||
HP-UX Itanium 64 | sde10-sp1-ora10g-hpia64.tar | 46 MB |
IBM 64 | sde10-sp1-ora10g-ibm64.tar | 32 MB |
Linux | sde10-sp1-ora10g-lx.tar | 23 MB |
Linux 64 | sde10-sp1-ora10g-lx64.tar | 24 MB |
Solaris 64 | sde10-sp1-ora10g-slrs64.tar | 27 MB |
Oracle 11g | ||
HP-UX Itanium 64 | sde10-sp1-ora11g-hpia64.tar | 47 MB |
IBM64 | sde10-sp1-ora11g-ibm64.tar | 31 MB |
Linux | sde10-sp1-ora11g-lx.tar | 23 MB |
Linux 64 | sde10-sp1-ora11g-lx64.tar | 24 MB |
Solaris64 | sde10-sp1-ora11g-slrs64.tar | 27 MB |
PostgreSQL | ||
Linux | sde10-sp1-pg-lx.tar | 27 MB |
Linux 64 | sde10-sp1-pg-lx64.tar | 28 MB |
% 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.
% tar -xvf sde10-sp1-<Database>-<Platform>.tar
% ./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.
-
ADMINISTER DATABASE TRIGGER
SELECT ANY TABLE
ALTER ANY INDEX
CREATE ANY TRIGGER
CREATE ANY INDEX
DROP ANY INDEX
CREATE ANY VIEW
DROP ANY VIEW
% sdemon -o start
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.
- Copy the appropriate file to a location other than the ArcSDE installation folder:
- Double-click the SDE10sp1<Database>.msp to start the install process.
- When the Setup installation wizard starts, follow the instructions on your screen to install ArcSDE 10 Service Pack 1.
- (Oracle only) Before upgrading your geodatabase in Oracle, you must grant the
following additional permissions to the ArcSDE administrative user in Oracle:
-
ADMINISTER DATABASE TRIGGER
SELECT ANY TABLE
ALTER ANY INDEX
CREATE ANY TRIGGER
CREATE ANY INDEX
DROP ANY INDEX
CREATE ANY VIEW
DROP ANY VIEW
- (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 1 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 administrator account:
-
ADMINISTER DATABASE TRIGGER
ANALYZE ANY
ALTER ANY INDEX
ALTER ANY TABLE
CREATE ANY INDEX
CREATE ANY TRIGGER
CREATE ANY VIEW
DROP ANY INDEX
DROP ANY TABLE
DROP ANY VIEW
DROP ANY PROCEDURE
DROP ANY SEQUENCE
EXECUTE ANY PROCEDURE
SELECT ANY SEQUENCE
CREATE INDEXTYPE
CREATE LIBRARY
CREATE OPERATOR
CREATE TYPE
- As the ArcSDE user, run the following command to restart the ArcSDE service:
c:\sdemon -o start
- 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 is one shared library used by EXTPROC that must be copied to the Oracle server for ArcSDE 10 Service Pack 1. Copy the new version of the appropriate file listed below to the Oracle server. Be sure the file copied is 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) - If you have more than one ArcSDE geodatabase, perform steps 2 through 12 for each of your ArcSDE geodatabases.
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.
DB2 | SDE10sp1-DB2.msp | 10 MB |
DB2 64 | SDE10sp1-DB2-64.msp | 11 MB |
DB2 z/OS | SDE10sp1-DB2zOS.msp | 10 MB |
Informix | SDE10sp1-Informix.msp | 10 MB |
Informix 64 | SDE10sp1-Informix-64.msp | 11 MB |
Oracle 10gR2 | SDE10sp1-Oracle10g.msp | 12 MB |
Oracle 10gR2 64 | SDE10sp1-Oracle10g-64.msp | 13 MB |
Oracle 11g | SDE10sp1-Oracle11g.msp | 12 MB |
Oracle 11g 64 | SDE10sp1-Oracle11g-64.msp | 13 MB |
PostgreSQL | SDE10sp1-PG.msp | 15 MB |
SQL Server | SDE10sp1-SqlServer.msp | 11 MB |
SQL Server 64 | SDE10sp1-SqlServer-64.msp | 11 MB |
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]\SDE10sp1-<Database>.msp
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-sp1-sdk-lx.tar 22 MBAll Databases (64 bit Operating System) HP-UX Itanium 64 sde10-sp1-sdk-hpia64.tar 50 MBIBM64 sde10-sp1-sdk-ibm64.tar 29 MBLinux 64 sde10-sp1-sdk-lx64.tar 23 MBSolaris64 sde10-sp1-sdk-slrs64.tar 28 MB - Extract the specified tar file by typing:
- Start the installation by typing:
% tar -xvf sde10-sp1-sdk-<Platform>.tar
% ./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:
- Double-click the appropriate executable to start the install process.
- When Setup starts, follow the instructions on your screen.
ArcSDE SDK 64 | SDE10sp1-CApiSDK-64.msp | 15 MB |
ArcSDE SDK | SDE10sp1-CApiSDK.msp | 15 MB |
ArcSDE Java SDK | SDE10sp1-JavaSDK.msp | 16 MB |
ArcSDE Java SDK 64 | SDE10sp1-JavaSDK-64.msp | 16 MB |
ESRI Products connecting to ArcSDE (application server and direct connections)
If you connect to ArcSDE 10 Service Pack 1 from ArcGIS 10, you must install the corresponding 10 Service Pack 1 for your client product. The client updates contained in ArcSDE 10 Service Pack 1 are also included in ArcGIS 10 Service Pack 1. This is necessary to maintain version compatibility between the client and the server applications.
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:
- 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-sp1-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-sp1-esri-lx.tar.gz
% tar xvf sde10-sp1-esri-lx.tar
- Before you start, make sure you have write access to the installation
folder, then copy the zip file to that location:
sde10sp1-esri-win.zip 12 MB
- Use WinZip to extract the new files from sde10-sp1-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.
Special instructions for DB2 users
This applies to upgrading ArcSDE from 10 to 10 SP1 ONLY. When you upgrade, a call to the stored procedure, SDE_RELEASE_PROC, is made to determine whether the ArcSDE schema, procedures, and functions need to be upgraded. At the end of the upgrade process, the SDE_RELEASE_PROC procedure itself is dropped and re-created. However, the DROP PROCEDURE fails as a result of locks. If a LOCKTIMEOUT has not been set, the process hangs. If LOCKTIMEOUT is set, the operation rolls back and the upgrade fails. In the error logs, you will see the following error message:
db_execute_ddlsql SQL Stmt: <DROP PROCEDURE SDE.sde_release_proc>
ERROR in creating system stored procedures.
Error: -1
DBMS error code: -454
SQL0454N The signature provided in the definition for routine "SDE.SDE_RELEASE_PROC" matches the signature of some other routine that already exists in the schema or for the type. LINE NUMBER=1. SQLSTATE=42723
Esri is working with IBM to resolve this problem under PMR - 67192,756,000.
The current workaround is as follows:- Open a DB2 command window on the client machine from which you will run the Upgrade Geodatabase tool or script.
- Connect to the ArcSDE geodatabase as the sde user.
db2 connect to <dbname> user sde using <sde_password>
- Drop the sde_release_proc.
db2 "drop procedure sde_release_proc"
- Once the stored procedure has been dropped, you can proceed with the upgrade.
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.
Getting Help
Domestic sites, please contact ESRI Technical Support at 1-888-377-4575, if you have any difficulty installing this Service Pack. International sites, please contact your local ESRI software distributor.